Looking for help in Excel
Closed
Manoj
-
29 Oct 2010 à 05:17
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 29 Oct 2010 à 22:21
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 29 Oct 2010 à 22:21
Related:
- Looking for help in Excel
- Excel mod apk for pc - Download - Spreadsheets
- Kernel for excel repair - Download - Backup and recovery
- Arrow keys not working in excel - Guide
- Vat calculation excel - Guide
- How to clear formatting in excel - Guide
2 responses
venkat1926
Posts
1863
Registration date
Sunday 14 June 2009
Status
Contributor
Last seen
7 August 2021
811
29 Oct 2010 à 05:38
29 Oct 2010 à 05:38
not clear. I am rephrasing if the values in a1:a10 is avilable in B1:B20 that b value is 0 other wise no change.
if this is what you want run this macro test
BEFORE DOING THIS SAVE YOUR ORIGINAL FILES SAFELY SOMEWHERE SO THAT IT CAN BE RETREIVED IF THERE IS A MESS UP.
the macro is
if this is not what you require post data sheet and how it should look after running a macro.
if this is what you want run this macro test
BEFORE DOING THIS SAVE YOUR ORIGINAL FILES SAFELY SOMEWHERE SO THAT IT CAN BE RETREIVED IF THERE IS A MESS UP.
the macro is
Sub test()
Dim r As Range, c As Range, cfind As Range, x
Set r = Range("A1:a10")
For Each c In r
x = c.Value
Set cfind = Range("B1:B20").Cells.Find(what:=x, lookat:=xlWhole)
If Not cfind Is Nothing Then
cfind = 0
End If
Next c
End Sub
if this is not what you require post data sheet and how it should look after running a macro.
venkat1926
Posts
1863
Registration date
Sunday 14 June 2009
Status
Contributor
Last seen
7 August 2021
811
29 Oct 2010 à 22:21
29 Oct 2010 à 22:21
This is the result. what is the original data.
29 Oct 2010 à 05:51
A B C
Pankaj Pankaj 0
Kamal Shweta 0 as shweta is there in A5
Madhu Madhu 0
Vinay Prashant Prashant
Shweta Rahul Rahul
shashi shashi
Navin Navin
Kamal 0
Thank for the previous reply, however i dont know how to use it the way u said.