dtringovski
New Member
- Joined
- Jan 24, 2020
- Messages
- 5
- Office Version
- 2016
Hello all,
I have this kind of problem. I hope that I can properly describe it.
I need to find a way in excel, for combining and comparing two long columns of article numbers. For example on one hand I have 500 article numbers in my system on a separate sheet and on the other hand the 200 hundred of them which are still active on another sheet. So I need to select and highlight the active numbers from the inactive ones. I need some formula as follows IF(this row from column 1 - the one with all the articles , match any of the numbers in the rows of column 2 - the one with the active ones , then type TRUE ) or something else but the point is that we need to select the number of the active articles from the others. 11,22,33,44,55,66,77,88,99,111,222,333,444,555,666 --------------------- 11,55,111,333,555
Thank you !
I have this kind of problem. I hope that I can properly describe it.
I need to find a way in excel, for combining and comparing two long columns of article numbers. For example on one hand I have 500 article numbers in my system on a separate sheet and on the other hand the 200 hundred of them which are still active on another sheet. So I need to select and highlight the active numbers from the inactive ones. I need some formula as follows IF(this row from column 1 - the one with all the articles , match any of the numbers in the rows of column 2 - the one with the active ones , then type TRUE ) or something else but the point is that we need to select the number of the active articles from the others. 11,22,33,44,55,66,77,88,99,111,222,333,444,555,666 --------------------- 11,55,111,333,555
Thank you !