Reading latest entry from one sheet into another

Mobax · 12-27-2020 11:59 PM

Hi

I need to read the most recent entry from one Table into a section in another Table, The below formula reads the data into the sheet i need but the issue is it reads all the entries in. For example, if I have 10 entries listed it lists 10 entries instead of the most recent one. What part am i missing to make sure it only reads the most recent entry and not all entries related to this field.

Generator hour reading is the field i need to read through if the mobile registration in both tables match and the status is equal to C2. Refuel Completed. But i am missing a section of the formula to only read the most recent entry.

SELECT(refuel_by_bowser[GENERATOR HOUR READING], (AND([MOBILE REGISTRATION]=[_THISROW].[MOBILE REGISTRATION], [WIP STATUS]=“C2. refuel completed”)))

LeventK

You can create a VC with use of MAXROW() expression which will create a ref, and then you can de-reference whatever column value you want.