ThrottleWorks
Excel Ninja
How to use combination of SMALL & IF condition
Sir, I want to use combination of SMALL & IF condition.
I have 2 columns, Column A name of customers, Column B amounts.
For example Sachin has amounts 500,400,300,200,100.
If I use small 1, small 2, small 3 then it should give me 100, 200, 300 etc.
Can anyone help me in this please
Sir, I want to use combination of SMALL & IF condition.
I have 2 columns, Column A name of customers, Column B amounts.
For example Sachin has amounts 500,400,300,200,100.
If I use small 1, small 2, small 3 then it should give me 100, 200, 300 etc.
Can anyone help me in this please