Home | Community | Message Board


This site includes paid links. Please support our sponsors.


Welcome to the Shroomery Message Board! You are experiencing a small sample of what the site has to offer. Please login or register to post messages and view our exclusive members-only content. You'll gain access to additional forums, file attachments, board customizations, encrypted private messages, and much more!

Kraken Kratom Shop: Red Vein Kratom

Jump to first unread post Pages: 1
OfflinePlatinum
Psychonautical Engineer
Male User Gallery


Folding@home Statistics
Registered: 06/04/08
Posts: 7,575
Loc: New York Flag
Last seen: 5 months, 29 days
Excel help plz
    #10369390 - 05/20/09 12:10 PM (14 years, 9 months ago)

I have this spread sheet that has the names of all the employees int he company I work for. It is lastname, firstname format. I need to compare them to e-mail addresses we have which is firstinitial-lastname@blabla.com

So I had to use formulas to extract the names the way I wanted it to be. Bottom line is I got what I need, but now I need to sort it alphabetically and I can't. I'm thinking because the actual cells are just formulas and that's why.

Is there a way I can sort the values the formulas retrieve alphabetically?


Extras: Filter Print Post Top
Offlinecircularvortex
Bass Head
Male User Gallery


Folding@home Statistics
Registered: 08/31/06
Posts: 12,148
Loc: Flag
Last seen: 5 months, 24 days
Re: Excel help plz [Re: Platinum]
    #10369407 - 05/20/09 12:14 PM (14 years, 9 months ago)

You can do something like...copy special and do the VALUES of the cells with the names that you want (that's what the formula's got you, right?)  Then paste the values into another column and just sort that.


--------------------
No statements made in any post or message by myself should be construed to mean that I am now, or have ever been, participating in or considering participation in any activities in violation of any local, state, federal, or fashion police laws. All posts are works of fiction.

For well you know that its a fool who plays it cool
By making his world a little colder.

Under closer inspection I realised it was a funky ball of tits from outer space.



Extras: Filter Print Post Top
InvisibleSwyfty Swyf
Shrugsy Shrugs


Registered: 02/20/09
Posts: 7,113
Loc: North Alabama
Re: Excel help plz [Re: Platinum]
    #10369424 - 05/20/09 12:18 PM (14 years, 9 months ago)

You can set up filters for each column.

Do you have a filter icon?

That way you can filter the results of each column alphabetically or reverse-alphabetically.

You can also make another column so that you can filter employess by their job descriptions.

I am not sure how to set it up, but I have seen forms that were like that.

Your boss should walk you through it, if you ask him/her to show you how to filter your columns.


--------------------
If you build it they will shrug.
:shrug:


Extras: Filter Print Post Top
Offlinegilesypopper
Psycho Jester
Male User Gallery


Registered: 03/30/07
Posts: 1,873
Loc: Dimenson D
Last seen: 2 years, 2 months
Re: Excel help plz [Re: Swyfty Swyf]
    #10369463 - 05/20/09 12:23 PM (14 years, 9 months ago)

Would a cheap and nasty pivot table help?


--------------------
Law breakers, law makers, let us fight them all, why not.


Extras: Filter Print Post Top
OfflinePlatinum
Psychonautical Engineer
Male User Gallery


Folding@home Statistics
Registered: 06/04/08
Posts: 7,575
Loc: New York Flag
Last seen: 5 months, 29 days
Re: Excel help plz [Re: gilesypopper]
    #10369670 - 05/20/09 01:02 PM (14 years, 9 months ago)

Quote:

circularvortex said:
You can do something like...copy special and do the VALUES of the cells with the names that you want (that's what the formula's got you, right?)  Then paste the values into another column and just sort that.




That actually might be the trick. I'll let you know.

Quote:

Swyfty Swyf said:
You can set up filters for each column.

Do you have a filter icon?

That way you can filter the results of each column alphabetically or reverse-alphabetically.

You can also make another column so that you can filter employess by their job descriptions.

I am not sure how to set it up, but I have seen forms that were like that.

Your boss should walk you through it, if you ask him/her to show you how to filter your columns.




He doesn't know, and I have the filters on now, but because the cells are actually formulas that just call the values I can't sort that way.

Quote:

gilesypopper said:
Would a cheap and nasty pivot table help?




Probably not.


Extras: Filter Print Post Top
OfflinePlatinum
Psychonautical Engineer
Male User Gallery


Folding@home Statistics
Registered: 06/04/08
Posts: 7,575
Loc: New York Flag
Last seen: 5 months, 29 days
Re: Excel help plz [Re: Platinum]
    #10369674 - 05/20/09 01:03 PM (14 years, 9 months ago)

Quote:

Platinum said:
Quote:

circularvortex said:
You can do something like...copy special and do the VALUES of the cells with the names that you want (that's what the formula's got you, right?)  Then paste the values into another column and just sort that.




That actually might be the trick. I'll let you know.





Bingo. Don't know why I didn't think of that. Thanks man!


Extras: Filter Print Post Top
Offlinecircularvortex
Bass Head
Male User Gallery


Folding@home Statistics
Registered: 08/31/06
Posts: 12,148
Loc: Flag
Last seen: 5 months, 24 days
Re: Excel help plz [Re: Platinum]
    #10369806 - 05/20/09 01:30 PM (14 years, 9 months ago)

:awebig:

I actually used something I learned in a stats class!


--------------------
No statements made in any post or message by myself should be construed to mean that I am now, or have ever been, participating in or considering participation in any activities in violation of any local, state, federal, or fashion police laws. All posts are works of fiction.

For well you know that its a fool who plays it cool
By making his world a little colder.

Under closer inspection I realised it was a funky ball of tits from outer space.



Extras: Filter Print Post Top
Jump to top Pages: 1

Kraken Kratom Shop: Red Vein Kratom


Similar ThreadsPosterViewsRepliesLast post
* Microsoft Excel help endokrin 431 1 04/28/05 04:35 PM
by afoaf
* excel help please
( 1 2 all )
LethalX5 1,878 31 09/11/05 11:08 AM
by InsatiableThirst
* Ya'll heard bout dem alphabet boys? Cracka_X 701 4 06/10/07 12:17 AM
by Silversoul
* Translating between alphabets MisterMuscaria 390 1 01/02/09 07:12 PM
by LeftBehind
* excell question LethalX5 279 2 08/21/07 10:22 AM
by LethalX5
* The Alphabet Song!
( 1 2 3 4 5 all )
RonaldFuckingPaul 5,089 87 12/27/07 10:32 PM
by AlteredAgain
* why isn't the keyboard in alphabetical order? skeeter 2,265 14 01/22/08 08:13 PM
by RonaldFuckingPaul
* Girlfriend problems plz help
( 1 2 3 4 5 6 all )
MustNotBe 4,579 104 10/31/06 05:43 PM
by Cowgold

Extra information
You cannot start new topics / You cannot reply to topics
HTML is disabled / BBCode is enabled
Moderator: Entire Staff
320 topic views. 2 members, 44 guests and 50 web crawlers are browsing this forum.
[ Show Images Only | Sort by Score | Print Topic ]
Search this thread:

Copyright 1997-2024 Mind Media. Some rights reserved.

Generated in 0.021 seconds spending 0.007 seconds on 14 queries.