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
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jan 25, 2010 at 03:26 AM
Related:
- Cell Reference
- If cell contains date then return value ✓ - Office Software Forum
- Conditional formatting if cell contains text - Excel Forum
- An example of a cell is a blank cell ✓ - Programming Forum
- Excel: If Date =, then enter a value ✓ - Excel Forum
- Excel "IF" function w/ date in test cell ✓ - Excel Forum
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
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
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Jan 25, 2010 at 03:26 AM
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.
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.
