LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Match and Count duplicate names Donald B Excel Worksheet Functions 4 June 9th 07 08:05 PM
INDEX/MATCH Functions with row-arranged table. Bob Keller Excel Worksheet Functions 1 November 2nd 06 12:13 AM
table, index, array, match, lookup? spxer Excel Worksheet Functions 2 August 8th 06 09:34 PM
Index,Match table array in separate workbook Ben Excel Worksheet Functions 6 May 11th 06 08:39 AM
Index & Match on Pivot Table Nelson Excel Discussion (Misc queries) 2 April 11th 05 02:16 PM


All times are GMT +1. The time now is 10:46 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"