Data sorting
Closed
Jearnizck
-
Feb 24, 2014 at 11:23 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Feb 25, 2014 at 10:45 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Feb 25, 2014 at 10:45 AM
Related:
- Data sorting
- Tmobile data check - Guide
- Transfer data from one excel worksheet to another automatically - Guide
- How to be offline in whatsapp when data is on - Guide
- Data transmission cable - Guide
- Spectrum data usage - Guide
2 responses
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Feb 25, 2014 at 10:45 AM
Feb 25, 2014 at 10:45 AM
Hi Jearnizck,
When you select the second row of table 1 and apply Advanced Filter, check the unique records box and choose your destination where you want the result to be copied to. Result will be transposed, so transpose it back. Delete all unwanted data.
If you do all that while recording a macro, you can simply run the recorded macro to filter again.
But I've got a feeling I'm misunderstanding you. If I did then please explain in greater detail.
Best regards,
Trowa
When you select the second row of table 1 and apply Advanced Filter, check the unique records box and choose your destination where you want the result to be copied to. Result will be transposed, so transpose it back. Delete all unwanted data.
If you do all that while recording a macro, you can simply run the recorded macro to filter again.
But I've got a feeling I'm misunderstanding you. If I did then please explain in greater detail.
Best regards,
Trowa