Cell Reference

[Solved/Closed]
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
Hello,
I need a formula that can check a specific value in a range of values and show the cell location for each time the value is find

Suppose we have to find location of 40 in a column where 40 is at s.no 2, 5, and 9 so the formula must return 2,5 and 9.

regards

3 replies

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
801
Is the serial number is entered in column A form A2 down(row1 is for column headings) and the data (e.g. 40) in column B . confirm
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Suppose Serial No is in column A1 to A20, and data range is in B1 to B20.
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
801
There are many ways of doing it
highligsht B1 t0 B20
edit -find(or control +F).
against find what type
40
and click findall
you will get below find dialog box
B2,B5,Bo

that means serial nos. are 2,5,9

another way
in C1 or in any empty cell in that row 1 type this formula
=IF(B1=40,A1,"")
copy C1 down up to C20 and see what happens.