| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return Unquie Values
So guys, heres another one
Say in CElls A2:A10 I have values like so; food food test trial trial test And in B2:B10 I have qtys. I want a total with no filter or pivot that would return the unique entries into A12 like so Food Rest Trial Test Thats about it, I'll take care of the sumif formula for the qy based on this one thing that I reallly need. Pleaseeeeeeeeeeeee. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I use LOOKUP to return a range of values, then SUM values? | Excel Worksheet Functions | |||
| find largest values, then return corresponding row values. | Excel Discussion (Misc queries) | |||
| Search multiple values to return single values | Excel Worksheet Functions | |||
| How to return min value, but only values>1 ? | Excel Discussion (Misc queries) | |||
| return last values | Excel Discussion (Misc queries) | |||
![Javier Diaz[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
