| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Match Single Numeric Criteria and Return Multiple Numeric Labels
Hi All,
I have two Columns of data: Column "E" houses the Numeric Labels and Column "F" houses the Numeric Values. Column "F" will have genuine duplicate values that should be included. The criterion value will vary. I would like to find / match all values (duplicates included) that are equal to 1 (in Column "F") and then have all their corresponding adjacent Numeric Labels returned from Column "E" to a single cell, if possible. If not, then returned to individual cells on the same Row. Thanks Sam -- Message posted via http://www.officekb.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Intervals of 1 Numeric value in a Row and Return Count down Column | Excel Worksheet Functions | |||
| Count Intervals of 2 Numeric values in same Row and Return Count across Row | Excel Worksheet Functions | |||
| How can I retrieve multiple rows that match one criteria, i.e. a d | Excel Worksheet Functions | |||
| match multiple criteria & return value from array | Excel Worksheet Functions | |||
| Return result from multiple criteria | Excel Worksheet Functions | |||
Hybrid Mode
