On 2002-10-03 12:26, shroeder wrote:
The following formula works fine:
IF(ISNUMBER(MATCH(E2,'Loop Library'!F$34:F$49,0)),"Fujimoto"," ")
Because it's only looking at three cells within the F34:F49 range that are
the result of a filter.
But now when I re-filter those coumns in 'Loop Library' doc with new
criteria, the corresponding formulas don¹t see the filter, they just see the
entire range. Here are two formulas that have that problem and I can't
figure out what¹s different from the one that works:
IF(ISNUMBER(MATCH(E2,'Loop Library'!F$120:F$140,0)),"Chip Martin"," ")
IF(ISNUMBER(MATCH(E2,'Loop Library'!F$6:F$103,0)),"Mike Bielenberg"," ")
On the last thread, I was asked for more info about the filtering so here
goes:
'Loop Library' is a worksheet with about 45 columns, three of which are
relevant to this problem. The first two refer to a range of text values
which are "title of music piece" and "composer". The third column SUMS the
number of times each piece of music was sold.
First, I filter all "0"s out of the SUM column so I only see pieces that
have actually sold.
Second, I sort the "composer" column so I¹m only seeing the works by one
individual.
The formulas I'm using in the next worksheet are then supposed to only
reference the visible range of cells in the "title of music piece" column.
Hope all that makes sense