Same values in a column [Closed]

Report
-
TIGERsHAKER
Posts
55
Registration date
Tuesday May 4, 2010
Status
Contributor
Last seen
May 15, 2010
-
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

Posts
4475
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
January 6, 2016
756
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
Posts
55
Registration date
Tuesday May 4, 2010
Status
Contributor
Last seen
May 15, 2010
11
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
please help me for the below mentioned excel commands

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