MS Excel Peeps. Help Please

Reply Subscribe

Thread Tools

Dec 3, 2007 | 02:56 AM

Skelly_GSR

Thread Starter

RB does men

Joined: Jan 2003

Posts: 11,997

Likes: 0

From: Pittsburgh

MS Excel Peeps. Help Please

Ok so I have a huge instrument index. I am trying to build a submittal for pressure gauges to send to the engineer. In the picture I need to sort all the "PG"'s. Can you guys help me please

Attached Images

msword.JPG (347.0 KB, 35 views)

Dec 3, 2007 | 03:17 AM

THEOLDMAN

Checking it twice

Joined: May 2002

Posts: 13,539

Likes: 0

From: Twixt Hell/Ann Arbor MI

What do you want to sort them by?

__________________
Life is not a journey to the grave with the intention of arriving safely in a pretty and well preserved body, but rather to skid in broadside, thoroughly used up, totally worn out, and loudly proclaiming ...."WOW! What a ride!!!!!"

LUNCH with THEOLDMAN...On a break for now...

Dec 3, 2007 | 03:20 AM

JCEN

Z0chicks

Joined: Oct 2004

Posts: 3,387

Likes: 0

From: PA

highlight section
go to data - sort
then pick what column to sort by
should work

Dec 3, 2007 | 04:57 AM

jclau00

Senior Member

Joined: Sep 2002

Posts: 1,104

Likes: 0

From: bay area, cali

you wanna do a data filter

hit ALT + D + F + F

click on the menu dropdown on column E

click on Custom Filter

set it to contain anything with the word "pressure gauge"

you might have to un-merge A1

1 ... not sure how data filters work on merged cells

Dec 3, 2007 | 05:04 AM

Nec

.......

Joined: Jun 2002

Posts: 522,629

Likes: 0

From: noobtown

Quote:

Originally Posted by jclau00

1 ... not sure how data filters work on merged cells

to expand on this, if you don't remember "Alt + D + F + F," you can just go to Data "Auto filter" and it will give you some drop downs at the top of each column.

__________________
94 Chevy Blazer - brother crashed.
94 2dr accord - h22 swap, rear ended.
03 1.8 gti - waiting for her bag of chips.

:crazyr: :slap: :hsughr: :nec: :madr: