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.

"ccostas" wrote in message
news:1142425976.577318@athnrd02...
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