K
Kim
Hi there,
Can someone help me with a query. I need to give a ranking based on price in
certain city.
Exp:
A B C D
1 Item 1 LON 100.00
2 Item 2 MAD 80.00
3 Item 3 BCN 80.00
4 Item 4 LON 80.00
5 Item 5 LON 120.00
6 Item 6 BCN 85.00
Basically in column D, it should give me the ranking based on the cheaper
rate based on the same criteria on column B. The answer for above should be
2
1 (cheapest in MAD)
1 (cheapest in BCN)
1 (cheapest in LON)
3
2
Looking forward for your reply.
Thanks.
Kim
Can someone help me with a query. I need to give a ranking based on price in
certain city.
Exp:
A B C D
1 Item 1 LON 100.00
2 Item 2 MAD 80.00
3 Item 3 BCN 80.00
4 Item 4 LON 80.00
5 Item 5 LON 120.00
6 Item 6 BCN 85.00
Basically in column D, it should give me the ranking based on the cheaper
rate based on the same criteria on column B. The answer for above should be
2
1 (cheapest in MAD)
1 (cheapest in BCN)
1 (cheapest in LON)
3
2
Looking forward for your reply.
Thanks.
Kim