RE: Looking for formula index/match-type that returns an array
Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance
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.
.
Relevant Pages
- ignore specific data
... here ignore_data should filter the block ... def ignore_data: ... return data # may be an array of remaining lines... ... Prev by Date: ...
(comp.lang.python) - Re: Page field and array selection
... Hi Tom - had done that so I must be learning something.!! ... ShowMe = False ... I think your problem may be indexing: it appears that your aState array may not 'line up' with the ... code just results in the last array item being used as the page filter. ...
(microsoft.public.excel.programming) - Re: OT Creation of Israel (Long)
... we must look at events without the filter of ... >pre-conceived politcal or social distortions. ... Tom ... Prev by Date: ...
(rec.outdoors.rv-travel) - Re: how do you delete blank rows in a spreadsheet using an "if" funct
... select the column that has the values you want to filter on. ... containing tom are visible. ... > what syntax is correct in the false part of an "if" statement to delete a ... Prev by Date: ...
(microsoft.public.excel.misc) - Importing text file to array?
... I thought if I import text file directly to the array and then filter ... Prev by Date: ...
(microsoft.public.excel.programming) |
|
