Removing duplicate data
Closed
Scriptowrite
Posts
1
Registration date
Thursday 17 July 2014
Status
Member
Last seen
17 July 2014
-
17 Jul 2014 à 11:49
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 4 Aug 2014 à 13:22
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 4 Aug 2014 à 13:22
Related:
- Excel data tab remove duplicates location ribbon
- Delete duplicates in excel - Guide
- How to copy data from one excel sheet to another - Guide
- Export data from excel - Guide
- How to remove location in viber - Guide
- Excel mod apk for pc - Download - Spreadsheets
6 responses
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
28 Jul 2014 à 11:59
28 Jul 2014 à 11:59
Hi Scriptowrite,
After selecting your data, go to advanced filter where you will find the option to only keep unique values which you then can paste to a different location.
After selecting your data, go to advanced filter where you will find the option to only keep unique values which you then can paste to a different location.
Mazzaropi
Posts
1983
Registration date
Monday 16 August 2010
Status
Contributor
Last seen
24 May 2023
147
30 Jul 2014 à 14:42
30 Jul 2014 à 14:42
Scriptowrite, Good afternoon.
At Excel 2007 an Advanced Filter option is under a DATA tab
At Excel 2007 an Advanced Filter option is under a DATA tab
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
31 Jul 2014 à 11:19
31 Jul 2014 à 11:19
Hi Mazzaropi,
Thanks for your input in this query.
I was wondering if you could help me translate the tab names in Excel, since I'm using a Dutch version and don't know the exact English translations.
From left to right my free form translation goes like:
File - Start - Insert - Page Setup - Formulas - Data - Control - View
Thanks in advance for your assistance.
Best regards,
Trowa
Thanks for your input in this query.
I was wondering if you could help me translate the tab names in Excel, since I'm using a Dutch version and don't know the exact English translations.
From left to right my free form translation goes like:
File - Start - Insert - Page Setup - Formulas - Data - Control - View
Thanks in advance for your assistance.
Best regards,
Trowa
Thanks. Found it Mazzaropi. I clicked on ? in the pop out to find how advanced filtering works and got rolls of unhelpful complicated text that shows little to resolve duplicated rows of data. On the suggestions mentioned in a reply to Trowa using an Access database to simplify the problem of showing copied data, what would you propose friend?
Mazzaropi
Posts
1983
Registration date
Monday 16 August 2010
Status
Contributor
Last seen
24 May 2023
147
31 Jul 2014 à 16:05
31 Jul 2014 à 16:05
TrowaD, Good afternoon.
"...since I'm using a Dutch version..."
I can not imagine how it looks like!
Your translation is very good.
Take a look at a English Version:
OR...
Is it what you want?
I hope it helps.
Have a nice day.
--
Belo Horizonte, Brasil.
Marcílio Lobão
"...since I'm using a Dutch version..."
I can not imagine how it looks like!
Your translation is very good.
Take a look at a English Version:
OR...
Is it what you want?
I hope it helps.
Have a nice day.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Mazzaropi
Posts
1983
Registration date
Monday 16 August 2010
Status
Contributor
Last seen
24 May 2023
147
31 Jul 2014 à 17:24
31 Jul 2014 à 17:24
Scriptowrite, Good evening.
"...simplify the problem of showing copied data, what would you propose friend?..."
Well, I don't know how complex your data are.
But, I believe that the TrowaD's suggestion is:
Supposing your scenario is data in A1:G5000
a) Choose ONE file to be the MASTER file. Anyone
b) Open the other file and COPY ALL DATA to the bottom of the MASTER file.
c) GO to --> DATA tab --> Advanced Filter
d) At Advanced Filter Dialog Box:
ONLY the UNIQUE ROW data will be copied to the new place.
I don't know if it's what you want.
But we are trying to help you.
Please tell us if it worked for you.
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
"...simplify the problem of showing copied data, what would you propose friend?..."
Well, I don't know how complex your data are.
But, I believe that the TrowaD's suggestion is:
Supposing your scenario is data in A1:G5000
a) Choose ONE file to be the MASTER file. Anyone
b) Open the other file and COPY ALL DATA to the bottom of the MASTER file.
c) GO to --> DATA tab --> Advanced Filter
d) At Advanced Filter Dialog Box:
ONLY the UNIQUE ROW data will be copied to the new place.
I don't know if it's what you want.
But we are trying to help you.
Please tell us if it worked for you.
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
4 Aug 2014 à 11:52
4 Aug 2014 à 11:52
Hi Mazzaropi (or do you prefer Marcílio),
So the first picture is Excel 2007 and the second Excel 2010?
I've recently switched from 2003 to 2013 and was expecting the blue ribbons but got the white ones (which I could swap for light-grey or, the one I chose, grey). By default it doesn't show the ribbon, for I guess a cleaner look.
This is how it looks:
By the way, it is exactly what I wanted, so thanks for your reply!
It is always a pleasure to read your neatly formatted reply's.
Many thanks,
Trowa
So the first picture is Excel 2007 and the second Excel 2010?
I've recently switched from 2003 to 2013 and was expecting the blue ribbons but got the white ones (which I could swap for light-grey or, the one I chose, grey). By default it doesn't show the ribbon, for I guess a cleaner look.
This is how it looks:
By the way, it is exactly what I wanted, so thanks for your reply!
It is always a pleasure to read your neatly formatted reply's.
Many thanks,
Trowa
Mazzaropi
Posts
1983
Registration date
Monday 16 August 2010
Status
Contributor
Last seen
24 May 2023
147
4 Aug 2014 à 13:22
4 Aug 2014 à 13:22
TrowaD, Good afternoon.
"...So the first picture is Excel 2007 and the second Excel 2010? ..."
No. Both are from MS Excel 2007.
The first one is a default view with a Blue ribbon and the second one is when you choose to use a classic layout as default.
"...I've recently switched from 2003 to 2013..."
WOW. It's a great jump.
"...It is always a pleasure to read your neatly formatted reply's. ..."
Thank you very much.
I feel happy that someone likes the way, I do my modest contribuition to the users of this wonderfull place of knowledge's collaboration.
Have an nice week.
Best regards,
--
Belo Horizonte, Brasil.
Marcílio Lobão
"...So the first picture is Excel 2007 and the second Excel 2010? ..."
No. Both are from MS Excel 2007.
The first one is a default view with a Blue ribbon and the second one is when you choose to use a classic layout as default.
"...I've recently switched from 2003 to 2013..."
WOW. It's a great jump.
"...It is always a pleasure to read your neatly formatted reply's. ..."
Thank you very much.
I feel happy that someone likes the way, I do my modest contribuition to the users of this wonderfull place of knowledge's collaboration.
Have an nice week.
Best regards,
--
Belo Horizonte, Brasil.
Marcílio Lobão
30 Jul 2014 à 12:44
We have since opened both the original and one of the few duplicate files on the display and ticked off duplicate rows which is a long process. When trying help search, suggestions were given to use an Access database by combining duplicates in tables. Thanx for your input.