Subtract last column from first column [Solved/Closed]

Report
-
vcoolio
Posts
1251
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 29, 2019
-
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
Posts
13031
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
October 11, 2019
1573
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
Posts
1251
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 29, 2019
207
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.