The 365 Data Science team is proud to invite you to our own community forum. A very well built system to support your queries, questions and give the chance to show your knowledge and help others in their path of becoming Data Science specialists.
Anybody can ask a question
Anybody can answer
The best answers are voted up and moderated by our team

Advanced Excel – Personal Question

Advanced Excel – Personal Question


Hello everyone!,
I have a question regarding Excel. I have two different markets, and when I search for the best place to sell items I need the name of the Excel market sheet to appear based on the result.
To explain better. From those markets I select the best items sold and look for the best sale of those. But I don’t know which is the market with the best sale. So I need to find a function to get the name of the sheet where they sell best.
Thanks for your help!

1 Answer

365 Team

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.