Hello,
I want to tag each record to A untill the sum of OS becomes equal or not great than A. then the next record should start taking B until the sum of OS is equal or not greater than B.
I have 20000 records and 44 tags to match up.
Hi,
In your workbook, the first example for Karthikeyan, the OS value is 475,998 but the tag is A? But in your lookup table the treshold value for A is 100,000?
Regards
Phil
Hi,
I have rectified the issue and also marked the result manually. Please see the file again and help me.
Hi,
is the value for D supposed to be 130,000?
Phil
Can you please check your examples, they don't seem to match up with the description of what you want - see attached image.
Phil
The sum do not match exactly to 100,000. So It should cover up little more than the tag amount.
um
You said
I want to tag each record to A untill the sum of OS becomes equal or not great than A. then the next record should start taking B
so if the sum of OS is greater than 100,00 shouldn't the tag for row 4 be B?
and what about the value for Tag D?
Regards
Phil
Please help me as per the results i made manually.
Hi Prem,
Excel doesn't understand "So It should cover up little more than the tag amount." Little more isn't something Excel can evaluate. You must give it exact instructions e.g. greater than, less than or equal to. There is no way to tell it 'a little more'.
In the attached file I've used an approximate match VLOOKUP to return the tag. If you want different tags, change the 'amounts' in column H.
Mynda
Thanks. This is meeting my requirement
S
