Forum Discussion
Excel formula to get number of working days
here attached my workbook . i have data table and i have make a pivot table also for it. there are machine names entry days and output. every day repeat all machine names but not work all machines....
Please find the attached with the two Pivot Tables and see if any one of them is what you are trying to achieve.
thank you for the reply. this is not what i need. i need a pivot table just like your 1st pivot without extracting dates based on machine names. there should be only 6 rows for 6 days and only machine count work on this relevant date ( as a example except "0" output on output column.
Forget about the Pivot Table, just mock up the desired output manually based on the sample data in the file to show what exactly you are trying to achieve and upload the file again.
thank you!
i like a pivot table like table 3 on the attachment without extracting data and except "0" on output
