ExcelBanter - Match / find a value

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Match / find a value (https://www.excelbanter.com/excel-programming/338859-match-find-value.html)

tony wong

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

Tom Ogilvy

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

tony wong

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

All times are GMT +1. The time now is 12:12 PM.