Modify Spreadsheet (1 Viewer)

[standenman]

I have a publically available excel spreadsheet of US hospitals. The spreadsheet provides a plethora of rows for each entry - I am not really sure why. But I want just one row for each hospital - one row per Facility ID. Can anyone help me do this?

 

[plog]

A simple aggregate query will do this. Import that spreadsheet into Access, then make a query based on that table. Bring down every field, change the query to an aggregate query (click the Sigma/Summation sign). Then run the query and you will have your data.

 

[LarryE]

Here you go. TblImport is imported and TblHospitals is the 391 separate hospitals.

 

[arnelgp]

if you have newer version of MS Excel, they have this Unique() function.
you create New Sheet (Sheet2) and on Sheet2, put this Formula on A1 cell:

=UNIQUE(Query1)

it will give you the list of unique hospitals (391).

 

[LarryE]

if you have newer version of MS Excel, they have this Unique() function.
you create New Sheet (Sheet2) and on Sheet2, put this Formula on A1 cell:

=UNIQUE(Query1)

it will give you the list of unique hospitals (391).

Pretty cool, but just make sure you do all your sorting first, before using Unique.