| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display list from one colum if value in other column matches x
I have 2 sheets in workbook. On sheet1 I have values in 2 columns, such as: Name Type test1 A test2 B test3 A test4 A test5 B On sheet2 I would like to summarize the information by Type, such as: TypeA TypeB test1 test2 test3 test5 test4 What formula can I configure on sheet2 to acquire this result? Thanks! -- rerhart ------------------------------------------------------------------------ rerhart's Profile: http://www.excelforum.com/member.php...fo&userid=8138 View this thread: http://www.excelforum.com/showthread...hreadid=570905 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Display list from one colum if value in other column matches x
See this screencap:
http://img104.imageshack.us/img104/8...reencapdg3.jpg The easiest way to do this is to put the formula on the same sheet like I did and then after you have the table completed cut and paste it to the other sheet. That way you don't have to mess around with sheet names and flipping between sheets as you write the formula. Biff "rerhart" wrote in message ... I have 2 sheets in workbook. On sheet1 I have values in 2 columns, such as: Name Type test1 A test2 B test3 A test4 A test5 B On sheet2 I would like to summarize the information by Type, such as: TypeA TypeB test1 test2 test3 test5 test4 What formula can I configure on sheet2 to acquire this result? Thanks! -- rerhart ------------------------------------------------------------------------ rerhart's Profile: http://www.excelforum.com/member.php...fo&userid=8138 View this thread: http://www.excelforum.com/showthread...hreadid=570905 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Display list from one colum if value in other column matches x
Thanks, that works...How do I get rid of the #NUM? A B test1 test2 test3 test5 test4 #NUM! #NUM! #NUM! #NUM! #NUM! -- rerhart ------------------------------------------------------------------------ rerhart's Profile: http://www.excelforum.com/member.php...fo&userid=8138 View this thread: http://www.excelforum.com/showthread...hreadid=570905 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Drop down list shrinks as you go down column | Excel Discussion (Misc queries) | |||
| insert date | Excel Worksheet Functions | |||
| Formula to search for given term, and if not found in column to add it to list | Excel Worksheet Functions | |||
| Change a Column list into multiple rows & columns | Excel Worksheet Functions | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Hybrid Mode
