473,508 Members | 3,833 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

How to count occurrence of two cells value in a worksheet

1 New Member
I have an excel(2002) worksheet with 5 columns and 800 rows with random cells values. I would like to count how many cells in the worksheet have values like A1 & A2. For example, if A1=3, A2=11, C19=3, C20=11, A102=3, A103=11 then count value is 3. and so on.

Thanks for help.
Nov 14 '08 #1
2 1854
Frinavale
9,735 Recognized Expert Moderator Expert
Bump .
Jan 9 '09 #2
ADezii
8,834 Recognized Expert Expert
@jusking
  1. Wouldn't the Count Value = 4?
  2. Is this being done within Excel or Access?
Jan 10 '09 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

21
2475
by: rccf6178 | last post by:
Hi all, Do anyone know how to write a C program to count the frequency of a certain key pattern in a given datafile? Input: • Three alpha-numeric keys separated by space • A data file...
3
25308
by: Damian Arntzen | last post by:
I'm a beginner to moderate programmer who's fiddling around with automating Excel, in particular after being able to have the user fill out a form and it then generate the workbook. I can't quite...
1
4141
by: Howard Weiss | last post by:
I would like to set a particular cell in an Excel Spreadsheet to a specific value Visual Basic Equivalent would be Cells(row, column) = x where row and column locate the cell and x is the...
5
3027
by: mrid via DotNetMonster.com | last post by:
hi. im exporting data from a vb form to excel. i am able to create a new excel file, save and edit it without any trouble, but the formatting is giving me hell! i need to be able to show certain...
1
1751
by: Chris | last post by:
I'm sitting with a bit of an issue with pyExcelerator and creating an Excel file with certain cells protected while the rest of the spreadsheet is password protected. The Protection class under...
2
4659
by: shantanu | last post by:
Dear All My requirement is to count the number of cells which are blank in a excel column, for that i am writing the following code;;;;;;;;;;;;;;;;; private void ValidateReviewComment() {...
0
1370
by: Tetravaal | last post by:
I normally don't ask for help on forums, especially when I know that I am WAY out my league but if your feeling kind, feel free to contribute! I need to compare two cells (D2 and D3) and if they...
4
15464
by: ielamrani | last post by:
Hi, I am getting this error when I try to export to an excel sheet. When I click on a button to export the first time it's fine, I rename the exported excel sheet and I try to export it again and I...
1
5139
by: bluejeanbaby | last post by:
Hi I'm trying to format an Excel file from within VB.NET 2008 (Framework 2.0). I'm not very familiar with Excel but have taken existing working code from an old VB6 program and am "tweaking" it...
0
7228
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
7128
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
1
7058
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
7502
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
1
5057
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
4715
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
3191
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
1565
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
1
769
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.