Hi Forum
Looking for some help please.
Twice a month we receive a new pre formatted data file that contains product information and pricing updates.
This file is currently over 2000 rows.
Included in the rows are merged cells to the width of the data so Column A to Column E. Out of the 2000 rows there must be 40 rows that are merged like this. This creates an immediate challenge on using standard filters in Excel as it only goes down to the first merged cell.
What we would like to be able to do is filter on the data using the 'contains' filter - however using these standard filters this limits us to 2 filters on the same column, eg Column B has part numbers and using the contains filter we can currently only filter using contains 'Media manager' AND contains 'ST'
As the Media Manager products can be determined by ST 10, ST 16, ST 100 there are further filters that are required to get to the data. We like to use these filters 'live' whilst on the phone to clients to be able to advise them of their best options.
A) is there a way of being able to remove the merged cells easily
B) is there a way of being able to filter through the data more effectively to be able to get to the correct options available?
It would be good to get it as automated as possible so we can provide a quick response to the client.
Your help is much appreciated.
Looking for some help please.
Twice a month we receive a new pre formatted data file that contains product information and pricing updates.
This file is currently over 2000 rows.
Included in the rows are merged cells to the width of the data so Column A to Column E. Out of the 2000 rows there must be 40 rows that are merged like this. This creates an immediate challenge on using standard filters in Excel as it only goes down to the first merged cell.
What we would like to be able to do is filter on the data using the 'contains' filter - however using these standard filters this limits us to 2 filters on the same column, eg Column B has part numbers and using the contains filter we can currently only filter using contains 'Media manager' AND contains 'ST'
As the Media Manager products can be determined by ST 10, ST 16, ST 100 there are further filters that are required to get to the data. We like to use these filters 'live' whilst on the phone to clients to be able to advise them of their best options.
A) is there a way of being able to remove the merged cells easily
B) is there a way of being able to filter through the data more effectively to be able to get to the correct options available?
It would be good to get it as automated as possible so we can provide a quick response to the client.
Your help is much appreciated.