HI, my name is Omar and I am new here...
my problem is the next:
I need a macro that compare values from column A (each value) with all the values of colunm C, if it find the same value does nothing but if not it has to put the value of A in C if the C is with the value --.--
Thanks ¡¡¡¡¡¡
You get better help if you add an excel file, without confidential information on this forum.
Please also add the desired result in your sheet.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Hi,
Why do you think you need a macro when a simple =IF(MATCH()) formula in an adjacent column will test the condition and return the appropriate value. Then if necessary copy the helper column and use Paste Special values to paste back to column C.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Ok, now I am not at home when I come back I am going to add the file, I have tried the function MATCH, but the problem is that I forget to say something, the story is:
We have column A (new history) and C (old history), B and D are unit columns so, I need to compare and see if the values of A are different from C (some are new) so if the program check the column C and find that the value for example A1 is not in C, has to look for a value in C (--.--, this is the cell value), and the same value of unit, and replace in C.
Hi,
Post #4 doesn't alter what I said in #3.
Yes, uploading the file would assist.
Ok, I tried it but didn't work I will try it later at home and say something, thanks ¡¡
Last edited by tgnomar; 07-07-2014 at 07:09 AM.
ASK.xlsx
Hi is me again, I was trying with the function MATCH but I am not able to do it. The file has four columns with old and new histories and the units of both two. I need to look for the new in the old. If the new is not in the old it has to be, so the cell with the same unit and value "--.--" or just without value is the place where it has to be.
To sum up, at the end I will have only one list with old and news
Last edited by tgnomar; 07-07-2014 at 12:23 PM.
Hi
Formula:
Please Login or Register to view this content.
will find the G value in A and return the value from B.
If that's not what you expect please add some manually calculated results.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks