Search results

Ah! You genius! It works! It's a little slow but I'm not overly worried about that. That will teach me to muck about with formulas! Many thanks,I really appreciate your help!

Hi Luke and thanks I have amended the formula to reflect the columns and rows and it gives me the blank cell so I must have fudged it somewhere. Would you mind taking a look...

Hi all. I have a spreadsheet with a cell that holds an account name entered by the user in cell $Z$2. I then have this formula =OFFSET(INDEX(lastwk_account:lastwk_campaign,(MATCH($Z$2,lastwk_account,0)),2),0,) which returns the 1st campaign from a database list held in column lastwk_campaign...

Ah I see. The issue is that the campaigns change every week. This would then mean a manual update of the campaign list which I am trying to avoid. Is there a way of essentially saying, "look at cell K1 (where I enter an account name), for that account go and retrieve the campaigns that...

Hi Yes that sounds great. I was thinking about using data validation to have a drop down to select the company. Whilst I can do that bit, I wasn't sure on how to update the campaigns, cost etc.

To list it separately. there is probably an identifier missing in the database which I shall flag! Thanks Hui

Sure. https://skydrive.live.com/redir.aspx?cid=e87e6735d89888be&resid=E87E6735D89888BE!104&authkey=qRL4vq1Wo!4%24

Hi Hui Yes I have had a look at index and match but could not get the 2nd result. It returns the first result which is great, but now I need to get as many campaigns that belong to that account. Could you tell me how to get the 2nd,3rd etc campaigns? Many thanks Peter

Hi All Can someone help me here? I have in my sheet a data list with the following columns: account|campaign|impressions|clicks|cost|avg_position I then have all the accounts and their relevant campaigns. I am trying to construct a formula that looks at an account value in cell A1, then...

Think I will have to go back to using a pivot. Seems the formula is too much for Excel and it crashes! Thanks for your help!

HI Luke That is a beast! I will have a go. Tip of my hat to you Sir.

HI Luke Thanks for sticking with me on this. Hmm, I think in this case the auto filter is not suitable. All I want the team to have to worry about is refreshing the data in the data sheet and then it will update the results in the other sheet automatically. Do you have any further ideas on...

Hi Hui Thanks for the reply. Wouldn't this approach limit me to using the sheet the data is in? Unless I am missing something! What I am looking for is the formula equivalents of pivot tables. I currently have many pivot tables that show me a drop down of each account and then when selected I...

Thanks Luke I'm not sure how this formula will be able to pull out all the campaigns for that particular account for that date period. It seems to be fine if I want an overall accounts performance , I have something similar running though not as elegant...

HI Luke Many thanks for replying. You are spot on with the rollup. On the report_data sheet I have the data in columns a-k like this: date | account | campaign | campaign_status | adgroup | adgroup_status | impressions | clicks | cost | avg_pos | conversions The data is in date order from...

Hi All I am loving this site with all of its amazing knowledge. I am hoping someone can help me with my project. Whilst I am trying to learn more and more, this project is time sensitive and I am throwing it open to more knowledgeable people. By the way, I am using Excel on mac, Version 2011...