| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Display an Array of Data Based on Other Data
I have a worksheet where column A is a list of names (with duplicates) &
Column B is an order number. In column C I have a list of unique names pulled from Column A (done manually for now). In Column D I'd like to list all order numbers from column B that correspond to a particular name in column C. In this example I'm trying to figure out column D based in columns A, B & C: A B C D Wright A-1 Beltran A-21 Pujols B-3 Jeter C-22 Jeter C-22 Pujols B-33, J-22 Wright F-38 Wright A-1, F-38 Beltran A-21 Pujols J-22 Thanks. -- Message posted via http://www.officekb.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find criteria based data and display next to a count in another wk | Excel Discussion (Misc queries) | |||
| Return an array of data based on range of date | Excel Worksheet Functions | |||
| Based on a condition in one column, search for a year in another column, and display data from another column in the same row look | Excel Discussion (Misc queries) | |||
| Display data from cells based on a formula | Excel Discussion (Misc queries) | |||
| What is the maximum allowed number of data elements in a data array? | Excel Discussion (Misc queries) | |||
Threaded Mode
