LinkBack URL
About LinkBacks
Hi,
I cannot figure it out how to get second largest/smallest, in D3 i need 2.3 result, see attached wbook.
Any help would be most appreciated, thanks, God Bless.
Hi,
I cannot figure it out how to get second largest/smallest, in D3 i need 2.3 result, see attached wbook.
Any help would be most appreciated, thanks, God Bless.
Last edited by B.W.B.; 02-07-2024 at 02:57 PM. Reason: Forgot attach
Report
D2=IFERROR(AGGREGATE(14,6,Terminal!$D$4:$D$100/(Terminal!$B$4:$B$100=Report!B2)/(Terminal!$C$4:$C$100=Report!C2)/(Terminal!$B$4:$B$100<>""),ROWS(Report!$A$2:A2)),"")
Copy down
If you change your table for a named table (TTerminal) then the formula could be as follows.
Formula:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks