Search results

Wow, it worked! Bravo, Narayan!!! So, it looks like that I need to modify my tab to have the extra columns in order to bring all the notes.. Which is not a big problem.. It’s doable. The problem that I see is that using array formulas in my original file slows down calculations. I’m...

Montrey, I want to figure this out too, but it looks like that the "mission is impossible". This is what I'm trying to do: 1)If I choose the start date from 1/1/2012 to end date 5/1/2012 for ID#1, Team1 I should see in the column B7: error;correct 2)If I choose the start date from 2/1/2012...

Montrey! thank you for trying, but it didn't work... Hope. Lost. Fired.

Guys, please, I still believe in Santa! If it's not possible to do it in one cell, then may be in a few next to each other?

Hi NARAYANK991! Thanks a lot for your help! I've tried these fromulas. They worked great to bring back the first notes of the selected date period. Do you know how to change the formula so it would bring back all the notes related for the selected period? For ex., if you select the date...

Hi Montrey! thank you so much for your reply. I've uploaded the file here : https://www.dropbox.com/s/b87xd0he64d6gs7/Excel1.xlsx The original file is more complicated, so I've made a small version of it. Thanks again!

Hi everyone! I need help to create a formula that brings back text values based on date range. For ex,. In the dynamic table I have a list of IDs (column A), value in column B is pulled from the other spreadsheet, which is a list of comments (notes). Dynamic tab: date start - (can be...