https://365datascience.com/dwqa-answer/answer-for-advanced-excel-personal-question/ -
Hi Pablo!
Thanks for reaching out.
If I understand your goal correctly, I think that you can perhaps have an extra sheet where you can store this entire information (by referencing the different sheets that represent different markets), and then filter by market.
Then, having a formula that displays the name of the Sheet (I think it may depend on the version of Excel you are using, but INDEX(SheetName, cell-reference) should be displaying the correct output.
In any case, this is a great idea for an exercise, so thank you very much for asking this question!
Hope this helps.
Best,
Martin
#365datascience #DataScience #data #science #365datascience #BigData #tutorial #infographic #career #salary #education #howto #scientist #engineer #course #engineer #MachineLearning #machine #learning #certificate #udemy
No comments:
Post a Comment