Hi, I've tried googling to figure this out if I could but I can't work it out.
I've attached my project file but what I am looking for is to get a list of the periods in B6:B57 to list in the left combo box on sheet 1 without any duplicates.
So that when I select for example period 3, I get the average result from period 3. But that will be a separate post. For this, just to get a list of Period 1 to 12 without duplicates in combo box.
Thanks
1. I deleted Table4 and replaced it with Table1 which now includes row five headers.
2. I added a new sheet: "UniqueLists"
3. To return the (named range: UniquePeriods) from sheet1, use **, column A:
4. A dynamic list of week numbers corresponding to the chosen period is returned to column B, with **:
Please Login or Register to view this content.
**CSE array formulasPlease Login or Register to view this content.
PeriodCount: =SUMPRODUCT(--(LEFT(UniqueLists!$A:$A,1)="P"))+1
WeekCount: =SUMPRODUCT(--(LEFT(UniqueLists!$B:$B,4)="Week"))+1
These are associated with the comboboxes on the graph sheet2.
Last edited by protonLeah; 05-13-2018 at 12:21 AM.
Ben Van Johnson
Thanks for your reply, took me a while to respond as I wanted to make a new workbook adding your suggestions to help me better understand what to do and how it works. I now have a list displaying the results I was looking for.
Leads me to needing further help on other matters but you helped me fix this issue lol, I'll keep adding new posts relating to new issues.
Thanks again
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks