Hi,

Assuming that the first row of the cloumn as header information.

Do the following:

1. On the taskbar, righ-click and select count.
2. Select the first row.
3. On the Data menu, point to Filter, and then click AutoFilter.
4. Click the arrow, and then select the invoice number.
5. Select the range. The taskbar displays the count of the invoice number.

Challa Prabhu



"workingwoman" wrote:

I have an excel spreadsheet that I want to make sure that I do not have
duplicate invoice numbers. Can I accomplish that and how?
--
Deborah Motte