Excel Form FrustrationClosed

Question

I am having issue setting up an analysis page for a report that I have.  I am trying to find out for each individual what are the currently working on, completed, and the average time it took to complete.  I have the data but it is in the following format:

Name	Started	Done
Julie	24-Jun	27-Jun
Tom	24-Jun	
Julie	24-Jun	27-Jun
Julie	24-Jun	
Ken	24-Jun	27-Jun

The way I need the data appear with the name above with the data below as shown below.

Status		Tom	Ken
Working		1	0
Completed	2	0	
Average Time	3	0	
		

I am having issue because the data isn't setup in a column format.  Also the data list is constantly growing so I want it to be something that can update itself so I am not constantly updating the report. Please I need a excel guru to crack this case.

mubashir aziz · Answer

This type of data can be easily sorted out thru Pivot table but you will have to arrange data in an organized way ....... I"m suggesting some column then you can use Pivot table or some formulas on my name ...... but first made  column like this ....



Name        Started	Finish        Total Days         Status



Total Days = (Finish - Start)
Status : Working / Completed

After making this you can made this kind summary report easily 



Name      Working        Completed            
Tom :     =count           =count
Julie: 



These formula's can be give after creation of column and just let me know the column names which have below fields 




Name        Started	Finish        Total Days         Status

Excel Form Frustration

1 response

Similar discussions

Subscribe To Our Newsletter!