View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ryguy7272 ryguy7272 is offline
external usenet poster
 
Posts: 2,836
Default Index/Match to get Count (from Subtotals) into a Table of Names

I have subtotals on the second page of my workbook, counting names of
persons, and a list of persons on the first page. I though, maybe, I could
use Index/Match to get the results of the counts of the persons on the second
page into a table of names on the first page, but that didn't work. I have
this function:
=INDEX(RUBY!$D$2:$D$4500,MATCH(B5,RUBY!$D$2:$D$450 0,0))

This matches the names fine, but I really wanted to putt the numbers (the
counts of names) into the table of names.

Please help.

Thanks,
Ryan---

--
RyGuy