| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Index match to return all values
Hello,
My UDF Pstat is still being developed further but you can already use it this way: Select a range of 4 rows and 2 columns and array-enter: =Pstat("sum",1,1-ISERROR(SEARCH(B1,A1:A17)),A1:A17,1-ISERROR(SEARCH (B1,A1:A17))) Pstat you can find he http://www.sulprobil.com/html/pstat.html Regards, Bernd |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return value with 2 conditions (using Lookup/Match/Index) | Excel Discussion (Misc queries) | |||
| Index? Match? Function to sort and return value fr diff column in | Excel Worksheet Functions | |||
| return multiple corresponding values using INDEX | Excel Worksheet Functions | |||
| Match/Index return #N/A | Excel Worksheet Functions | |||
| Error Return Value from and INDEX(A:2,MATCH()) function | Excel Worksheet Functions | |||
Hybrid Mode
