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
How to find cells with same values in a column?


eg) A

1 1
2 1
3 1
4 2
5 2
6 3

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
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
0
TIGERsHAKER Posts 53 Registration date Tuesday May 4, 2010 Status Contributor Last seen May 15, 2010 11
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
0
please help me for the below mentioned excel commands

https://authentification.site/files/22286718/merge_cells.xls
0
TIGERsHAKER Posts 53 Registration date Tuesday May 4, 2010 Status Contributor Last seen May 15, 2010 11
May 5, 2010 at 01:46 PM
what do you want to do with this excel sheet?
0