Hello,
Beginner user here, I have dates and prices, multiple prices for each date, I found the max price for each date using the formula =MAX(IF($B$2:$B$23996=B2,$E$2:$E$23996)) where B is my dates and E prices, this gives me a column with the same value for each date, so I can then filter and compare the highest price of each day with other columns like time of day.
I'd also like to visualise the top and bottom 10% of prices using true/false values either in separate columns or using conditional formatting, i was thinking the percentile(if()) function would do it, but not sure i'm formatting it right. Tried using some suggestions from ChatGPT but none have worked.
Does anyone know how to do this?
thanks
Bookmarks