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: 1,814
Default subtotal, match?

Morning all.
I need to do a name check to match with a subtotal function. Is that
possible?

I was thinking that subtotal(Func_Num,match(....)) might handle it, but I
don't see anything that'd allow for that in the list of function numbers for
subtotal.

My goal is to perform a subtotal type operation, to compare names in a field
range from one worksheet to another. I'm already performing a subtotal
operation on one field, and wanted to do an if test on the names that show up
with each operation. With the false response, I'll then be changing the name
element to match my source data.
I hope that's clear-- if not, please let me know.


 
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
sort macro, subtotal and add lines after subtotal David Excel Discussion (Misc queries) 1 August 29th 09 10:56 AM
Double Pivot Table - Match Subtotal Rows Mathew P Bennett Excel Discussion (Misc queries) 2 August 8th 08 03:43 PM
pasting to subtotal lines without replacing hidden -non-subtotal l harleydiva67 Excel Discussion (Misc queries) 1 October 12th 06 06:02 PM
Bolding the subtotal lines automaticlly When using the Subtotal fu 06Speed6 New Users to Excel 2 October 5th 06 03:52 PM
Subtotal of Subtotal displays Grand Total in wrong row Thomas Born Excel Worksheet Functions 5 January 6th 05 01:46 PM


All times are GMT +1. The time now is 05:45 PM.

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"