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
- How to delete cell in word - Guide
- Excel multiple lines in one cell - Guide
- Best cell phone 2023 - Home - Buying guides
- Conditional formatting if cell contains text - Excel Forum
- Cell color - Excel Forum
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.
