Thread: Calc duplicates
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
backmara backmara is offline
external usenet poster
 
Posts: 13
Default Calc duplicates

Hi,
I need function to calculating duplicates, how I create this?
A1: 1
A2: 2
A3: 2
A4: 3
A5: 3
A6: 3
A7: 4
A8: 5

Example answers:
Duplicates value A9: 3
unique values A10: 5

This is same functions that tool remove duplicats, but i haveto do this
automatically.