Hi All,
I am working in an automobile manufacturing company which manufactures thousands of Engines.
For example, let us consider 3 different types of engine (say Engine 1, 2,3).
Each engine is made from different parts (say a,b,c,d,e).
I need the list of all parts used in all Engines in the worksheet in a single column (as shown in Column H).
I tried using the Unique function, it is not working.
looks very simple,
can some on please help ?
I am working in an automobile manufacturing company which manufactures thousands of Engines.
For example, let us consider 3 different types of engine (say Engine 1, 2,3).
Each engine is made from different parts (say a,b,c,d,e).
I need the list of all parts used in all Engines in the worksheet in a single column (as shown in Column H).
I tried using the Unique function, it is not working.
looks very simple,
can some on please help ?