Large array of data, would like to auto look in 5 specified columns for any changes (in any of these columns) and then extract the data in that cell plus cells to the left and right into a table form.
Attached is a sample I created to illustrate.
Thank you!
The combination of entries in 5 columns means every row is unique. You would need to ignore the date column in your example.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Thank you!
Can you point me to resources to do the work?
>data>remove duplicates>unselect "date" and ok
Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks