Hi
A macro is required to identify rows within a selection e.g. entire column A, that share the same value, then delete appropriate rows depending on the values in another column. The attached example details the requirements.
If anybody can help that would be great.
Extract Rec1.xlsx
Thanks
Last edited by Andrew E Smith; 07-12-2014 at 12:19 PM.
Please Login or Register to view this content.
If solved remember to mark Thread as solved
Thanks for your reply. The formula works well on the sample I provided. However, on the actual file (which has over 3000 rows), the formula returns multiple rows for some of the Internal ID's.
The attachment below is the actual report (with all data randomised for confidentiality) to give it some scale.
EHF Masterfile.xlsx
I've also simplified the requirement as follows (so macro may need to be tweaked accordingly):
- The macro should return 1 row per internal ID with the most recent timestamp
Hi Andrew,
No VBA needed if you add a helper column and use an Advanced Filter. See the attached.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Hi Marvin
Thanks for taking time to look at this for me. I've done a couple of spot checks on the data in Q-T and I don't think its working as required as the latest timestamp is not showing e.g. 9002880 should be showing the 11th April but is showing 9th Jan.
Also hoping for something less manual i.e. a macro i can link to a button. Is this possible?
Hi Andrew,
Try the attached.
That is absolutely spot on sir. Thank you so much.
All the best. Andrew
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks