VBA Count Duplicates from a varied range on one sheet using another sheets list

[decadence]

Is it possible to count number of instances of duplicate and unique cells found from a varied range using a list of data from another sheet as a reference to on what to look for? My data will be varied with up to 20,000 rows and up to 10 columns Also the cells will contain both numbers and letters, I will have 2 sheets one with the duplicate data and another with Total Duplicates. Can someone help with this please? Thanks

Example:

From this (Duplicates sheet)

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Header 1
[/TD]
[TD]Header 2
[/TD]
[TD]Header 3
[/TD]
[TD]Header 4
[/TD]
[TD]Header 5
[/TD]
[/TR]
[TR]
[TD]Apple
[/TD]
[TD]Banana
[/TD]
[TD]Orange
[/TD]
[TD]Pear
[/TD]
[TD]Grapes
[/TD]
[/TR]
[TR]
[TD]Orange
[/TD]
[TD]Apple
[/TD]
[TD]Pear
[/TD]
[TD]Apple
[/TD]
[TD]Orange
[/TD]
[/TR]
[TR]
[TD]Orange
[/TD]
[TD]Pear
[/TD]
[TD]Apple
[/TD]
[TD]Orange
[/TD]
[TD]Pear
[/TD]
[/TR]
[TR]
[TD]Pear
[/TD]
[TD]Orange
[/TD]
[TD]Pear
[/TD]
[TD]Pear
[/TD]
[TD]Apple
[/TD]
[/TR]
</tbody>[/TABLE]

To This (Total Duplicates Sheet)

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Duplicates
[/TD]
[TD]Count
[/TD]
[/TR]
[TR]
[TD]Apple
[/TD]
[TD]5
[/TD]
[/TR]
[TR]
[TD]Banana
[/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD]Orange
[/TD]
[TD]6
[/TD]
[/TR]
[TR]
[TD]Pear
[/TD]
[TD]7
[/TD]
[/TR]
[TR]
[TD]Grapes
[/TD]
[TD]1
[/TD]
[/TR]
</tbody>[/TABLE]

 

[Fluff]

How about
=COUNTIF(Sheet1!$A$2:$E$5,A2)

 

[decadence]

Hi Fluff, thanks for the reply however this formula is for the example, my data is varied so I can't specify exact range

 

[Fluff]

In that case how about
=COUNTIF(Sheet1!A:L,A2)
Change the L to the last column you are likely to get

 

[decadence]

Thanks Fluff, this works perfectly

 

[Fluff]

You're welcome & thanks for the feedback