auto count possible?
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? |
auto count possible?
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? |
auto count possible?
=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? |
All times are GMT +1. The time now is 12:29 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com