I am setting an internal client influencer tracker and am trying to create a 'main sheet' so i can see the information i need to extract at any given time.
I am trying to pull through the below on the main sheet but am stuck how to best do this as the information i need is dependent on the criteria from different worksheets.
I have attached the worksheet
There was no start date for Two/Post 1 so i added one.
Use formulae like this one:
=INDEX(INDIRECT("'"&$B3&"'!E:E"),MATCH($C3,INDIRECT("'"&$B3&"'!C:C"),0))
The others are in the file.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Thanks. Some of the posts will have multiple influecners for example under tab Akzonobel 'Story 3' has various influencers. Is there a way all of them can be listed when i select 'Story 3'
Also, on columns H-L on the 'main sheet' would it be possible to get the Yes and No pulling through too so i can see which platform they are working on?
Possibly, but. The ease of doing so depends on the Excel PRODUCT that you are using. Excel 2017 does NOT exist. Please check and tell us what you ARE using. the lastest ones are O365, Excel 2021, Excel 2019....
or is Excel 2017 a Mac version??
I am using excel 2016
OK . Kindly amend your profile to show Excel 2016.
Is a VBA-based solution OK with you?7
Also, what is the maximum number of influencers for a single post?
Administrative Note:
Welcome to the forum.
We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not told us about this. You are required to do so. Cross-posts are allowed but you must provide a link to your posts on other sites.
Please see Forum Rule #7 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important: https://excelguru.ca/a-message-to-forum-cross-posters/
(Note: this requirement is not optional. As you are new, I shall do it for you this time: https://www.mrexcel.com/board/thread...heets.1256203/)
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
The most would it would ever be would be 20
No. My alternative to VBA won't work. If you want them all in one cell:
1. VBA.
2. Upgrade to O365 (preferably) or Excel 2021.
BUT, you haven't told us how you want the results to be presented. So how do you want them to look?
The results don't need to be in one cell. They can be as a list. So if Story 3 was selected under Akzonobel then it would appear as the attached
Did you read and understand post #8?
You still need to update your forum profile to 2016, please.
No sorry i don't understand as only joined this forum today.
Try it now. But I see a further complication. It seems to be possible to select TWO storys in the same cell. Is that intentional? If so, this complicates everything enormously...
See below and then update your profile, please.Originally Posted by abz2786
It seems to be working ok as i need.
Would it be possible to have a formula that will show all the 'Live' campaigns for a particular client. For example when i select Akzonobel from a dropdown cell C8 shows a list of 'live' campaigns - in this instance Story 3 and Story 4.
Is this the same query or a new pone? If it's a new question, then you need to mark this thread as SOLVED and start a new one with a suitable title.
same query
Try:
=IFERROR(INDEX(INDIRECT("'"&$B$8&"'!C:C"),AGGREGATE(15,6,ROW(INDIRECT("'"&$B$8&"'!C3:C100"))/((INDIRECT("'"&$B$8&"'!F3:F100")>=TODAY())*(COUNTIF(C$7:C7,INDIRECT("'"&$B$8&"'!C3:C100"))=0)),1)),"")
copied down.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks