With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Sunday, July 23, 2017
yogi_Pull Row By Row Latest Account Information From Table Of Data In Another Sheet
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.