if number occurs twice
 

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 number occurs twice
 

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

"ekkeindoha" wrote:

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.