Hi there,
I had another issue with this spreadsheet resolved a few days ago. Thank you everyone for their help.
This moves me onto my next problem however, which is setting up fairly complex formulas. I’d like to set the following formulas up in the first tab:
Firstly, depending on what is selected in column D in the first tab (tv or radio) I’d like to make the cell in column E or F for the same row be shaded out grey. So say TV is selected in cell D2, I obviously won’t need to select a radio supplier, so then cell F2 is shaded out, etc.
The second is more complicated, and I should note more important than the first, so if only one formula is possible I’d certainly take this one. I’d like the selection in column L (selection can be anything from 1 to 5) to contribute to an average in the data tables in the “Data” tab. The problem is, I want Column L to contribute to an average in particularly cells, depending on what is selected in columns A, and E or F in the first tab. Let me provide an example:
Say column A (region) is Brisbane, and in column F, we select the radio station as Nova. Once the campaign finishes the region gives its perceived success of the campaign as 4 out of 5. We’d then put 4 in column M. I’d then want this to contribute to the average in cells C5 (as its Brisbane radio), and F27 (as its Nova in Brisbane) in the “Data” tab.
I realise it would be quite labour intensive to set this up for all cells in the data tables but if someone could at least show me how to go about it in relatively simple terms that’d be absolutely grand. I have intermediate level knowledge of excel and this stuff is way out of my depth.
Thank you kindly for any help offered.
Regards,
Jamie.
Bookmarks