Hello everyone, I would like to automate some thinks. Column A and B is a old report. Column E and F contains new values (open close), and H and I is a results from compare. I would like to compare values from new report with old report if in new report is other status in results will new status, could you help me?
[img]copare-1.jpg[/img]
Of course values of Number may be in different rows as is in picture
Last edited by czasas; 12-05-2016 at 08:55 AM.
It's not clear what do you want to compare? If Status in New report is not the same as status in old rep = New rep statuss should be used, otherwise Status_Old = Status_New and Status_New can be used again.
Looks like your New report already contains the same values as your potential Compare table.
Yes in that Way as you wroteOriginally Posted by kasan
you do not need to compare them you can just take the values from the new report then cause that will be the right one anyway.
Only scenario where you need to compare is if the old report can have numbers that are not in the new Report.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks