Hi – I think I need some VBA code to do what I’m trying to achieve…if anyone can help, I’d be very grateful. I’ll try to explain…
I have a spreadsheet with thousands of rows and I need to extract a “clean” sheet with the latest version of each row, so I am only analysing the most recent data.
I have the following columns headers:
A Date and Time Stamp (mm/dd/yyyy hh/mm/ss)
B Football team name
C District council
D:Z (other relevant data for each row)
There are multiple entries for each combination of football team name and district council (plus the other relevant data in D2:Z2) each row entry is date and time stamped. I need to extract only the latest rows for each unique combination of football team/district council. However, I cannot define all the possible combinations in advance – there will be hundreds if not thousands. So…this is my thought processes:
I have tried concatenating B2 and C2, then doing an advanced filter to give me the unique entries. This does work and could possibly work as a key / unique lookup list. But then I need to run something (perhaps a MAX lookup formula?) to find the latest entry based on date and timestamp of that unique combination of football team name and district council and give the full row of data for each of those instances, in a fresh sheet.
Can anyone help me with this? I am not experienced with writing VBA code, but I think VBA is probably the way to go.
I have a spreadsheet with thousands of rows and I need to extract a “clean” sheet with the latest version of each row, so I am only analysing the most recent data.
I have the following columns headers:
A Date and Time Stamp (mm/dd/yyyy hh/mm/ss)
B Football team name
C District council
D:Z (other relevant data for each row)
There are multiple entries for each combination of football team name and district council (plus the other relevant data in D2:Z2) each row entry is date and time stamped. I need to extract only the latest rows for each unique combination of football team/district council. However, I cannot define all the possible combinations in advance – there will be hundreds if not thousands. So…this is my thought processes:
I have tried concatenating B2 and C2, then doing an advanced filter to give me the unique entries. This does work and could possibly work as a key / unique lookup list. But then I need to run something (perhaps a MAX lookup formula?) to find the latest entry based on date and timestamp of that unique combination of football team name and district council and give the full row of data for each of those instances, in a fresh sheet.
Can anyone help me with this? I am not experienced with writing VBA code, but I think VBA is probably the way to go.