Forum Discussion
tanacal
Mar 22, 2023Brass Contributor
Help on spill formula
Hi, May I have your help on a spilled formula? I have a table of data which was combined with two spilled areas (in the picture, the red and purple), then I would like to create a spill formula...
- Mar 23, 2023Thanks for your attention and help. For sure, I would like to streamline the processes. Can you please help me? I have sent you a message privately. Can you please let me know if you can offer yr help.
Patrick2788
Mar 23, 2023Silver Contributor
I had a look at the workbook before it was pulled. It seemed like the result you're looking for came from summarizing two different tables. It might help if you can upload a version of the workbook that contains the two tables and the desired results (Even if you have to enter them manually) for the overall project. Depending on what the expected results are, I think some of the intermediate steps can be eliminated.
tanacal
Mar 23, 2023Brass Contributor
Thanks for your attention and help. For sure, I would like to streamline the processes. Can you please help me? I have sent you a message privately. Can you please let me know if you can offer yr help.
- tanacalMar 23, 2023Brass Contributor
Thanks, Patrick. You nailed it!!