if number occurs twice

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Good day,

If I've gat the same number showing up twice , can I get the name next to
the second number as well.
A B
10 me
11 you
12 he
11 she
currentl I'm getting -you under both number 11, as what I want are You and
she to show under 11.
 
If I am interpreting your question correctly, you should be able to use
AutoFilter and set the filter to 11 and both rows with 11 will display.

You will need a column header on each column to use AutoFilter. Check in
help for more information on AutoFilter.

Regards,

OssieMac
 
Back
Top