>> Skip blank across columns

[collegeitdept]

i have the following data


A ..... E F G H I ... U

101 11/3 11/6
102 11/3
104 11/4
106 11/3 11/7




I need a formula that will give me the store numbers (not blanks).... for a chosen weekday.


IE: For Tuesday..... in column U it should say: 102 & 106



i have this formula.... but it only works for one column (one weekday):

{ =IF(ROWS(U$3:U3)<=$U$2,INDEX('New Food'!$A$3:$A$693,SMALL(IF(NOT('New Food'!$E$3:$E$693=""),ROW('New Food'!$A$3:$A$693)-ROW('New Food'!$A$3)+1),ROWS(U$3:U3))),"") }



I tried adding the sumproduct to (so it looks across multiple columns) but it doesn't work.

{ =IF(ROWS(U$3:U3)<=$U$2,INDEX('New Food'!$A$3:$A$693,SMALL(IF(NOT(SUMPRODUCT(NOT(E$3:I$693="")*($E$1:$I$1=$W$1))),ROW('New Food'!$A$3:$A$693)-ROW('New Food'!$A$3)+1),ROWS(U$3:U3))),"") }





can anyone please help?

 

[collegeitdept]

When I try another weekday (text) in U1... like Wednesday....


=SUM(IF(1-(INDEX($E$3:$I$18,0,
MATCH(U1,TEXT(E1:I1,"dddd"),0))=""),1))


U2 says Friday.

Oh... I see what U2 does.... in reality it's just a larger number so from U1.

 

[Aladin Akyurek]

Oh... I see what U2 does.... in reality it's just a larger number so from U1.

U2 is the cell where a count of non-blank entries in the relevant day column is established.