| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
To find Multiple values in column B for a unique value in column A
Help!
Help if you can please!! Here's my problem, I'm trying to identify multiple values in column B for a unique value in column A. Column A Column B 100 5687 100 5687 100 5687 100 8569 100 8569 200 4544 300 8563 300 5686 300 1256 So in this example, I'm trying to find all the values in column B that relate to the unique value of 100 in column A. Thanks for your help! Cheers Chris |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
To find Multiple values in column B for a unique value in column A
Do you want to just highlight them, or extract them? Once-off, or regularly
updated? -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "kishdaba" wrote in message oups.com... Help! Help if you can please!! Here's my problem, I'm trying to identify multiple values in column B for a unique value in column A. Column A Column B 100 5687 100 5687 100 5687 100 8569 100 8569 200 4544 300 8563 300 5686 300 1256 So in this example, I'm trying to find all the values in column B that relate to the unique value of 100 in column A. Thanks for your help! Cheers Chris |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
To find Multiple values in column B for a unique value in column A
Hi,
Have you tried "Auto Filter" for this? I guess that might help you. Hope that helps, Thankyou, Shail kishdaba wrote: Help! Help if you can please!! Here's my problem, I'm trying to identify multiple values in column B for a unique value in column A. Column A Column B 100 5687 100 5687 100 5687 100 8569 100 8569 200 4544 300 8563 300 5686 300 1256 So in this example, I'm trying to find all the values in column B that relate to the unique value of 100 in column A. Thanks for your help! Cheers Chris |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup function/sum function | Excel Discussion (Misc queries) | |||
| Count Unique Values with Multiple Criteria | Excel Worksheet Functions | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| Match formula that pulls unique values from another column? | Excel Discussion (Misc queries) | |||
| Counting unique entries in column A but only if specific values appear in columns B and C | Excel Worksheet Functions | |||
Linear Mode
