Forum Discussion
Find max value in a data set but assign new value to result
Hi everyone, I'm using windows 10 and office 365. I was hoping you could help me to change the output of a max function. I'm trying to use a formula that would assign a value of 1/2/3 to the ...
- so it is interesting. you can also use:
=XMATCH(,range,-1) as long as all the values are numeric values but any text>number and blank is > text
but it appears you can use:
=XMATCH("",range,-1) as any text or blank is > "" and therefore only a number will be foundmtarler , good point
Nice, it's so easy to forget the MAX/MIN capabilities of XMATCH and its elder sibling XLOOKUP.
