My Online Training Hub

Learn Dashboards, Excel, Power BI, Power Query, Power Pivot

Match Numbers that add up to a Set Amount|General Excel Questions & Answers|Excel Forum|My Online Training Hub

You are here: Home / Match Numbers that add up to a Set Amount|General Excel Questions & Answers|Excel Forum|My Online Training Hub
Avatar
sp_LogInOut Log In sp_Registration Register
sp_Search Search
Advanced Search|Last Search Results
Search
Forum Scope



Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
sp_Search Search
sp_RankInfo
Lost password?
sp_PrintTopic sp_TopicIcon
Match Numbers that add up to a Set Amount
Avatar
Yuyun Sri Wahyu Ningsih

New Member
Members
Level 0
Forum Posts: 1
Member Since:
November 15, 2021
sp_UserOfflineSmall Offline
1
November 15, 2021 - 7:12 pm
sp_Permalink sp_Print sp_EditHistory

Hello guys...

I'm Yuyun.

first, sorry for my bad english

Here I want to ask for his help.

So, I was asked for help to find which numbers include member A and member B in a data.

The data has a table of kg, and a table of numbers.

I only have keys for the number of members A and B, the number of kg of A and B, then the number of numbers A and B.

I already have 2 ways. But the first way, is very long and may not find what I'm looking for. Then the second method can only contain 15 rows, while the data has several dozen rows.

Thank you very much.

Avatar
Anders Sehlstedt
Eskilstuna, Sweden

VIP
Members


Trusted Members
Level 3
Forum Posts: 873
Member Since:
December 7, 2016
sp_UserOfflineSmall Offline
2
November 16, 2021 - 6:53 am
sp_Permalink sp_Print

Hello Yuyun,

If you can upload a sample file with some dummy data so we understand what kind of data you have and how it is structured, it would be of great help. It would also be good if you showed in the sample what the expected result is.

Br,
Anders

sp_Feed
Go to top
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: ash seth, Cassie Bernier
Guest(s) 10
Currently Browsing this Page:
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: 6349
Posts: 27772

 

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