I have a sheet that I am able to fill in from my data if the data matches a date.
I need to be able to fill in the sheet if the data falls between two dates and the data column Distr R starts with the two characters "12". Here is the array formula I am using:
Formula:
Please Login or Register to view this content.
F1 is the starting date. I have attached a sample workbook to assist in understanding what I am trying to do.
Ideas?
Thank you in advance for your assistance!
In B3 Cell - Array Formula - Requires CTRL+SHIFT+ENTER
=IFERROR(INDEX(Data!A$2:A$79,SMALL(IF((Data!$B$2:$B$79>=$F$1)*(Data!$B$2:$B$79<=$H$1)*(LEFT(TRIM(Data!$C$2:$C$79),2)="12"),ROW(Data!$B$2:$B$79)-MIN(ROW(Data!$B$2:$B$79))+1),ROW(A1))),"")
Drag it down and right...
Array formulas need to be entered using the key combination of CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT key then hit ENTER.
Last edited by :) Sixthsense :); 12-12-2013 at 09:57 AM.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Thank you very much!!!
I love you guys!!!! This site is so awesome!!!!!!!
Glad it helps you and thanks for the feedback and rep
Just so you know that I didn't use your formula verbatim. This is how it came out once I adapted it to my workbooks:
Formula:Please Login or Register to view this content.
Thank you again for your help!!!! The solution works like a dream.
Cliff
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks