Hello,
This is my first post and I wish to greet everybody.
I have one problem in Excel 2010.
I would love to search for column labels that contain word "Delivery".
The cell that I would start searching is on Sheet2 and cell B1.
From this cell I need formula that will look at row 1 Sheet1 and scan all labels and if found any occurence of "Delivery" it would copy that label and place it into cell B1 and then C1 and so on.
Is this possible to be done?
Please let me know. I appreciate your help.
Thanks.
This is my first post and I wish to greet everybody.
I have one problem in Excel 2010.
I would love to search for column labels that contain word "Delivery".
The cell that I would start searching is on Sheet2 and cell B1.
From this cell I need formula that will look at row 1 Sheet1 and scan all labels and if found any occurence of "Delivery" it would copy that label and place it into cell B1 and then C1 and so on.
Is this possible to be done?
Please let me know. I appreciate your help.
Thanks.