View Single Post
  #1   Report Post  
Tee51 Tee51 is offline
Junior Member
 
Posts: 19
Exclamation Counting unique values based on 2 columns

I have been struggling all day to find the correct formula to use when trying to count unique values using different columns. I have a multiple column spreadsheet and I would like to identify the number of unique values (text & alpha) in column D (job #) that has a specific status which is in column F. For example, see below, the working status has 3 unique job#'s. Can someone help please?

Job# Status
100 Initial
201 Working
634 Working
201 Working
978 Completed
978 Working