hello all.
i can't find my way through index() and match() functions to solve this out and need your help.
A1:AD1 --> numbers 1 to 30 [A1=1 B1=2... AD1=30]
A2:AD2 --> list of dates in a given month
A3:AD3 --> row filled by user, any cell can be blank, have one character or more
Is there a way to create one formula to get a list where, for example, in the same column there is the character "M" in the third row, the WEEKDAY() of the same column in the second row is 1 - 5 to return the corresponding number on the first row?
i don't know if it was clear...
for example, if there is one "M" in cells B3, E3, L3, P3 and V3 and if weekday() in cells B2, E2, L2, P2 and V2 i want the formula to return something like "2, 5, 12, 16, 22".
is this possible?
thanks in advance.
Bookmarks