CODEWITHSUNDEEP
google-sheets
Union Movil
Union Movil

Reputation: 71

Google sheets, how to create a table of Vlookup and get the last occurrence for each customer

I have a database of customers, where his zone, seller and some other values can change, and I want to generate a table of the last occurrence of each one

Heres a demo sheet

enter image description here

using Vlookup doesn't get the last occurrence

My database is very big and I need something to not slow my sheet that much, because I was using a formula like this one for each cell

=ARRAYFORMULA(LOOKUP(2,1/(C2:C=A2),$D$2:$D))

but the sheet is very slow because of this

Any help on this please ?

Upvotes: 1

Views: 88

Answers (1)

player0
player0

Reputation: 1

use:

=ARRAY_CONSTRAIN(SORTN(SORT({C3:E, B3:B}, 4, 0), 9^9, 2, 1, 1), 9^9, 3)

enter image description here

Upvotes: 1

Related Questions