balsamatora
New Member
- Joined
- Sep 20, 2023
- Messages
- 6
- Office Version
- 2019
- Platform
- Windows
Thank you!Welcome to the Board!
What columns, exactly, are we looking at for value of 1?
We cannot tell from your image, as you cut off the column headers!
It goes quite a bit - to column ORI cannot see anything after column FG, because your image gets chopped off there.
How far out does it go?
ThanksOK, I originally did not understand your question fully originally (I thought you wanted to copy the value from the cell above E37, not the cell above the "1"), but I see now.
However, that leads to a whole new question.
In rows where you have multiple values of 1, which date do you want to put in column E?
For example, row 35 has a whole bunch of values of 1 in it. So which date do you choose to put in cell E35?
OK, then try this in cell E37:Thanks
Other rows are fine as they are. Question is only related to row 37.
Basically, on row 37, there is only one cell with value 1, all other cells have value of zero. I'd like to have a formula, where it sees in which column the "1" value is, and then takes the date above it, from row 32.
In practice, the formula should recognize the "1" value on FF37 and insert the date on row 32 (i.e. 30-06-2024) in cell E37.
=INDEX(EK$32:OR$32,MATCH(1,EK37:OR37,0))
Thank you very much.OK, then try this in cell E37:
Excel Formula:=INDEX(EK$32:OR$32,MATCH(1,EK37:OR37,0))