Forum Discussion

Copper Contributor

Oct 08, 2021

Solved

Extracting the latest data

Hi I need to construct a data set from a data dump out of an database that will be loaded onto a webportal. At the moment, I have to do it manually, which is time consuming and I'm hoping that t...

excel

mathetes
Oct 08, 2021
RobMac14 Here you go. I've added some text boxes to explain what I've done, but as expected a combination of UNIQUE and FILTER (along with MAX) did the trick.
Data extract_Unique and Filtered.xlsx12 KB

mathetes

Gold Contributor

Oct 08, 2021

RobMac14 Here you go. I've added some text boxes to explain what I've done, but as expected a combination of UNIQUE and FILTER (along with MAX) did the trick.

Data extract_Unique and Filtered.xlsx12 KB

RobMac14

Copper Contributor

Oct 08, 2021

mathetes That's fantastic and thank you very much. I'll be able to replicate that for a much larger data dump and it'll save me a lot of time.

Thanks again for your time and enjoy your day.

Best wishes Rob