+ Reply to Thread
Results 1 to 16 of 16

Campaign plan with two tabs - content view AND date view

  1. #1
    Registered User
    Join Date
    10-17-2018
    Location
    Birmingham, England
    MS-Off Ver
    2016
    Posts
    8

    Question Campaign plan with two tabs - content view AND date view

    Hello,

    I have a spreadsheet that has a list of campaigns in column A and a list of marketing platforms in row 1 with dates plotted in the main body of the spreadsheet. I'd like the next tab to pull this information though but plot the dates along the top and display the marketing platforms in the centre - the list of campaigns in column A will stay the same for both tabs. The same date will be repeated multiple times in on the first tab, against different campaigns and marketing platforms. Is there a way to do this?

  2. #2
    Forum Contributor
    Join Date
    01-09-2016
    Location
    Perth Western Australia
    MS-Off Ver
    Office 365
    Posts
    257

    Re: Campaign plan with two tabs - content view AND date view

    Hi
    Can you please upload a sample of your spreadsheet, it will make understanding of the issue easier and assist greatly in devising a solution for you.

    Cheers

  3. #3
    Registered User
    Join Date
    10-17-2018
    Location
    Birmingham, England
    MS-Off Ver
    2016
    Posts
    8

    Re: Campaign plan with two tabs - content view AND date view

    Campaigns plan 2019.xlsx

    Hi, thanks. Please find it attached here.

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    62,198

    Re: Campaign plan with two tabs - content view AND date view

    What are we looking at here?

    Provide a smaller sample dataset that shows a before and after, manually mocked up, so we know what you are trying to achieve. Remember we can't see inside your head!
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" to anyone who has offered you help in your thread. You can reward them by clicking on * Add Reputation below theur user name on the left, if you wish.


    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.

  5. #5
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,059

    Re: Campaign plan with two tabs - content view AND date view

    Please try at Sheet Data view B2 and copy over the table

    =IFERROR(IF(OR(INDEX(INDEX('Content view'!$B:$T,MATCH($A2,'Content view'!$A:$A,),)=B$1,)),B$1,""),"")

  6. #6
    Registered User
    Join Date
    10-17-2018
    Location
    Birmingham, England
    MS-Off Ver
    2016
    Posts
    8

    Re: Campaign plan with two tabs - content view AND date view

    Campaigns 2019 - test.xlsx

    Hello AliGW, I've made a simpler version of the spreadsheet and filled in the information on the 'Date View' tab manually. I'm looking for a formula that can automatically input the information that's in the top cell of that column in the 'Content View' tab.

  7. #7
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    62,198

    Re: Campaign plan with two tabs - content view AND date view

    Did you try Bo-Ry's suggestion?

  8. #8
    Registered User
    Join Date
    10-17-2018
    Location
    Birmingham, England
    MS-Off Ver
    2016
    Posts
    8

    Re: Campaign plan with two tabs - content view AND date view

    Thanks Bo_Ry - this formula is successful at automatically pulling though the date - once it's picked up the date, is there a way to then pull though the info in the cell at the top of the column?

  9. #9
    Registered User
    Join Date
    10-17-2018
    Location
    Birmingham, England
    MS-Off Ver
    2016
    Posts
    8

    Re: Campaign plan with two tabs - content view AND date view

    Yes, the formula is successful at automatically pulling though the date - once it's picked up the date, is there a way to then pull though the info in the cell at the top of the column?

  10. #10
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,059

    Re: Campaign plan with two tabs - content view AND date view

    If you mean date for row 1 please try

    B1 drag to the right

    =IFERROR(AGGREGATE(15,6,'Content View'!$B$2:$E$4/('Content View'!$B$2:$E$4>MAX($A1:A1)),1),"")

    B2 copy over the table

    =IFERROR(INDEX('Content View'!$1:$1,AGGREGATE(15,6,COLUMN('Content View'!$A$1:$E$1)/(INDEX('Content View'!$A:$E,MATCH($A2,'Content View'!$A$1:$A$11,),)=B$1),1)),"")

  11. #11
    Registered User
    Join Date
    10-17-2018
    Location
    Birmingham, England
    MS-Off Ver
    2016
    Posts
    8

    Re: Campaign plan with two tabs - content view AND date view

    That's worked. Thank you!

  12. #12
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    62,198

    Re: Campaign plan with two tabs - content view AND date view

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

  13. #13
    Registered User
    Join Date
    10-17-2018
    Location
    Birmingham, England
    MS-Off Ver
    2016
    Posts
    8

    Re: Campaign plan with two tabs - content view AND date view

    Campaigns plan 2019.xlsx

    Bo_Ry, it's worked for the test spreadsheet I sent but I can't seem to get it to work for the main document - attached here. Also, I'm presuming this will mean I'm not able to have two dates on the same row of the 'Content view' tab?

  14. #14
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,059

    Re: Campaign plan with two tabs - content view AND date view

    Please see attached,

    Formula for B3 is
    =IFERROR(INDEX('Content view'!$A$1:$W$1,AGGREGATE(15,6,COLUMN('Content view'!$A$1:$W$1)/(INDEX('Content view'!$A:$W,MATCH($A3,'Content view'!$A$1:$A$107,),)=B$2),1)),"")

    On the Content view, I add 3/1/2019 at C5 it show BMM magazine article on the data view.
    But if you put same date on the same row it will show the first one on the left because AGGREGATE(15, will use the small number.
    Attached Files Attached Files

  15. #15
    Registered User
    Join Date
    10-17-2018
    Location
    Birmingham, England
    MS-Off Ver
    2016
    Posts
    8

    Re: Campaign plan with two tabs - content view AND date view

    Great, thank you

  16. #16
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    62,198

    Re: Campaign plan with two tabs - content view AND date view

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Return to worksheet from backstage view, i.e. close backstage view or exit backstage view
    By freddyroosevelt in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-18-2018, 12:44 AM
  2. Word Opens in DRAFT VIEW. How to open in PRINT LAYOUT view
    By Jenn68 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-28-2017, 06:47 PM
  3. View >> 'Bottum View' as standard at Startup of Outlook
    By Fschou in forum Outlook Formatting & Functions
    Replies: 0
    Last Post: 10-23-2012, 12:34 PM
  4. Replies: 3
    Last Post: 08-31-2012, 12:40 PM
  5. Replies: 2
    Last Post: 05-24-2012, 05:02 PM
  6. [SOLVED] Issue - replies/view count labels in New Posts view
    By teylyn in forum Suggestions for Improvement
    Replies: 5
    Last Post: 03-16-2012, 05:45 AM
  7. Rows are hiden in normal view but not printing view
    By aletoconstco in forum Excel General
    Replies: 1
    Last Post: 08-17-2006, 04:10 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1