 You don't need to be an 'investor' to invest in Singletrack: 6 days left: 95% of target - Find out more
I have a sheet set up that gives visual indication of what demand is in the business, when.
The demand topics are in various 'boxes', lets called them FOCUS1, FOCUS2, FOCUS3.
For the year we can score each month against those three boxes as to which will be the big demand. so under say February, I have rows with scores out of ten on them against the FOCUS.
This is then is used to create a line graph showing demand in the year and allowing us to quickly look at what we need to be doing when and where the spikes are. They're scored out of ten and we know that 1-3 is low demand, 4-6 medium, 7-10 high. We plan accordingly then - or more importantly, have a nice visual representation of demand to explain to others.
I also have a line of index searched scores per month - it looks down the month, picks the biggest score per and returns the specific FOCUS that is top. This is conditionally formatted to correspond colour-wise to the FOCUS and give another visual representation.
Still with me?
My question is as follows....
Each FOCUS can be broken down to a handful of specific TOPICS. So it could go
FOCUS1
- TOPICA
- TOPICB
- TOPICC
Is it possible to get the sheet to check which topic is the biggest in a WEEK and return the relevant FOCUS it sits within?
So, it is possible. It all depends on how your data is formatted, but assuming it's something like this:
[img] 
[/img]
The formula in C1 and C5 looks like this:
=IF(B3=MAX(B$3:B$7),IF(B4=MAX(B$3:B$7),1),0)
The values in column C return '1' if the highest value in B3:B7 is in either B3 or B4. The $ signs are there so you can copy it out downwards. The conditional formatting highlights the individual high scores (top 1) in the column B and C.
There will be a more elegant way of doing this but it depends on the format of your data and how robust it needs to be.
ah that's an interesting approach - i'll try to get a scan of my sheet to share. Cheers for having a look