View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Soth Soth is offline
external usenet poster
 
Posts: 55
Default help with formula


A B C-count

10 A
10 A
10 A 2 Dup
20 B
20 C

There are duplicates numbers in Column A and B. How do you write a formula
to look up all fields in all columns for any possible duplicates place and
count the value in column c.

Many thanks,
Soth