Help with scrubing two list of names
 

Ok, I have two spreadsheets of names, one is an active roster report o
names and the other is a finance report of names, I need to be able t
take the names missing from the finance report based off the activ
roster report and display them? Kind of like displaying names tha
don't match! Can anyone help me. Thank

--
numerio
-----------------------------------------------------------------------
numerion's Profile: http://www.excelforum.com/member.php...fo&userid=2297
View this thread: http://www.excelforum.com/showthread.php?threadid=37675

Help with scrubing two list of names
 

Hi,

Let's say you ahve the 2 lists in 2 sheets.

Finance (a complete list) is on Sheet1, and Active (a subset of finance), is
on sheet 2.

Let's assume there are 30 names on sheet1, running from A2: A31, and 12
names on Sheet2, running from A2: A14.

On Sheet1, Cell B2, type: =IF(ISERROR((vlookup($A$2:$A$31,
Sheet2!$A$2:$A$14, 1, 0)), "Not Active", ((vlookup($A$2:$A$31,
Sheet2!$A$2:$A$14, 1, 0))).

This will either return the person's name from Sheet2, or "Not Active" text.
You can then use DataFilterAutofilter to display only those names which
have a "Not Active" against them.

Hope this helps.

Warm regards

Sunil Jayakumar


"numerion" wrote in
message ...

Ok, I have two spreadsheets of names, one is an active roster report of
names and the other is a finance report of names, I need to be able to
take the names missing from the finance report based off the active
roster report and display them? Kind of like displaying names that
don't match! Can anyone help me. Thanks


--
numerion
------------------------------------------------------------------------
numerion's Profile:
http://www.excelforum.com/member.php...o&userid=22975
View this thread: http://www.excelforum.com/showthread...hreadid=376759
www.ayyoo.com/credit-cards.html

Help with scrubing two list of names
 

There is a function VLOOKUP.
I think thats the easy solution

--
Kaa
-----------------------------------------------------------------------
Kaak's Profile: http://www.excelforum.com/member.php...nfo&userid=751
View this thread: http://www.excelforum.com/showthread.php?threadid=37675

Help with scrubing two list of names
 

=IF(ISERROR((vlookup($A$2:$A$31,
Sheet2!$A$2:$A$14, 1, 0)), "Not Active", ((vlookup($A$2:$A$31,
Sheet2!$A$2:$A$14, 1, 0))).

Im using this formula to take names from one sheet and display o
another sheet but when I put the formula in B2 Im not getting an
results. Can someone help me please

--
numerio
-----------------------------------------------------------------------
numerion's Profile: http://www.excelforum.com/member.php...fo&userid=2297
View this thread: http://www.excelforum.com/showthread.php?threadid=37675

Help with scrubing two list of names
 

maybe....

=if(iserror(match(a2,sheet2!$a$2:$a$14,0)),"not active",a2)

(if you're returning the same value, you might as well just use the lookup
value.)



numerion wrote:

=IF(ISERROR((vlookup($A$2:$A$31,
Sheet2!$A$2:$A$14, 1, 0)), "Not Active", ((vlookup($A$2:$A$31,
Sheet2!$A$2:$A$14, 1, 0))).

Im using this formula to take names from one sheet and display on
another sheet but when I put the formula in B2 Im not getting any
results. Can someone help me please?

--
numerion
------------------------------------------------------------------------
numerion's Profile: http://www.excelforum.com/member.php...o&userid=22975
View this thread: http://www.excelforum.com/showthread...hreadid=376759

--

Dave Peterson