A formula like this in a helper column:

=IF(A1=B1,"same","")

can be copied down, and then you could apply a filter to the column
and select "same" from the filter pull-down.

If you want to copy them to another sheet, highlight the visible data,
click <copy, move cursor to the other sheet, then press <Enter.

If you want to get rid of them from the first sheet, highlight the
visible rows, click on Edit | Delete Row.

Hope this helps.

Pete

On Jan 30, 7:14*pm, Kaylen wrote:
The groups are identified by the codes in columns A and B. The problem is
that the system spreadsheets has several groups with the same or similar
names but only one of the groups has the same code for both column A and B
and that is the group I take out for my spreadsheet. I have the same 200
groups so the list of the groups are the same, I just need to make sure the
info for my 200 groups are up to date with the info in the system spreadsheet
that contain 1400 groups! Is there a way to filter out the groups on the
system spreadsheet that have identical code for both column A and B? That
woould be the first step. Then I would have to manual filter out those
filtered groups that are on my list. At least this is a step faster. HELP!



"Pete_UK" wrote:
How are the groups identified? If it is by some code in a column then
you could use a helper column to identify your specific 200 groups
from the others, perhaps by means of a table which lists your 200
groups. Then you could make use of a filter on this helper column and
just copy/paste the data from the 200 groups into another sheet. Then
you would use this reduced set to update your master file.

You will need to give more details concerning what data you currently
have, how it is laid out etc and how you want to perform the update if
you need more specific advice.

Hope this helps.

Pete

On Jan 30, 6:40 pm, Kaylen wrote:
Hello everyone, one of my monthly tasks including updating this spreadsheet
by comparing my old spreadsheet with the new system generated spreadsheet..
The system spreadsheet has over 1400 groups. My spreadsheet only takes *200
groups out of those 1400 groups. All I concern is about the same 200 groups
every month. So I have to see if the 200 groups in the the system spreadsheet
has any changes, ad update the change for the groups on my spreadsheet. What
is the easy way to compare or filter out the 200 groups *from the system
spreadhsheet and update any difference for my spreadsheet? The two
spreadsheets are the same.

What I did last month is manually take out each one the 200 groups from the
1400 groups to create a new updated report for the current month. This has
takenlot of my time and I hope there is an easier way to do this. Any
suggestion is appreciated!- Hide quoted text -

- Show quoted text -