Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula on Creating Unique Value (Similar to Select Distinct)
Hello,
I am working on an excel file that has a recordset of medical claims reviewed. Columns: Tax ID Medical Provider Name Billed Amount Diagnosis Patient Client This worksheet gets updated constantly (through extracts from the actual medical claim processing system). However, what we want to do is to create a GROUP BY report of all claim per specific Tax-ID. What we have been doing is to Advance Filter Copy Unique values, and its becoming cumbersome. Is there a function/formula I can use to select the Tax-ID column and generate the unique list automatically? Thank you very much in advance. -- Brigham Siton Phone: (631) 780-5001 Fax: (516) 622-3501 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula on Creating Unique Value (Similar to Select Distinct)
Brig
I would automate the advanced filter functionality which should be pretty easy. just for info though, deleting dupes is standard functionality in Excel 2007. -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS web: www.excelusergroup.org web: www.nickhodge.co.uk "Brig" wrote in message ... Hello, I am working on an excel file that has a recordset of medical claims reviewed. Columns: Tax ID Medical Provider Name Billed Amount Diagnosis Patient Client This worksheet gets updated constantly (through extracts from the actual medical claim processing system). However, what we want to do is to create a GROUP BY report of all claim per specific Tax-ID. What we have been doing is to Advance Filter Copy Unique values, and its becoming cumbersome. Is there a function/formula I can use to select the Tax-ID column and generate the unique list automatically? Thank you very much in advance. -- Brigham Siton Phone: (631) 780-5001 Fax: (516) 622-3501 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula on Creating Unique Value (Similar to Select Distinct)
Thanks. Unfortunately, I am using Excel 2003 not Excel 2007.
-- Brigham Siton Phone: (631) 780-5001 Fax: (516) 622-3501 "Nick Hodge" wrote in message ... Brig I would automate the advanced filter functionality which should be pretty easy. just for info though, deleting dupes is standard functionality in Excel 2007. -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS web: www.excelusergroup.org web: www.nickhodge.co.uk "Brig" wrote in message ... Hello, I am working on an excel file that has a recordset of medical claims reviewed. Columns: Tax ID Medical Provider Name Billed Amount Diagnosis Patient Client This worksheet gets updated constantly (through extracts from the actual medical claim processing system). However, what we want to do is to create a GROUP BY report of all claim per specific Tax-ID. What we have been doing is to Advance Filter Copy Unique values, and its becoming cumbersome. Is there a function/formula I can use to select the Tax-ID column and generate the unique list automatically? Thank you very much in advance. -- Brigham Siton Phone: (631) 780-5001 Fax: (516) 622-3501 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unique entries based on condition - count distinct | Excel Discussion (Misc queries) | |||
Unique/Distinct Dropdown List | Excel Worksheet Functions | |||
Combining related unique (distinct) values from two columns into an array | Excel Programming | |||
Select Distinct Maximums | Excel Worksheet Functions | |||
select distinct row | Excel Programming |