Skip to content

Instantly share code, notes, and snippets.

@theTonyHo

theTonyHo/EXCEL

Created May 7, 2015 01:15
Show Gist options
  • Save theTonyHo/9a083d5c9aa362e9a5fc to your computer and use it in GitHub Desktop.
Save theTonyHo/9a083d5c9aa362e9a5fc to your computer and use it in GitHub Desktop.
Download ZIP
Raw
EXCEL
###Latest Revision lookup
> When you want to find out the latest transaction in a transaction table.
Look up a value in a table to return the highest letter or value.
`=IFERROR(LOOKUP(2,1/(IF(DWG_Transactions[DRAWING]=[DRAWING],DWG_Transactions[ISSUE])<>""),IF(DWG_Transactions[DRAWING]=[DRAWING],DWG_Transactions[ISSUE])), "N/A")`
Assuming you have a table called `DWG_Transactions` with column `DRAWING` and `ISSUE`
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment