Subtract last column from first column [Solved/Closed]

Gaurav Kumar - Sep 15, 2017 at 07:43 AM - Latest reply: vcoolio 1159 Posts Thursday July 24, 2014Registration dateModeratorStatus March 28, 2018 Last seen
- Sep 18, 2017 at 03:26 AM
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
See more 

3 replies

ac3mark 9220 Posts Monday June 3, 2013Registration dateModeratorStatus April 25, 2018 Last seen - Updated by ac3mark on 15/09/17 at 03:18 PM
0
Helpful
1
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
Yes i wanted to subtract F1 from C1 but the problem is in all rows the punch is in different place some have on F1 some on G2 some on H3 i want to subtract that last from the first column of that row
vcoolio 1159 Posts Thursday July 24, 2014Registration dateModeratorStatus March 28, 2018 Last seen - Sep 18, 2017 at 03:26 AM
0
Helpful
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.