LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 5
Default Returning Sorted Values

I have the list of names and abriviations on a sheet called info

A B C

1 Copper pdx CC
2 Edge pdx EW
3 Max pdx MX
4 North Albany cor NA
5 North Pointe cor NP
6 Stoney cor SB
7 Taro pdx TL
8 Trillium pdx TW
9 Victoria pdx VG
10 Village pdx VO
11 Villean pdx VI
12 Walnut pdx WC
13 Willmont cor WL
14 Witham cor WO

In another sheet I would like to have two rows that return in order the
values in column "C", each in a seperate cell. The top row would only return
the items that match "pdx" in column "B", and the bottom row would only
return the items that match "cor". What function, or group of functions, do I
use to get this result? The column of names must be sorted alphabetically to
work correctly with other formulas in the sheet.

Essentially I want cell A1 to contain the first value from column "c" that
matches pdx, B1 to return the second ....

A B C D E F G H I
1 CC EW MX TL TW VG VO VI WC
2 NA NP SB WL WO

Thank you for any help you can give.
Kevin
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot Table Field Values not sorted pepperds Excel Discussion (Misc queries) 1 February 16th 07 08:16 PM
Returning Values Harlan Excel Discussion (Misc queries) 1 December 12th 06 10:19 PM
Returning Values Troy2006 Excel Discussion (Misc queries) 5 July 31st 06 07:44 PM
Returning a sum when looking up two different values 1stcoast Excel Worksheet Functions 1 April 17th 06 02:45 PM
Returning all values okanem Excel Discussion (Misc queries) 3 March 1st 06 03:52 PM


All times are GMT +1. The time now is 01:28 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"