Prem Kiran
Active Member
Members
Forum Posts: 5
Member Since:
August 25, 2020
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.
Mynda Treacy
Admin
Forum Posts: 4703
Member Since:
July 16, 2010
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
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Alan Sidman, Andrea Fernandez-Trujillo, Melvin Engelbrecht, Eugene Augustine
Guest(s) 8
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
Catalin Bombea: 1917
SunnyKow: 1432
Anders Sehlstedt: 900
Purfleet: 414
Frans Visser: 346
David_Ng: 306
Hans Hallebeek: 290
lea cohen: 246
Jessica Stewart: 219
A.Maurizio: 216
Newest Members:
Michal Kučera
Stephen Keating
David M Connelly
Quick Analytics
Peter Craven
Thomas Huybs
Cassandra McGuire
Leo Bonaparte
Excel Learner
david gavi
Forum Stats:
Groups: 3
Forums: 24
Topics: 6880
Posts: 30159
Member Stats:
Guest Posters: 49
Members: 33708
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen
© Simple:Press —