| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Match / find a value
there are values (3.1, 3.2, 3.3...) in column A.
i wish to check any match with the aforesaid value in the region (b1:f100). How can i do it? thanks a lot for your help. Tony |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Match / find a value
=SUMPRODUCT(COUNTIF(A1:A30,B1:F100))
-- Regards, Tom Ogilvy "tony wong" wrote in message ... there are values (3.1, 3.2, 3.3...) in column A. i wish to check any match with the aforesaid value in the region (b1:f100). How can i do it? thanks a lot for your help. Tony |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Match / find a value
Thanks Tom
it works to me. "Tom Ogilvy" bl... =SUMPRODUCT(COUNTIF(A1:A30,B1:F100)) -- Regards, Tom Ogilvy "tony wong" wrote in message ... there are values (3.1, 3.2, 3.3...) in column A. i wish to check any match with the aforesaid value in the region (b1:f100). How can i do it? thanks a lot for your help. Tony |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find the second match using the match function | Excel Worksheet Functions | |||
| Find an exact match and go to that match | Excel Discussion (Misc queries) | |||
| Where is "open/tools/find/find files that match these criteria"? | Excel Discussion (Misc queries) | |||
| Find partial match from column A,B and fill partial match in C? | Excel Discussion (Misc queries) | |||
| Find Exact Match using INDEX, MATCH | Excel Worksheet Functions | |||
Linear Mode
