Create Unique Records based upon min value in one column.

[JeffGrant]

Hi bebo, please see that attached sheet.

Thanks

[Bo_Ry]

Please try at
O9
=SORT(UNIQUE(FILTER(BuildRecords,ISNUMBER(MATCH(BuildRecords[#Headers],O8:Q8,)))),{1,2})

R9

=MINIFS(BuildRecords[Time],BuildRecords[Course],INDEX(O9#,,1),BuildRecords[Distance],INDEX(O9#,,2),BuildRecords[Class],INDEX(O9#,,3))

[JeffGrant]

Hi Bo-Ry,

I am in absolute awe at the skill of you guys. I thought I was pretty good in the old days, but you guys just blow me away. Where can I learn to do this ????

I am just so excited to be in the company of people with such tremendous knowledge.

Saying Thank You just doesn't seem to be enough.

Jeff

[bebo021999]

Nice to hear it solved.
You can learn Excel here, in this forum. Try to answer the other questions is the best way to teach yourself.

[JeffGrant]

Hi Bebo, I have a little drama that I wasn't expecting.

When using PQ, I could then use this formula:
=MIN(IF(Build_Records[Course]=R5,(IF(Build_Records[Distance]=S5,(IF(Build_Records[Class]=T5,Build_Records[Min Time]))))))

where R5, S5 & T5 were matched to find the Min Time.


But now, with what you created, again my thanks because it is so much faster, I don't have a table and so how do I now reference the columns to retrieve the Min Time for the values that would be in R5, S5 & T5?

[bebo021999]

In current sample file, I could not find data in R5,S5,T5
Pls update the original file then upload again.
BTW, release "SOLVED" to get more solutions from other supporters.

[JeffGrant]

Hi Bebo, I have created the attached file to show you what I mean as an example.

Don't worry ,my friend, I wont hang on to you and be a pest. The solved part in the thread title is only to not upset the person who did the power queries.

With each new thread I will always make it open to anybody who is willing to help.

so much of this is so very different to what I learnt 100 years ago !!!!!!

I am from the Fortran 66 & 77 days. When Lotus 123 was the only spreadsheet in town :-(

cheers