M myurathan New Member Jun 28, 2012 #1 I'm entering quaterly data into excel. second quater includes first quater amount. so i have to go individually and take first quater amount off. is there any easy way to do so, please let me know. Thanks in advance.
I'm entering quaterly data into excel. second quater includes first quater amount. so i have to go individually and take first quater amount off. is there any easy way to do so, please let me know. Thanks in advance.
Hui Excel Ninja Staff member Jun 28, 2012 #2 Myurathan Firstly, Welcome to the Chandoo.org forums. Why not use a helper column with an appropriate formula If your first Qtr value is in B2 and second Qtr value in B3 then in C3: =B3-B2 Then copy C3 down Add a Column header as appropriate
Myurathan Firstly, Welcome to the Chandoo.org forums. Why not use a helper column with an appropriate formula If your first Qtr value is in B2 and second Qtr value in B3 then in C3: =B3-B2 Then copy C3 down Add a Column header as appropriate
