Hi,
I struggle with this function...
I try to make sort column by 2 cells with contain.
So example: IF I2:I300 contains A2&B2 then copy it to F2 and so on if not stay blank or null.
Have someone some advice?
Capture.JPG
Hi,
I struggle with this function...
I try to make sort column by 2 cells with contain.
So example: IF I2:I300 contains A2&B2 then copy it to F2 and so on if not stay blank or null.
Have someone some advice?
Capture.JPG
Hi, welcome to the forum
Really hard to see what that pic contains, but I suggest that you upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.
See the yellow banner above to see how
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Here is excel example:
edited wrong file.
Last edited by ManiaKsLV; 04-15-2020 at 04:01 PM.
Can someone give some better hint how to make this possibe?
Sorry, still having a hard time figuring out what you are doing.
I dont see Ax or Bx in col G at all?
IF G2:G99 contains Ax and Bx then copy here
Ax mean A1 A2 A3 ...
Bx mean B1 B2 B3 ...
I want to compare all column G with A1&B2 if in some row contain info from A2 and B2 then it copy that cell in F2 if not it can stay blank.
then same A3&A3 .... and so on.
I need to sort same info from G column beside on A B C D E. All A to E is correct by default. No change needed. Info in G is correct but position is wrong.
I have 500+ cells in G column and i want sort them from A and B cell.
added new excel file.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks