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 replies

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
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