counting unique digits
counting unique digits
(OP)
I am trying to figure out how to create a formula to do the following. Hopefully someone can steer me in the right direction.
(SHEET 2008) Column A is order #, Column B-E is ECO Column F-I quote # and Column J is Month
SHEET (BTC)
Trying to create a formula so that it will look in Sheet 2008 find all orders in January, count all the eco numbers in January less the duplicates... however, the duplicated numbers should count but only as 1
Can this be done?
(SHEET 2008) Column A is order #, Column B-E is ECO Column F-I quote # and Column J is Month
SHEET (BTC)
Trying to create a formula so that it will look in Sheet 2008 find all orders in January, count all the eco numbers in January less the duplicates... however, the duplicated numbers should count but only as 1
Can this be done?





RE: counting unique digits
I would look at MSQuery with (Sheet 2008) as the data source.
RE: counting unique digits
RE: counting unique digits
Highlight the data that you are interested in and create a named range.
On a separate sheet do Data | Import External Data | New Database Query
Choose Excel files, then navigate back to the spreadsheet.
Choose the table name you just created.
Play around from there.
RE: counting unique digits
RE: counting unique digits
David
RE: counting unique digits
investigate or experiment using the "Filter" and/or "Subtotal" feature with the "Data" menu. you may be able to achieve desired results using these standard features of XL.
good luck!
-pmover
RE: counting unique digits
Have you tried the sumif function? You might need to use countif with it for the duplicate numbers.