Monday, October 6, 2014

yogi_Pull Latest Non-Blank JobStatus For A Specified Name From Table Of Name_ And_JobStatus

                  Google Spreadsheet   Post  #1781
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Oct-06-2014
post by  LT27:
Show Only Last Entry in Filter Formula

I am using a simple filter formula to show information from a larger spreadsheet.

I have =filter(Sheet2!B:B,Sheet2!A:A=A13)

Sheet 2 has all of the information. Row B is the job status. Row A is the name. A13 is the name I want to match!

For example

Name             Job Status
Jane Doe        In Process
Jane Doe        Informal Offer
Jane Doe        Official Offer

I would like a formula that only displays the LAST job status! So, I would only want Official Offer to show up on the sheet with the formula. 

I attached photos!

Thanks much!