This is my first post on here and I hope someone can help me as this is making my brain hurt!
So I want to make an array formula that returns the row number if someone has entered a number 1 in a cell. The problem I'm having is i need the formula to look at different columns depending on a drop down box list.
so far I have {=IFERROR(SMALL(IF(1=N:N, ROW(N:N)-ROW($N$6)+1), ROW(6:6)),"")}
This is the first few columns of my sheet it goes on for the full school year my and the data in the drop down boxes will be the dates from this sheet
Maths | English | Cre | Gego | science | etc |
18th sep | 19th sep | 20th sep | etc | etc | etc |
1 | 1 | 1 | |||
1 | |||||
1 | 1 | ||||
1 |
<tbody>
</tbody>
I'm knew to posting so if you need anymore information just let me know