Excel Filter

Sayand007

New Member
Joined
Aug 2, 2020
Messages
1
Office Version
365
Platform
Windows
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.
 

Some videos you may like

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand

Watch MrExcel Video

Forum statistics

Threads
1,102,563
Messages
5,487,583
Members
407,605
Latest member
PACULA

This Week's Hot Topics

Top