Cell Reference
Solved/Closed
faqisoft
-
23 Jan 2010 à 02:54
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 25 Jan 2010 à 03:26
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 25 Jan 2010 à 03:26
Related:
- Cell Reference
- Cell phone codes - Guide
- How to delete cell in word - Guide
- Excel cell color formula - Guide
- Insert the current date and time in cell a1 ✓ - Excel Forum
- Excel multiple lines in one cell - Guide
3 responses
venkat1926
Posts
1863
Registration date
Sunday 14 June 2009
Status
Contributor
Last seen
7 August 2021
811
23 Jan 2010 à 19:46
23 Jan 2010 à 19:46
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
venkat1926
Posts
1863
Registration date
Sunday 14 June 2009
Status
Contributor
Last seen
7 August 2021
811
25 Jan 2010 à 03:26
25 Jan 2010 à 03:26
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.
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.
