Subtract last column from first column

Solved/Closed
Gaurav Kumar - Sep 15, 2017 at 07:43 AM
vcoolio Posts 1411 Registration date Thursday July 24, 2014 Status Moderator Last seen September 6, 2024 - 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

2 responses

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 Posts 1411 Registration date Thursday July 24, 2014 Status Moderator Last seen September 6, 2024 262
Sep 18, 2017 at 03:26 AM
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.

Similar discussions