Count number of occurances in a column

Hi

Hope someone can help

I have a list of order numbers and in the column to the right I would like to record number of times that order no appears in list


Order No Result
1111 3 appears 3 times
1111 3
2222 2 appears twice
4444 1
2222 2
1111 3

TIA

Many thanks Jacc14

Are you still using Excel 2003?

There are instructions at the top of the page explaining how to attach your sample workbook (yellow banner: HOW TO ATTACH YOUR SAMPLE WORKBOOK). Screenshots are of little practical use as we cannot manipulate them.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. The sample layout accurately matches that of your real data. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.

Or maybe a pivot table