Minimum function

[#1]

Hi all

I am trying hard to figure out a way for this. Kindly help.

I have the following table after doing some work on the base data.

Place	Warehouse	Source	Freight1	Freight2	Sum (Freight1, Freight2)
P1	WH1	S1	100	10	110
P1	WH1	S2	200	20	220
P1	WH2	S1	200	10	210
P2	WH2	S1	300	20	320
P2	WH2	S2	400	10	410

I want to add one column "Classification", which would give

     "L1" if the Sum column for a given Place is the MINIMUM among the available options.

     "L2" if the Sum column for a given Place is the 2nd MINIMUM and so on.

I have showed the example for 2 Places.

Something like this.

Place	Warehouse	Source	Freight1	Freight2	Sum (Freight1, Freight2)	Classification
P1	WH1	S1	100	10	110	L1
P1	WH1	S2	200	20	220	L3
P1	WH2	S1	200	10	210	L2
P2	WH2	S1	300	20	320	L1
P2	WH2	S2	400	10	410	L2

Thanks in advance.

[Gysbert_Wassenaar · Accepted solution]

See attached qvw.

[#3]

Thanks a lot Gysbert.

Just wanted to check if there is any way this could be done in the script.

Would be very helpful if a separate listbox could be made.

Thanks again