| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Looking for formula index/match-type that returns an array
I have 2 columns (names and values). The values are either 0 or 1. I'm
looking for a formula that would give me the list (or array) of names that have a given value. I have been trying with Index/Match but coudn't get more than 1 match. thanks. |
|
#2
|
|||
|
|||
|
Try Data | Filter from the menu
"Tom" wrote: I have 2 columns (names and values). The values are either 0 or 1. I'm looking for a formula that would give me the list (or array) of names that have a given value. I have been trying with Index/Match but coudn't get more than 1 match. thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking Returns | Excel Discussion (Misc queries) | |||
| When I enter a number in an empty cel, de cel returns the value d. | Excel Discussion (Misc queries) | |||
| Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
| Custom Type Charts Problem | Excel Worksheet Functions | |||
Linear Mode
