Forum Discussion
Re: Formula: chose data from different tables based on cell selection
What does the 1.11 (in each and every cell that has an entry) mean?
That it appears as a constant value is very odd, for something purporting to account for varying amounts of work or revenue.
Why all the blank rows?
Are there in fact more people responsible, and this is just a sample? Or does the data generator just waste space?
How does the Admin get rolled into this?
Is it Admin 1 connected with Location 1, etc? But Persons can be at any location, under any Admin?
In other words, describe the relationships between these "moving parts."
2 Replies
I have an update. My friend asked me to finish it as soon as possible because there will be no work from Friday on (holidays).
I have been working on it for a few days and found a solution that is not perfect but works properly. I used an additional Sheet and some extra tables that arrange the data from the exported Sheet in such a way that simple formulas could retrieve the values further and make all the calculations. I also kept an additional sheet where you can asign admins, people and locations as desired. If I only had had more time it might have been much cleaner (even better if we had found time to work together).
Thank you very much. I see your intention and I truly appreciate it. You're a good man. It was and always will be a pleasure to work with you on an excel table.You're very welcome. I always enjoy working on projects like this--helping to make something work more smoothly, efficiently. Your project has more room to improve than many, in no small part because of the nature of that raw data that you are forced to begin with.
So more can be done, I'm sure. If after the holidays you want to pick it up again, I'll be around. Have a blessed holiday season.
