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.

Ok, I realized that I had this backwards, so I tried
Match(subtotal(109,range),ArrayRng,0)
and it doesn't work either.

I hope that's clear-- if not, please let me know.

Well, it's not real clear to me. But sometimes I'm really dense!

It sounds/looks like you want to a do a "SUM IF" on a filtered range?

"SUM column B IF column A equals Joe" on a filtered list.

Am I close?

--
Biff
Microsoft Excel MVP


"Steve" wrote in message
...
Ok, I realized that I had this backwards, so I tried
Match(subtotal(109,range),ArrayRng,0)
and it doesn't work either.

Don't feel bad Biff.
I get pretty dense too..... Hence my poor explanation...... ;-(

Ok, what I'm doing is filtering two wksheets, based on a single criteria. In
my case, a property parcel #.

My goal is to check the name of the owner's on each wksheet. One wksheet I
know is valid, the other is to get it correctly updated.

If the name from pageA matches the name on pageB, then great-- some kind of
a TRUE statement, as in an IF equation.

I've tried vlookup, match, subtotal, and an IF. So far my attempts have met
with #N/A Errors.

It seems to me that vlookup should work, if I have the correct order.
Because I'm filtering, it seems that subtotal would be required too.

At this point, I'm wondering if some UDF might be required, but I have no
idea where to take that idea.


"T. Valko" wrote:

I hope that's clear-- if not, please let me know.

Well, it's not real clear to me. But sometimes I'm really dense!

It sounds/looks like you want to a do a "SUM IF" on a filtered range?

"SUM column B IF column A equals Joe" on a filtered list.

Am I close?

--
Biff
Microsoft Excel MVP


"Steve" wrote in message
...
Ok, I realized that I had this backwards, so I tried
Match(subtotal(109,range),ArrayRng,0)
and it doesn't work either.



.

Ok, need some of the details...

Sheet1 A2:A10 = parcel numbers
Sheet2 A2:A10 = parcel numbers

You filter both sheets on parcel number 999.

Now what? You said you want to compare owners. Ok, so where do we look to
see if the owners are the same?

--
Biff
Microsoft Excel MVP


"Steve" wrote in message
...
Don't feel bad Biff.
I get pretty dense too..... Hence my poor explanation...... ;-(

Ok, what I'm doing is filtering two wksheets, based on a single criteria.
In
my case, a property parcel #.

My goal is to check the name of the owner's on each wksheet. One wksheet I
know is valid, the other is to get it correctly updated.

If the name from pageA matches the name on pageB, then great-- some kind
of
a TRUE statement, as in an IF equation.

I've tried vlookup, match, subtotal, and an IF. So far my attempts have
met
with #N/A Errors.

It seems to me that vlookup should work, if I have the correct order.
Because I'm filtering, it seems that subtotal would be required too.

At this point, I'm wondering if some UDF might be required, but I have no
idea where to take that idea.


"T. Valko" wrote:

I hope that's clear-- if not, please let me know.

Well, it's not real clear to me. But sometimes I'm really dense!

It sounds/looks like you want to a do a "SUM IF" on a filtered range?

"SUM column B IF column A equals Joe" on a filtered list.

Am I close?

--
Biff
Microsoft Excel MVP


"Steve" wrote in message
...
Ok, I realized that I had this backwards, so I tried
Match(subtotal(109,range),ArrayRng,0)
and it doesn't work either.



.

Details:

Sht1!A4:A188 = parcel #'s
Sht2!A4:A289 = parcel #'s

In column F (both sheets) the name of the owner appears. I.e., the row for
the specifed parcel will show all pertinent data, of which, column F shows
owner's name.

Below all my data, in an open area, I want to place the equation to check
the filtered names.
This will prevent me from having to check back and forth between both
worksheets when the owner's name already matches.

Something of an IF eq'n. I just want to have it say- 'ok' if values match,
and the correct owner's name if they don't match.

Hope that's clear....

Thanks again for all your help-- it's really appreciated.


"T. Valko" wrote:

Ok, need some of the details...

Sheet1 A2:A10 = parcel numbers
Sheet2 A2:A10 = parcel numbers

You filter both sheets on parcel number 999.

Now what? You said you want to compare owners. Ok, so where do we look to
see if the owners are the same?

--
Biff
Microsoft Excel MVP


"Steve" wrote in message
...
Don't feel bad Biff.
I get pretty dense too..... Hence my poor explanation...... ;-(

Ok, what I'm doing is filtering two wksheets, based on a single criteria.
In
my case, a property parcel #.

My goal is to check the name of the owner's on each wksheet. One wksheet I
know is valid, the other is to get it correctly updated.

If the name from pageA matches the name on pageB, then great-- some kind
of
a TRUE statement, as in an IF equation.

I've tried vlookup, match, subtotal, and an IF. So far my attempts have
met
with #N/A Errors.

It seems to me that vlookup should work, if I have the correct order.
Because I'm filtering, it seems that subtotal would be required too.

At this point, I'm wondering if some UDF might be required, but I have no
idea where to take that idea.


"T. Valko" wrote:

I hope that's clear-- if not, please let me know.

Well, it's not real clear to me. But sometimes I'm really dense!

It sounds/looks like you want to a do a "SUM IF" on a filtered range?

"SUM column B IF column A equals Joe" on a filtered list.

Am I close?

--
Biff
Microsoft Excel MVP


"Steve" wrote in message
...
Ok, I realized that I had this backwards, so I tried
Match(subtotal(109,range),ArrayRng,0)
and it doesn't work either.



.



.

I've now tried vlookup and it too isn't giving me what I'm looking for.
My eq arrangement is:

=VLOOKUP(SUBTOTAL(109,range),range,1,FALSE)