hoaianhthu
New Member
- Joined
- Aug 23, 2007
- Messages
- 10
Hello there,
Below is my data example and I would like your help to write a fomular so it can return 2 stores for each region with the lowest rank. Can you please help? I try the index, but it seems not working with if condition. I already tried the array formular so that it can rank by region. Thanks for all of your helps.
thanks
Vivian
Store Region amount rank by region
197 1 63072.99 1
301 1 53032.32 2
133 1 36863.81 3
069 1 34736.26 4
300 1 33810.79 5
227 2 37891.7 1
109 2 35472.65 2
213 2 34936.23 3
233 3 42065.95 1
226 3 40145.01 2
192 4 41993.38 1
Below is my data example and I would like your help to write a fomular so it can return 2 stores for each region with the lowest rank. Can you please help? I try the index, but it seems not working with if condition. I already tried the array formular so that it can rank by region. Thanks for all of your helps.
thanks
Vivian
Store Region amount rank by region
197 1 63072.99 1
301 1 53032.32 2
133 1 36863.81 3
069 1 34736.26 4
300 1 33810.79 5
227 2 37891.7 1
109 2 35472.65 2
213 2 34936.23 3
233 3 42065.95 1
226 3 40145.01 2
192 4 41993.38 1