Two new tables from one

C

ccostas

Hi

I have a table with 2 columns: Name and group

Name Group
John 1
Dan 2
Ron 2
Jenny 1
Jil 1

How do I make two new tables from the original one based on the group ie.
one table should contain only the names from group 1 and the other from
group 2.

Of course my real table consists of hundreds of entries


Many thanks
 
R

Richard O. Neville

Sort by the column headed "Group," then by "Name." Make a copy of the sheet
(right click tab name and follow prompts). On the original sheet, delete all
the entries from group 2; on the copied sheet, delete all from group 1.
 
Top