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     www.energyefficientbuild.com.   Oct-06-2014
post by  LT27:
(https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!category-topic/docs/spreadsheets/H6XKWrqE9l4)
Show Only Last Entry in Filter Formula
Hello!

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!
----------------------------------------------------------------------------------------------------------------------