subtract a existing values with condition Final Cell-First Cell

[mmr1]

Hi,


Required a formula help to subtract a values existing final cell value F3 & F4 with final cell C3 & C4 values like (F3-C3=Value & F4-C4=value).

Condition here is C3 and C4 values are always same do not have any changes are moving forward but in final cell value F3 and F4 it is not fixed its values are changing like F3 and F4 values not final may be G3 and G4 also add up in future.

And required as a solution would be Final Cell values-First Cell Values=Value.


Thanks,

Book1
	A	B	C	D	E	F	G	H
1
2
3		Expences	693940.96	695441	696941	3,000.00
4		Allowance	577504.74	583221.8	584721.8	7,217.01
5
6
7
8
9
Sheet2

 

[maabadi]

You can Use this Macro:

Sub FinalCell()
Dim Lcolumn As Long

Lcolumn = Cells(3, Columns.Count).End(xlToLeft).Column
Debug.Print Lcolumn
Range("A3").Value = Cells(3, Lcolumn).Value - Range("C3")
Range("A4").Value = Cells(4, Lcolumn).Value - Range("C4")
End Sub

 

[maabadi]

Or Use this UDF:

Function FinalCell(row As Range) As Long
Dim Lcolumn As Long
Dim i As Long
Dim y As Long

Lcolumn = Cells(3, Columns.Count).End(xlToLeft).Column

i = row.row

y = Cells(i, Lcolumn).Value - Cells(i, 3).Value
FinalCell = y

End Function

 

[FormR]

Hi, here's a native formula you could also try.

=C3-INDEX(C3:ZZ3,MATCH(9.99999999999999E+307,C3:ZZ3))

 

[Phuoc]

Or try:

=C3-LOOKUP(9.99999999999999E+307,C3:ZZ3)

 

[mmr1]

Thanks a lot all of you for your various types of solutions.