BLACK FRIDAY SALE 20% OFF ALL COURSES

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: 4647
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: El Riz, Tracy Lippiatt, Hannah Spink
Guest(s) 11
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
Catalin Bombea: 1864
SunnyKow: 1432
Anders Sehlstedt: 886
Purfleet: 414
Frans Visser: 346
David_Ng: 306
lea cohen: 241
Hans Hallebeek: 222
Jessica Stewart: 219
A.Maurizio: 213
Newest Members:
Karen Childress
Ben Penney
Karen Quagliano
Natsuko Kojima
George Girhiny
Jack Ennis
Andrew Griffin
Mostafa Younes
Alan Lim
ken lee
Forum Stats:
Groups: 3
Forums: 24
Topics: 6637
Posts: 29114
Member Stats:
Guest Posters: 49
Members: 33046
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen
© Simple:Press —
