ROWS Function

  • Thread starter Thread starter Michael
  • Start date Start date
M

Michael

Hi! How do I pass the second argument of the array for the
ROWS function when it comes from the result of another
cell using the address function?

For example, in D200 I have this:
{=ADDRESS(MIN(IF(Evidence="Evidence of Contribution",ROW
(Evidence),"")),COLUMN(Evidence))}

Which provides me the address of the cell that contains
the text "Evidence of Contribution". In this case, it's
$B$149.

Then in A200 I have this:
=ROWS(B27:_______) The second argument should be the
result of the D200.

Thanks for your help!!

Michael
 
Try

=ROWS(B27:INDIRECT(D200))

having said that I am sure you can get the rows in an easier way that this
unless you by some reason
need the cell address?

If that's the case

=ROWS(B27:INDIRECT(ADDRESS(MIN(IF(Evidence="Evidence of
Contribution",ROW(Evidence),"")),COLUMN(Evidence))))

could be replaced by


=MATCH("Evidence of Contribution",Evidence,0)-ROW(B27)+1


and the latter formula can be entered normally

--
For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom
 
Back
Top