Alison has attended:
PowerPoint Introduction course
Excel
I receive a s/sheet each month with about 3500 entries on it. I would like to compare say the changes in column A that have taken place in the intervening period - for example between the Jan and Feb list. I would only need to look at the changes within that particular column and not the whole s/sheet. Can you advise if there is a simple way to do this and if so how.
Thank you for your assistance.
Kind Regards
Alison Fairley
RE: Excel
Hello Alison
Thank you for your question.
I believe Excel 2007 has an option within conditional formatting to highlight duplicates or unique entries. I think you would need to put both columns of data in the same spreadsheet for this to work, but I could be wrong.
Please note that in accordance with our fair use policy for the forum, that we are only supposed to answer questions that relate directly to the training you have undertaken with us; therefore we cannot guarantee that we will always be able to assist you with queries relating to applications and topics other than those covered on PowerPoint Introduction.
Kind regards
Amanda
