View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Derek Derek is offline
external usenet poster
 
Posts: 51
Default Count duplicate cell values per month

Hi experts

I need to look down column Q, R, S and T and find duplicate values for the
same month and in a new cell just put a number of times they are duplicated
on the same row

ill explain, i.e.

Q R S T
Part 1 Part 2 Part3 Part 4
30.00 30.00 0.00 0.00

So in rows Q - T 30.00 appers twice, so id like cell U e.g. to report the
number 2

I hope that makes sense

Thanks

Derek