Hello,
I have two column lists (one value in each cell) the first { 1 2 3 1 2 2 2 1 1 1 } and the second {A B C C C B B A A C } and I am attempting to find out how to auto count two criteria such as... if the first column is 1 and the second column is A then count. i.e for this example the answer would be..3.
Help?
Thanks
Configuration: Windows XP Internet Explorer 6.0
Auto number in cell a 1, 2, 3, 4, ... Check if a value in a cell is correct or matches with textbox value Checking for match cell within two columns Count how many times the cell contains the same two values Count number of days excel vb macro Count number of times two cells equal a specific value excell Count value in column if it meets criteria in another Countif with two match criteria for tow cell Excel 2003 make a cell change colors based on number value Excel increase count based on cell value Excel limit the number of word in cell Excel vba check if cell contains number or blank Excel vba, count number of rows and use in a formula Formula in excel to return number not cell reference How to calculate the number of cells with a formula How to count equal value cell in excel How to count number of words from excel worksheet in microsoft word Match row number cells of different sizes in two columns