>> Skip blank across rows - Multiple Variables

[collegeitdept]

View data source here:

https://skydrive.live.com/redir.aspx...ATK6iYb-fMg5LA


I need a formula like the SUMPRODUCT (multiple criteria) then skip the blanks (rows) cells.

ie: =IF(ROWS(U$3:U3)<=$U$2,INDEX($A$3:$A$18,
SMALL(IF(1-(INDEX($E$3:$I$18,0,
MATCH(U$1,TEXT($E$1:$I$1,"dddd"),0))=""),
ROW($A$3:$A$18)-ROW($A$3)+1),ROWS(U$3:U3))),"")



The formula i need would be to list only the centers for the Weekday Wednesday (Column G) based on Location variable (Column B) and Number (Column C).



Main Worksheet:

Column A Column B
Today Day: weekday(today)
Location: Lancaster - 9932
Number: 3300708

Formula listings...




For the weekday (wednesday Column G) variable... it will also have change based on today weekday number.... So on Thursday it will have to search for Thursday on the data sheet which is Column H.



Thanks.

 

[collegeitdept]

we can break it maybe... by having one column compare to the original column in cells A4:A34 maybe?

 

[T. Valko]

It doesn't work.... says too many nested formulas.

What version of Excel are you using? It's getting kind of hard to follow this as it keeps changing and expanding!

 

[collegeitdept]

Excel 2007

 

[collegeitdept]

I think maybe it would be best to make into a 2 step process... the first to pull the deposit data.... the next to remove (unique values) centers already listed in A5:A34... and then a formula to list the new center list removing all banks.

 

[T. Valko]

I think maybe it would be best to make into a 2 step process... the first to pull the deposit data.... the next to remove (unique values) centers already listed in A5:A34... and then a formula to list the new center list removing all banks.

Can you post an up to date file so I can see what's what?