I add a couple hundred orders to a file every day. Sometimes there are
duplicate order numbers. (Don't ask, ugh)

Column A contains those orders - today's orders get added at the bottom of
the file after yesterday's orders. If today I enter a line for order number
112233 is there a way to have column B automatically tell me the number of
times 112233 appears in column A?

If you put this formula in column B: =COUNTIF(A:A;A1) it should work.

Bart Snel

"Wanda" schreef in bericht
...
I add a couple hundred orders to a file every day. Sometimes there are
duplicate order numbers. (Don't ask, ugh)

Column A contains those orders - today's orders get added at the bottom of
the file after yesterday's orders. If today I enter a line for order
number
112233 is there a way to have column B automatically tell me the number of
times 112233 appears in column A?

=countif(a:a,112233)


"Wanda" wrote in message
...
I add a couple hundred orders to a file every day. Sometimes there are
duplicate order numbers. (Don't ask, ugh)

Column A contains those orders - today's orders get added at the bottom of
the file after yesterday's orders. If today I enter a line for order number
112233 is there a way to have column B automatically tell me the number of
times 112233 appears in column A?