comparing lists

Thought #1) Did you remember to use ctrl-shift-enter?
Thought #2) Try using vlookup and capture the 'not founds' with...
if(Isna(vlookup(...)),"No in other list","")

HTH,
--
Gary Brown
gary_brown@ge_NOSPAM.com
If this post was helpful, please click the ''''Yes'''' button next to
''''Was this Post Helpfull to you?".


"sofiane b via OfficeKB.com" wrote:

> i have tried the cpearson methods and conditional formatting wth colors but i
> cant seem to have it working nothig happens..
>
> i need to compare column A that has 1008 rows with column B that has 1031
> rows and gives me the difference between the them or something in that area..
> ...
>
> can someone help? thank you alot
>
>
> --
> Message posted via OfficeKB.com
> http://www.officekb.com/Uwe/Forums.a...tions/200507/1
>

i obviously did i never heard of it and dont know when to use this
details please? i owe you big time

Gary L Brown wrote:
>Thought #1) Did you remember to use ctrl-shift-enter?
>Thought #2) Try using vlookup and capture the 'not founds' with...
> if(Isna(vlookup(...)),"No in other list","")
>
>HTH,
>> i have tried the cpearson methods and conditional formatting wth colors but i
>> cant seem to have it working nothig happens..
>[quoted text clipped - 4 lines]
>>
>> can someone help? thank you alot


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200507/1

i meant i obvisouly didnt lol
thanx again


sofiane b wrote:
>i obviously did i never heard of it and dont know when to use this
>details please? i owe you big time
>
>>Thought #1) Did you remember to use ctrl-shift-enter?
>>Thought #2) Try using vlookup and capture the 'not founds' with...
>[quoted text clipped - 6 lines]
>>>
>>> can someone help? thank you alot


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200507/1

Using Chip's website for an example of using arrays, which I THINK, is what
you're trying to do...
http://www.cpearson.com/excel/duplic...CountingUnique
"Testing For Duplicate Entries

If you need to determine whether a list in Excel has duplicate entries, you
can use the following formula. It will display "Duplicates" if the list in
Range1 has duplicate entries, or "No Duplicates" if the range does not have
any duplicates.

=IF(MAX(COUNTIF(Range1,Range1))>1,"Duplicates","No Duplicates")

This is an array formula, so you must press Ctrl+Shift+Enter rather than
just Enter when you first enter the formula, and when ever you edit it later.
This formula requires that the complete range contain data. If only the
first N cells contain data, and the rest are empty, the formula will return
"Duplicates" because it considers the empty cells to be duplicates of
themselves."

HTH,
--
Gary Brown
gary_brown@ge_NOSPAM.com
If this post was helpful, please click the ''''Yes'''' button next to
''''Was this Post Helpfull to you?".


"sofiane b via OfficeKB.com" wrote:

> i obviously did i never heard of it and dont know when to use this
> details please? i owe you big time
>
> Gary L Brown wrote:
> >Thought #1) Did you remember to use ctrl-shift-enter?
> >Thought #2) Try using vlookup and capture the 'not founds' with...
> > if(Isna(vlookup(...)),"No in other list","")
> >
> >HTH,
> >> i have tried the cpearson methods and conditional formatting wth colors but i
> >> cant seem to have it working nothig happens..
> >[quoted text clipped - 4 lines]
> >>
> >> can someone help? thank you alot
>
>
> --
> Message posted via OfficeKB.com
> http://www.officekb.com/Uwe/Forums.a...tions/200507/1
>

Thought #1) Did you remember to use ctrl-shift-enter?
Thought #2) Try using vlookup and capture the 'not founds' with...
if(Isna(vlookup(...)),"No in other list","")

HTH,
--
Gary Brown
gary_brown@ge_NOSPAM.com
If this post was helpful, please click the ''''Yes'''' button next to
''''Was this Post Helpfull to you?".


"sofiane b via OfficeKB.com" wrote:

> i have tried the cpearson methods and conditional formatting wth colors but i
> cant seem to have it working nothig happens..
>
> i need to compare column A that has 1008 rows with column B that has 1031
> rows and gives me the difference between the them or something in that area..
> ...
>
> can someone help? thank you alot
>
>
> --
> Message posted via OfficeKB.com
> http://www.officekb.com/Uwe/Forums.a...tions/200507/1
>

i obviously did i never heard of it and dont know when to use this
details please? i owe you big time

Gary L Brown wrote:
>Thought #1) Did you remember to use ctrl-shift-enter?
>Thought #2) Try using vlookup and capture the 'not founds' with...
> if(Isna(vlookup(...)),"No in other list","")
>
>HTH,
>> i have tried the cpearson methods and conditional formatting wth colors but i
>> cant seem to have it working nothig happens..
>[quoted text clipped - 4 lines]
>>
>> can someone help? thank you alot


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200507/1

i meant i obvisouly didnt lol
thanx again


sofiane b wrote:
>i obviously did i never heard of it and dont know when to use this
>details please? i owe you big time
>
>>Thought #1) Did you remember to use ctrl-shift-enter?
>>Thought #2) Try using vlookup and capture the 'not founds' with...
>[quoted text clipped - 6 lines]
>>>
>>> can someone help? thank you alot


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200507/1

Using Chip's website for an example of using arrays, which I THINK, is what
you're trying to do...
http://www.cpearson.com/excel/duplic...CountingUnique
"Testing For Duplicate Entries

If you need to determine whether a list in Excel has duplicate entries, you
can use the following formula. It will display "Duplicates" if the list in
Range1 has duplicate entries, or "No Duplicates" if the range does not have
any duplicates.

=IF(MAX(COUNTIF(Range1,Range1))>1,"Duplicates","No Duplicates")

This is an array formula, so you must press Ctrl+Shift+Enter rather than
just Enter when you first enter the formula, and when ever you edit it later.
This formula requires that the complete range contain data. If only the
first N cells contain data, and the rest are empty, the formula will return
"Duplicates" because it considers the empty cells to be duplicates of
themselves."

HTH,
--
Gary Brown
gary_brown@ge_NOSPAM.com
If this post was helpful, please click the ''''Yes'''' button next to
''''Was this Post Helpfull to you?".


