Good evening, I need your help to modify the formula that you find in the attached file D5 Rep sheet
to have the same result by putting it in cell D18 (yellow)
and drag right and down.
Thank you
Good evening, I need your help to modify the formula that you find in the attached file D5 Rep sheet
to have the same result by putting it in cell D18 (yellow)
and drag right and down.
Thank you
Please try at D18:G24
=INDIRECT($L$5&"!R"&4+ROWS(D$18:D18)&"C"&2+COLUMNS($D18:D18),)
4 is 1 row before data
2 is 1 column before data
Custom Format F18:G24 to hh:mm;;
Hi,Bo
it works
a question why we use R and C '
R "& 4 + ... R = Rows
C "& 2 + ... C = Columns?
thanks always for your precious help
This is R1C1 system
https://bettersolutions.com/excel/fo...1-notation.htm
R5C3 => C5
R6C4 => D6
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks