
Prem Kiran
Active Member
Members

Forum Posts: 5
Member Since:
August 25, 2020
August 25, 2020

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.

Mynda Treacy
Admin

Forum Posts: 4513
Member Since:
July 16, 2010
July 16, 2010

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
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Cassie Bernier
Guest(s) 10
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 873
Purfleet: 414
Frans Visser: 346
David_Ng: 306
lea cohen: 222
Jessica Stewart: 215
A.Maurizio: 202
Aye Mu: 201
jaryszek: 183
Newest Members:
Abisola Ogundele
MARTYN STERRY
Rahim Lakhani
Ngoc Qui Nguyen
Clement Mansfield
Rose .
Bindu Menon
Baruch Zemer
Purple RainbowBenefactor
MOTH Junkie
Forum Stats:
Groups: 3
Forums: 24
Topics: 6350
Posts: 27773
Member Stats:
Guest Posters: 49
Members: 32317
Moderators: 3
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: MOTH Support, Velouria, Riny van Eekelen
© Simple:Press —
