Min number from 2 columns
Hi - I would like help with following 1. I have 2 columns data , Col A with names (one name could be appearing several times) and a number in column B in each row. 2. I want to know for each change...
Formula solution with tabled data:
=LET( UniqueNames, SORT(UNIQUE(Table1[Name])), minimum, MINIFS(Table1[No. of days], Table1[Name], UniqueNames), HSTACK(UniqueNames, minimum) )Pivot solution field arrangement:
