Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Count or Match Help Please
Good evening,
I have a date in cell D15 and six seperate numbers in cells E14:J14. I have a table in cells B24:M1000, with a date in column D and the six seperate numbers in columns E:J. I would like a formula in cell K15 that finds the date in cell D15 in the table B24:M1000 in column D and counts how many of the numbers in cells E14:J14 match the numbers in the table in column E:J for that specific date please. I am not sure whether to use count or match. Any help will be appreciated. Thanks in advance, Paul |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
count and match | Excel Discussion (Misc queries) | |||
count / match | Excel Discussion (Misc queries) | |||
Count if match any of 3 strings | Excel Worksheet Functions | |||
Count match of two criteria | Excel Programming | |||
match and count words | Excel Worksheet Functions |