Please need help, How do I get multiple number that match with their total, sorry may bad english
K Kenshin Member Jul 12, 2020 #1 Please need help, How do I get multiple number that match with their total, sorry may bad english Attachments Ask Excel.xlsx 12.1 KB · Views: 6
R rahulshewale1 Active Member Jul 12, 2020 #2 hi @Kenshin, See if is it okey? Attachments Ask Excel.xlsx 14.7 KB · Views: 4
R rahulshewale1 Active Member Jul 12, 2020 #4 Hi @Kenshin, What if value of sum not equal to criteria what Result you want ? Please provide output ?
Hi @Kenshin, What if value of sum not equal to criteria what Result you want ? Please provide output ?
P Peter Bartholomew Well-Known Member Jul 12, 2020 #5 This uses Solver with Simplex LP Maybe the same as @rahulshewale1 Attachments MatchedTotal.xlsx 12.5 KB · Views: 4
P Peter Bartholomew Well-Known Member Jul 12, 2020 #6 This file uses a Change Event macro to call Solver. I also demos the FILTER function for MSFT365 users. Attachments MatchedTotal.xlsm 20.8 KB · Views: 0
This file uses a Change Event macro to call Solver. I also demos the FILTER function for MSFT365 users.