Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Same result when using switch formula

Hi Experts   I have the following switch formula to pull back the Top 10 Best performing product, but the switch formula keeps on giving me the same result for each product ...... i have check each...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    7 years ago

    Hi Anonymous,

     

    Can you share the file or a dummy one, please? You can mask the sensitive parts first.

    Did you make any selections? And only one selection of the two columns a time?

     

    Best Regards,
    Dale

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
7 years ago

Hi Anonymous,

 

Can you share the file or a dummy one, please? You can mask the sensitive parts first.

Did you make any selections? And only one selection of the two columns a time?

 

Best Regards,
Dale

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Morning dale. i haved managed to solve the answer