Hi there, thanks for clicking.
Preamble
I used to be a bit of a power user with Excel, although somehow I don't remember needing to create an array formula until now. And what's worse is I've been in a new job for a few years and don't remember a lot of the Excel skills I used to have!
The problem
I've replicated an array formula that works great. I can't post links because I'm new otherwise I'd reference where I got it from but I guess that doesn't matter. It's a formula to list some rows of data on a dashboard sheet where the date row is between specific dates.
But I also need to add something to the array, so as well as coping with specific dates, it only returns rows that meet another condition. In this case, only if the row's column titled 'Target' matches the Target value on the dashboard sheet should it return the row.
I tried inserting an IF function into the array, and it kinda works; it indeed will only return rows that meet the 'Target' condition. However, I clearly don't know what I'm doing because instead of a tidy array without gaps, my IF function would result in row gaps because it's not very clever. (I've removed the IF function from the attached). I can understand why it does this, just about, but not how to overcome it.
So I'm hoping some Excel guru could please take a look at this and let me know how to amend the array formula on the dashboard so it doesn't lose its current functionality but also only returns rows that match the 'Target' value. I hope this is clear.
Thank you!
Bookmarks