"sofiane b via OfficeKB.com" wrote:

> i obviously did i never heard of it and dont know when to use this
> details please? i owe you big time
>
> Gary L Brown wrote:
> >Thought #1) Did you remember to use ctrl-shift-enter?
> >Thought #2) Try using vlookup and capture the 'not founds' with...
> > if(Isna(vlookup(...)),"No in other list","")
> >
> >HTH,
> >> i have tried the cpearson methods and conditional formatting wth colors but i
> >> cant seem to have it working nothig happens..
> >[quoted text clipped - 4 lines]
> >>
> >> can someone help? thank you alot
>
>
> --
> Message posted via OfficeKB.com
> http://www.officekb.com/Uwe/Forums.a...tions/200507/1
>

i have tried the cpearson methods and conditional formatting wth colors but i
cant seem to have it working nothig happens..

i need to compare column A that has 1008 rows with column B that has 1031
rows and gives me the difference between the them or something in that area..
...

can someone help? thank you alot


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200507/1

Thought #1) Did you remember to use ctrl-shift-enter?
Thought #2) Try using vlookup and capture the 'not founds' with...
if(Isna(vlookup(...)),"No in other list","")

HTH,
--
Gary Brown
gary_brown@ge_NOSPAM.com
If this post was helpful, please click the ''''Yes'''' button next to
''''Was this Post Helpfull to you?".


"sofiane b via OfficeKB.com" wrote:

> i have tried the cpearson methods and conditional formatting wth colors but i
> cant seem to have it working nothig happens..
>
> i need to compare column A that has 1008 rows with column B that has 1031
> rows and gives me the difference between the them or something in that area..
> ...
>
> can someone help? thank you alot
>
>
> --
> Message posted via OfficeKB.com
> http://www.officekb.com/Uwe/Forums.a...tions/200507/1
>

i obviously did i never heard of it and dont know when to use this
details please? i owe you big time

Gary L Brown wrote:
>Thought #1) Did you remember to use ctrl-shift-enter?
>Thought #2) Try using vlookup and capture the 'not founds' with...
> if(Isna(vlookup(...)),"No in other list","")
>
>HTH,
>> i have tried the cpearson methods and conditional formatting wth colors but i
>> cant seem to have it working nothig happens..
>[quoted text clipped - 4 lines]
>>
>> can someone help? thank you alot


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200507/1

i meant i obvisouly didnt lol
thanx again


sofiane b wrote:
>i obviously did i never heard of it and dont know when to use this
>details please? i owe you big time
>
>>Thought #1) Did you remember to use ctrl-shift-enter?
>>Thought #2) Try using vlookup and capture the 'not founds' with...
>[quoted text clipped - 6 lines]
>>>
>>> can someone help? thank you alot


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200507/1

Using Chip's website for an example of using arrays, which I THINK, is what
you're trying to do...
http://www.cpearson.com/excel/duplic...CountingUnique
"Testing For Duplicate Entries

If you need to determine whether a list in Excel has duplicate entries, you
can use the following formula. It will display "Duplicates" if the list in
Range1 has duplicate entries, or "No Duplicates" if the range does not have
any duplicates.

=IF(MAX(COUNTIF(Range1,Range1))>1,"Duplicates","No Duplicates")

This is an array formula, so you must press Ctrl+Shift+Enter rather than
just Enter when you first enter the formula, and when ever you edit it later.
This formula requires that the complete range contain data. If only the
first N cells contain data, and the rest are empty, the formula will return
"Duplicates" because it considers the empty cells to be duplicates of
themselves."

HTH,
--
Gary Brown
gary_brown@ge_NOSPAM.com
If this post was helpful, please click the ''''Yes'''' button next to
''''Was this Post Helpfull to you?".


"sofiane b via OfficeKB.com" wrote:

> i obviously did i never heard of it and dont know when to use this
> details please? i owe you big time
>
> Gary L Brown wrote:
> >Thought #1) Did you remember to use ctrl-shift-enter?
> >Thought #2) Try using vlookup and capture the 'not founds' with...
> > if(Isna(vlookup(...)),"No in other list","")
> >
> >HTH,
> >> i have tried the cpearson methods and conditional formatting wth colors but i
> >> cant seem to have it working nothig happens..
> >[quoted text clipped - 4 lines]
> >>
> >> can someone help? thank you alot
>
>
> --
> Message posted via OfficeKB.com
> http://www.officekb.com/Uwe/Forums.a...tions/200507/1
>