Find Bottom 3 on Day Range

[Daqurezs]

Hi experts, need your help...

I have 3 days data range, where's each date have 50 data value. hows the formula, if I want to get data bottom 3 on each day (Exclude blank data)

[Estevaoba]

Try this in a blank cell and copy down:

Please Login or Register  to view this content.

Good luck!

[Daqurezs]

Hy Estevaoba, thank's for your quick reply

But the result is not like what i want, where's each day only show 3 worst value. here's the result when manually using sort data
Attachment 762658

1/1/2021 1/2/2021 1/3/2021
59.95864569 61.40651223 66.68696888
60.48449483 64.89846753 67.51135598
67.44310333 69.73330519 74.05216486

[Glenn Kennedy]

One way:
=TRANSPOSE(UNIQUE(FILTER(A2:A50000,A2:A50000,"")))

and
=TRANSPOSE(AGGREGATE(15,6,FILTER($B$2:$B$50000,$A$2:$A$50000=F2,""),{1,2,3}))

next time... check out the yellow banner (top) to see the suggested number of rows in a sample file.... 10-20, not almost 50,000.

[Estevaoba]

You're welcome. Thank you for your feedback.
Another way, after a tweak to formula in post #2:

Please Login or Register  to view this content.

[kvsrinivasamurthy]

In G2 then copied across. Pl see file.

=IFERROR(AGGREGATE(15,6,$B$2:$B$49500/($A$2:$A$49500=G$1),ROWS(G$2:G2)),"")

[Daqurezs]

Hy glenn,

thx for your quick reply, it's look work so great

[Daqurezs]

nice, your correction is look so nic

thx

[Daqurezs]

In G2 then copied across. Pl see file.

=IFERROR(AGGREGATE(15,6,$B$2:$B$49500/($A$2:$A$49500=G$1),ROWS(G$2:G2)),"")

Hy , thx for your reply

your formula work's great too