Prev: CSV error when trying to save
Next: Excel
From: kingie on 23 Mar 2010 17:40
i have a list of sequential numbers eg 1 to 100.
I have a second list of numbers eg 5,6,23,38,90
I want to remove the numbers in the second list from the first list.
Leaving me a list of numbers 1 to 100 minus the 5 numbers in the second list.

From: new1 on 23 Mar 2010 19:51
On 23 mar, 22:40, kingie <kin...(a)discussions.microsoft.com> wrote:
> i have a list of sequential numbers eg 1 to 100.
> I have a second list of numbers eg 5,6,23,38,90
> I want to remove the numbers in the second list from the first list.
> Leaving me a list of numbers 1 to 100 minus the 5 numbers in the second list.

Hello,

I would suggest using the vlookup formula in the column next to the "1
to 100" column. Let's say that the "1 to 100" column is column A1 to
A100 and the "5 numbers" column is in "D1 to D5". The formula in
range B1 would look like : =VLOOKUP(A1;$D$1:$D5;false) . This formula
must be copied in column B from 1 to 100. This will return the value
if it's a common value or an error #N/A if not.
In a 2nd step you can also use the ISERROR function.

Hope this helps

new1@[no/spam]realce.net
From: Herbert Seidenberg on 23 Mar 2010 23:28
Excel 2007 Table
Filter out selected numbers
Advanced Filter
http://c0718892.cdn.cloudfiles.rackspacecloud.com/03_23_10a.xlsx
http://www.mediafire.com/file/zzoygidnmzg/03_23_10a.pdf
From: Otto Moehrbach on 25 Mar 2010 07:32
This macro will do what you want. I assumed your 100 numbers are in Column
A, starting in A2, and your search numbers are in Column B starting in B2.
Post back if you need more. HTH Otto
Sub RemoveSome()
Dim rColA As Range
Dim rColB As Range
Dim i As Range
Set rColA = Range("A2", Range("A" & Rows.Count).End(xlUp))
Set rColB = Range("B2", Range("B" & Rows.Count).End(xlUp))
For Each i In rColB
If Not rColA.Find(What:=i, LookAt:=xlWhole) Is Nothing Then
rColA.Find(What:=i, LookAt:=xlWhole).Delete Shift:=xlUp
End If
Next i
End Sub

"kingie" <kingie(a)discussions.microsoft.com> wrote in message
news:F6421100-21A3-4AED-8CA9-D364D111DEC9(a)microsoft.com...
> i have a list of sequential numbers eg 1 to 100.
> I have a second list of numbers eg 5,6,23,38,90
> I want to remove the numbers in the second list from the first list.
> Leaving me a list of numbers 1 to 100 minus the 5 numbers in the second
> list.
>
 | 
Pages: 1
Prev: CSV error when trying to save
Next: Excel