Forum Discussion
LET formula problem
In addition to the very valid observations by my friends Patrick2788 and Riny_van_Eekelen , I find myself wondering whether it's even necessary to have three separate sheets with exactly the same sets of columns.
If they are referring--a no doubt they are--to different entities, different products, people, services, whatever, you can still differentiate if you
- create a single table with those 12 columns you already have
- add a column that contains the Identifier of whatever it is that makes Sheet1 differ from Sheet 2, etc
So I've done that with the Sheet labeled "Combined" -- I haven't taken the time to go to your sheet 10 to work on your LET question. Just wanted to demonstrate a combined database.
With that combined database, for what it's worth, Excel could still separately report on each entity whenever desired--and do the composites and whatever else. And you can add new rows pertaining to any one of the entities in any order. Just identify them.
Riny_van_Eekelen
Patrick2788
mathetes
Thank you all for your amazing replies! You're completely right, I will take some time to analize what you wrote and then implement the solution that fits the best. I appreciate that you came up with different solutions. This is one thing that makes this community a better place 🙂
Best wishes!
alecsi
I appreciate that you came up with different solutions. This is one thing that makes this community a better place 🙂
In addition to making this community a great place, this variety of possible solutions is one of the things about Excel that makes it such a powerful tool: there are always several different ways to accomplish a result. It's exciting to play with those different constructions, different functions, different mental frameworks.