Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Match and Count duplicate names | Excel Worksheet Functions | |||
INDEX/MATCH Functions with row-arranged table. | Excel Worksheet Functions | |||
table, index, array, match, lookup? | Excel Worksheet Functions | |||
Index,Match table array in separate workbook | Excel Worksheet Functions | |||
Index & Match on Pivot Table | Excel Discussion (Misc queries) |