UNIQUE and SORT not getting me there...

[jatatreadwell]

First thanks in advance for those that take the time to read and offer suggestions. Here is my problem:

I have a sheet that contains three columns: date, name, and department. I want to pull each unique department along with the earliest date associated with that department into a new sheet. The original data can be in any order with any number of repeats. I don't need the name but just for accuracy.

Using Microsoft Office LTSC Professional Plus 2021 Excel version 2108

I've tried using UNIQUE and SORT together but I'm not having any luck with pulling the least dates for each.

 

[alansidman]

I used Power Query

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Grouped Rows" = Table.Group(Source, {"dept"}, {{"Min", each List.Min([date]), type number}})
in
    #"Grouped Rows"

Book6
	A	B	C	D	E	F
1	date	Name	dept		dept	Min
2	1	Jim	a		a	1
3	2	Betty	b		b	2
4	3	Bob	c		c	0
5	2	Sue	a
6	3	Tom	b
7	4	Betty	c
8	3	Jane	a
9	4	Joe	b
10	0	Jack	c
Sheet1

 

[hagia_sofia]

Hello, a formula option:

=UNIQUE(H2:H10)

=MINIFS(F2:F10,H2:H10,UNIQUE(H2:H10))

 

[jatatreadwell]

alansidman - Thank you but no Power Query​

hagia_sofia - You made it painfully simple. Thank you so much for exactly what I was looking for!​