05-27-2019 08:55 PM
05-27-2019 08:55 PM
I have two columns of data numbers I want to match/line with one another but want to see if they can be spaced if not matching between the columns? I have found conditional formatting to mark the two that are not matching the rows but it is taking lots of time to get thru like 5000. I am trying to see if I can get Column A and Column B to line up with one another while spacing in the row when they don't but moving the numbers to line up with one another when they match.
Column A Column B
I would like it to look like:
Column A ColumnB
If it is possible. Basically I am working with item numbers at my work, each day some items go out of stock or they add new items that I am wanting to match the item numbers quickly but point out ones that are gone or new.
I am not an expert in Excel, so if it involves expert steps/programming (if what I am wanting to do is possible), just list the steps or what I need to do.
I appreciate all your time and help!!!!!
05-27-2019 09:34 PM
05-27-2019 09:38 PM
That could help too. I am looking for any way to make it easier or show. @Twifoo
05-27-2019 10:25 PM
You could use this formula in Column C, starting in C2, copied down rows:
See the sample in the attached file.
05-28-2019 06:44 PM
I have tried the formula and it does not go pass 10 rows. I have copied and moved column A down to highlight all the cells and did the same thing in column B and still comes up as 0 in Column C. I see in your download/sample file it displayed the difference but if change the numbers (copy/paste) out, nothing occurs. The first 10 rows I know match but going farther does nothing. I must be not doing something right. Even if I change all the A's to the ending row number and the B number row, still nothing occurs any different. @Twifoo
05-28-2019 08:29 PM
The formula returns the correct results only until Row 10 because the ranges are static. Such ranges in the attached version of the file are now dynamic, such that the formula in C2, copied down rows, has been modified to:
05-31-2019 10:34 PM
I must be not doing something right or missing something. I took your second file and it just shows 0 each time. I have copy paste, highlighted the rows and it is not picking up differences. Maybe it is easier to show the worksheet I have I am trying to work with. I do want to tell you, Thank you for all your help and time with this!!! @Twifoo