software

Sort by the column headed quot;Group,quot; then by quot;Name.quot; 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.

quot;ccostasquot; gt; wrote in message
news:1142425976.577318@athnrd02...
gt; Hi
gt;
gt; I have a table with 2 columns: Name and group
gt;
gt; Name Group
gt; John 1
gt; Dan 2
gt; Ron 2
gt; Jenny 1
gt; Jil 1
gt;
gt; How do I make two new tables from the original one based on the group ie.
gt; one table should contain only the names from group 1 and the other from
gt; group 2.
gt;
gt; Of course my real table consists of hundreds of entries
gt;
gt;
gt; Many thanks
gt;
gt;
gt;