Log In
Register
Home
Active Member
August 25, 2020
Offline
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.
See Answer
October 5, 2010
Offline
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
Active Member
August 25, 2020
Offline
Hi,
I have rectified the issue and also marked the result manually. Please see the file again and help me.
October 5, 2010
Offline
Hi,
is the value for D supposed to be 130,000?
Phil
October 5, 2010
Offline
Can you please check your examples, they don't seem to match up with the description of what you want - see attached image.
Phil
Active Member
August 25, 2020
Offline
The sum do not match exactly to 100,000. So It should cover up little more than the tag amount.
um
October 5, 2010
Offline
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
Active Member
August 25, 2020
Offline
Please help me as per the results i made manually.
July 16, 2010
Offline
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
Answers Post
1 Guest(s)
