Create a pivot table with the factory name as the row heading, Approved and
Rejected as the column headings and the count of Approved or Rejected as the
value.

"sajid" wrote:

Hi

I have an excel sheet with few columns. one column contain factory names.
the factory name repeats. another column contains the status which can be
either "Approved" or "Rejected". I need to count how many times does a
factory got approved status.


please help on which formula can capture these simultaneous entries.

thanks

Sajid