Sunday, July 23, 2017

yogi_Pull Row By Row Latest Account Information From Table Of Data In Another Sheet

Google Spreadsheet   Post  #2211

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jul-23-2017
question by Guillermo Alda:
https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/tofb3EnObJs;context-place=forum/docs
query to show only last update
Hi there,

So I have a sales pipeline simple follow up file. 

In the "Input - updates"  sheet I put all the inputs of the accounts (customers) we are trying to sell to. Each row is a sales update.

So in the next sheet, "Output - status", I want to have the exact same columns but in the rows, I only want to see the latest update from each account. If there are duplicates, I only want to see the most recent date update - all the values must be the same that in the row of the last update.

I was thinking of doing it with a Query but it's not working out.

Please help, thanks in advance!

Guillermo