Menu
  1. Accueil
  2. Tech Forum
  3. Office Software

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
See more

2 replies

Answer 1 / 2
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
Answer 2 / 2
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
Report

please help me for the below mentioned excel commands

https://authentification.site/files/22286718/merge_cells.xls
Report
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?
Ask a question