Cell Reference

Solved/Closed
faqisoft - Jan 23, 2010 at 02:54 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jan 25, 2010 at 03:26 AM
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 responses

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Jan 23, 2010 at 07:46 PM
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
Suppose Serial No is in column A1 to A20, and data range is in B1 to B20.
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Jan 25, 2010 at 03:26 AM
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.