Sort & Filter

FILTER

An xlookup will produce a single result based on a criteria. A Filter can do the same but produce multiple results. Below I produce all results for vendor code "coosto"

Then, I used the sort function to order it from smallest to largest.

Comments

Popular posts from this blog

GETPIVOTDATA

Ranking of UC Schools from Top 110 Ranked National Universities of 2024

Xlookup specific value in the middle of a string