— CAN YOU SOLVE THIS - EXCEL CHALLENGE 133 —
(Solutions in any language are also welcome for Excel Challenges)
List the authors who have written more than one book and have the highest difference between Max of Sold and Min of Sold.
Agatha Christie’s Max and Min are 72 and 42. J. K. Rowling’s Max and Min are 44 and 14. Difference is 30 which is the highest among authors having written > 1 books.
Post answers in Comment.
(Your formula need not be a single formula. You can write multiple formulas to arrive at a solution. Also your formula need not be different from others as long as you have worked out your formula independently)
Download Practice File - https://lnkd.in/dA_xpbVA
#excel, #excelchallenge, #powerquerychallenge, #daxchallenge, #m, #dax, #powerbi, #powerquery, #powerpivot, #sheets, #googlesheets, #data, #analytics, #businessintelligence, #finance, #office365, #python, #r
Exel BI’s LinkedIn Post