I was going to have a go at this but the competition was just too quick.
For my own benefit, I put the code into the workbook so I could see how it worked. The result is attached.
One question for OllyXLS: your routine seems to double up in some instances, although not all. Why is that?
Regards, TMS
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
Ah, looks like you didn't delete the example results which were pre-filled in the output sheet. Apologies - I should have set my routine to clear the output range first.Originally Posted by TMShucks
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
@Rossg59b: Thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks