Dear All
please can correct my formula in two example i attached in excel file
Dear All
please can correct my formula in two example i attached in excel file
Try this in G2, then copied to the right:
=IF(OR(F22="", N(F22)+(1/24)>$B$18), "", F22+(1/24))
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
I need formula to be in D10:G12 in the first example
and in second example F22 To K23
=IF(($F$2-$F$1)*24+1>COLUMNS($D$5:D$5)+(ROW(1:1)-1)*4,330,"")
In D10
=IF(($F$2-$F$1)*24+1>COLUMNS($D$10:D$10)+(ROWS($1:1)-1)*4,330,"")
in F22
=IF(($B$18-$B$17)*24+1>=COLUMNS($F22:F22)+(ROWS($1:1)-1)*4,$B$17+((COLUMNS($F:F)-1)/24),"")
thanks for your solution
i have another question
if i need to do this in column instead of Row
how i can change in this formula to fit this change
Basically change row/columns
=IF(($F$2-$F$1)*24+1>ROWS($A$2:$A2)+(COLUMNS($B:B)-1)*4,330,"")
See Sheet2 of attached
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks