Min number from 2 columns

[Nikhil865]

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 in name in Col A, the minimum number in col B corresponding to that name 

Name	No. of days
N1	59.00
N1	138.00
N1	207.00
N1	266.00
N2	38.00
N2	100.00
N2	153.00
N2	211.00
N2	229.00
N2	247.00
N2	285.00
N2	292.00
N3	185.00
N4	574.00
N5	31.00
N5	217.00
N5	284.00

Thanks 

[#2 · Accepted solution]

@Nikhil865 

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:

[#3]

Thank you very much. Worked like a charm.

Nikhil

[#4]

Glad to help. You're welcome!