Jun 01 2022 11:00 PM
I have been trying to solve a problem for some time now but unable to find an acceptable solution and hence requesting help from you. The attached has a snapshot of what I am trying to achieve. The problem I am facing is when the list goes beyond 100,000 rows, Excel runs out of resource.
The list contains duplicates as well as non-duplicates. I believe, if we restrict MMULT only for the duplicates, the "Out of Resource" error won't show up. I want the formula to do the following:
1. If unique (non-duplicate), simply consider the given value
2. If duplicate, then do MMULT (sum) for only the duplicate at hand and move to the next in sequence.
In the attached, "a", "b" and "d" are duplicated while "c" is unique. Want the formula to consider only "a" for MMULT and then separately for "b" and so on. Doing it together for "a", "b", "c" and "d" gives the "Out of Resource" error. The formula identifies "c" as unique and copies the corresponding value.
Please let me know if further clarification is required.
I wanted to upload the file but unfortunately couldn't find a link to do so.
Jun 02 2022 05:14 PM
Jun 02 2022 05:29 PM
Jun 03 2022 02:17 AM