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
- How to delete a column in word - Guide
- Display two columns in data validation list but return only one - Guide
- Based on the values in cells b77 ✓ - Excel Forum
- Return Seq Values Until Blank value then return different set of seq values ✓ - Excel Forum
- Excel count occurrences of string in column - Guide
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