Subtract last column from first column Solved/Closed

Question

Hello, 



I am having a problem i have a excel sheet there are the data for various employees timing. first of all i want to search the last column and then i want to subtract that selected column from the column i have already mentioned. please help

Ex:  employee name  punchin punch punch punch   punch
      xyz                      12.30    1.00   1.15    2.15
    abc                         1.30     4.15   5.17    8.20   9.00

first i want to search the last column in a row and then i want to subtract them from first punch this process will be in loop.

Thanks in advance

ac3mark · Answer

OK, so lets say your sheet is formatted as so:
B1=xyz
C1=12.30
D1=1
E1=1.15
F1=2.15

Do you wish to have cell F1 subtracted from C1?

 
 
It's kind of fun to do the impossible! -Walter Elias Disney

vcoolio · Answer

Hello GauravKumar,

As you have mostly received a resolution to your query here:-

https://www.excelforum.com/excel-programming-vba-macros/1201356-subtract-last-column-from-first-column.html

and in order that the Volunteers here no longer waste their time on this cross-posted thread, I will now close this thread and mark it as solved.

In future, before posting, kindly read the Policies Charter here and the rules of other forums in relation to cross-posting without notification.

Please remember that our Volunteers' time is just as valuable as yours.

I trust that you understand.

Cheerio,
vcoolio.

Subtract last column from first column

2 responses

Similar discussions

Subscribe To Our Newsletter!