I have a spreadsheet with about 1500 user names listed in rows. There are
175 columns that have: mugshots, booking, employee, etc. On the row where
the user name under the headings (mugshots, booking, etc for 175 columns)
there is a Yes or No if they have access. I want to be able to group all the
users (1500) that have the same access (all the Yes's from the 175 columns).
Is there an easy way to do this, I thought of a pivot table but then when I
tried to bring in the user names (1500) and then the columns, I couldn't get
it to work correct.
Thanks,

Hi,

using the Advance filtering techniques you can retrieve mis-typed or
misspelled, values and organize them in groups based on the query you enter
under each column heading.

To retieve the values;

1. Select all records and the column headings and define a name for the
range List. This is the List range name.
2. Select all column headings and paste in a seperate row anywhere in the
spreadsheet.
2. Select the pasted column heading along with an empty row and define a
name. This is the criteria range name.
3. Define a criteria on the second row for all columns, if necessary. For
example S* will display all details specific to "S'.
4. Click Data- Filter- Advanced Filter
5. Type the List name
6. Type the Criteria Name
7. Click copy to another location option - Mandatory
8. Click Copy to
9. Click the cell below the criteria range

All data will be displayed specific to the query you requested. This is very
usefull if the spreadsheet data are mistyped or mis-spelled. Now you have
done a database funtion on your excle spread sheet.

Challa Prabhu



"Pammy" wrote:

I have a spreadsheet with about 1500 user names listed in rows. There are
175 columns that have: mugshots, booking, employee, etc. On the row where
the user name under the headings (mugshots, booking, etc for 175 columns)
there is a Yes or No if they have access. I want to be able to group all the
users (1500) that have the same access (all the Yes's from the 175 columns).
Is there an easy way to do this, I thought of a pivot table but then when I
tried to bring in the user names (1500) and then the columns, I couldn't get
it to work correct.
Thanks,