| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Match formula that pulls unique values from another column?
have a tough one he I have a report that shows shipped orders (column A) and the carrier used for that order (column B). Since the order number in Column A is repeated for every item shipped, Column A is not reliable for unique order numbers. Also different orders have different carriers in Column B. What I am needing is for every match of a certain carrier (column B) to pull back unique order numbers in Column A. Here is a visual example if a better explination is needed: Order Carrier 1 UPS 1 UPS 2 FedEx 3 UPS 3 UPS 3 UPS 4 UPS 4 UPS 5 FedEx From the list above, if I wanted to know how many unique orders shipped UPS is there a formula that exists to give me this information? -- alehm ------------------------------------------------------------------------ alehm's Profile: http://www.excelforum.com/member.php...o&userid=27077 View this thread: http://www.excelforum.com/showthread...hreadid=465946 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Test IF Two Numeric Values Match (from two separate Dynamic Ranges) | Excel Worksheet Functions | |||
| Count unique values and create list based on these values | Excel Worksheet Functions | |||
| How do I copy cell values (derived from formula), not references? | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Formula for Searching & matching two values in excel | Excel Discussion (Misc queries) | |||
Threaded Mode
