Log in  \/ 
x
or
x
x
Register  \/ 
x

or

unanswered Formula extension help

  • prabhavathi.robert@gmail.com
  • prabhavathi.robert@gmail.com's Avatar Topic Author
  • Offline
More
1 year 3 months ago #1402 by prabhavathi.robert@gmail.com
Formula extension help was created by prabhavathi.robert@gmail.com
Hi,

I need help in one of excel formula where the formula needs to be changed horizontally when dragged, but this works only vertically, I need this in order to calculate Total Breaks from reference cell for each day.


='6th Feb'!K3 ( COLUMN "B") now when I drag this vertically it changes as ='6th Feb'!K4, ='6th Feb'!K5,='6th Feb'!K6 .which is good now I need this to be the same way for Horizontally along with date change and cell reference to be changed, but its not happening. Please help.

Big Thank you in advance.

Please Log in or Create an account to join the conversation.

Moderators: jaychivoExcelfansqiuhongkun