Forum Discussion
amjadinsaudia
Oct 10, 2023Copper Contributor
Filtering Records Based On A Criteria Value
My requirement is to filter records based on a criteria value. List of records in Column A (Filter range) Criteria in Column B Output in Column C Criteria is sum of three different ranges i...
amjadinsaudia
Oct 18, 2023Copper Contributor
Now I added the actual data which goes to the ending range of line no. 231.
In this scenario Excel is replying "Too many variable cells"
File is attached for quick reference please.
Awaiting for a reply.
peiyezhu
Oct 01, 2024Bronze Contributor
If more than 200 parameters, some optimization solver available (e.g mindOpt https://opt.alibabacloud.com/portal)