Excel Filter

[Sayand007]

Hi All

I will give you a brief about the problem. There are a number of entities that are required for a particular object. Now there are numerous objects where due to manual entry the same entity can be entered. I want to figure our how we can input the entity number and get the list of objects along with their start and end dates to find the clashes. There are multiple rows with objects and entities.

The data format is as below:

Object Entities Date of Start Date of completion
Xyz. DSSR21, DSSR43 11 August. 16 August


Also is there any possibility of preparing an automated Gantt chart from the above table.

P.S: Multiple entities are mentioned in the same row and are separarted by commas.

 

[pbornemeier]

If the elements in each line had a standard separator and the last 2 entries in each line were dates in a standard format then each of the entities could be assigned to those dates in a new table. The format you showed in the single line and the qualification "manual entry" leaves me to doubt that a completely successful conversion could be made since the 4 separators shown are (period space) (comma space) (space) (period space) have 3 different formats. Is the day always 2 digits? Are all dates in the same year? Are the months always spelled out and spelled correctly?

Once the data was parsed it would be arranged in a table as shown in the link below. Follow the other instructions on that page to get the Gantt chart. The steps they should could be automated once the input data is in that tabular format.

How to make Gantt chart in Excel (step-by-step guidance and templates)

Quick way to make a Gantt chart in Excel 2021, 2019, 2016, 2013, 2010 and earlier versions. Step-by-step guidance to create a simple Gantt chart, Excel templates and online Project Management Gantt Chart creator.

www.ablebits.com

Provide 50 more lines of data and I will see if/how the conversion to separate entities with common dates could be done