last updates from the table only

[0li5a3a]

Hello,

I need to dislay always the last updates from an excel files. Please find the files attached,

scenario :

•Take the latest timestamp data for the month e.g. 28th March

•Exclude any data with in blank from Development

I tried already the max and firstsortedvalue but I can't display only the last updates.

Can someone advice me?

I want to display only this

Development	LGP	NGPF	G5b	G5F	BRNG	FCS	STD	FVB	OR	Comment	Timestamp
First	G2	Mar-18	Sep-18	Sep-18	£300	£250	£100	£50	Green	test3	27/03/2018 12:04
Second	G3	Mar-18	Sep-18	Sep-18	£300	£250	£100	£50	0	test2	27/03/2018 12:04
Third	G1	Mar-18	Sep-18	Sep-18	£300	£250	£100	£50	0	test1	27/03/2018 12:04

[sunny_talwar · Accepted solution]

Try this

Table:

LOAD Development,

    LGP,

    NGPF,

    G5b,

    G5F,

    BRNG,

    FCS,

    STD,

    FVB,

    OR,

    Comment,

    Timestamp

FROM

[Test Data.xlsx]

(ooxml, embedded labels, table is Sheet1)

Where Development > 0;

Right Join (Table)

LOAD Development,

Max(Timestamp) as Timestamp

Resident Table

Group By Development;

[0li5a3a]

Thanks for help, all good using your solution:)