Compare values
Closed
Hemant
-
11 May 2010 à 00:35
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 11 May 2010 à 06:17
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 11 May 2010 à 06:17
Related:
- Compare values
- Beyond compare - Download - File management
- How to merge and compare two excel files - Guide
- Based on the values in cells b77 - Excel Forum
- Based on the values in cells b77 b88 ✓ - Excel Forum
- "Compare versions word" - Guide
2 responses
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
11 May 2010 à 06:11
11 May 2010 à 06:11
Could you please upload a sample file with sample data etc on some shared site like https://authentification.site and post back here the link to allow better understanding of how it is now and how you foresee.
venkat1926
Posts
1863
Registration date
Sunday 14 June 2009
Status
Contributor
Last seen
7 August 2021
811
11 May 2010 à 06:17
11 May 2010 à 06:17
quote
then subtract value in column d corresponding
'to c with value in l6
unquote
this is ambiguous
try this macro (if necessary modify the macro)
then subtract value in column d corresponding
'to c with value in l6
unquote
this is ambiguous
try this macro (if necessary modify the macro)
Sub test()
Dim x, cfind As Range, y As Double
x = Range("K6").Value
Set cfind = Columns("C:C").Cells.Find(what:=x, lookat:=xlWhole)
If Not cfind Is Nothing Then
y = Range("I6") - Cells(cfind.Row, "D")
MsgBox y
Else
MsgBox "the value is not available in col. C"
End If
End Sub
