Same values in a column
Closed
JAI
-
May 5, 2010 at 08:07 AM
TIGERsHAKER Posts 53 Registration date Tuesday May 4, 2010 Status Contributor Last seen May 15, 2010 - May 5, 2010 at 01:46 PM
TIGERsHAKER Posts 53 Registration date Tuesday May 4, 2010 Status Contributor Last seen May 15, 2010 - May 5, 2010 at 01:46 PM
Related:
- Same values in a column
- Count the number of times a value appears in a column ✓ - Office Software Forum
- Display two columns in data validation list but return only one - Guide
- Excel copy column from one sheet to another automatically - Guide
- Based on the values in cells b77 b81 ✓ - Excel Forum
- Based on the values in cells b77 ✓ - Excel Forum
2 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
May 5, 2010 at 08:12 AM
May 5, 2010 at 08:12 AM
Not sure what you want
But you can use the formula
=COUNTIF(A:A,A1)
IF count is more than one it means that this item appears more than once
But you can use the formula
=COUNTIF(A:A,A1)
IF count is more than one it means that this item appears more than once
TIGERsHAKER
Posts
53
Registration date
Tuesday May 4, 2010
Status
Contributor
Last seen
May 15, 2010
11
May 5, 2010 at 08:16 AM
May 5, 2010 at 08:16 AM
hi
you may try Edit > Find > click option
put " Find what" the value you search for
put "Search" by columns
put " Look in" Values
hit ok
and hope this helps
you may try Edit > Find > click option
put " Find what" the value you search for
put "Search" by columns
put " Look in" Values
hit ok
and hope this helps
please help me for the below mentioned excel commands
https://authentification.site/files/22286718/merge_cells.xls
https://authentification.site/files/22286718/merge_cells.xls
TIGERsHAKER
Posts
53
Registration date
Tuesday May 4, 2010
Status
Contributor
Last seen
May 15, 2010
11
May 5, 2010 at 01:46 PM
May 5, 2010 at 01:46 PM
what do you want to do with this excel sheet?
May 5, 2010 at 12:18 PM