Hi,

Here are some options:

1. I do this only once:
First Mark your area incl. Headlines.
Menu: Data/Filter/AutoFilter
Klick on the small Arrow and to select Tom

2. I do this regularly:
Mark your area incl. the Headlines (include a few extra rows, for the future)
Menu: Data/Pivottable and Chart reports
Drop Names at the top, Computers as Row Item AND as Data Item.
Select Tom

3. I Want a formula:
Make a list on Sheet2
A1: 1
A2: 2
....
B1: =VLOOKUP(A1,Sheet1!A1:B100;2;0)
B2: =... (copy of the above)...
....

Ola