Prev: IF formula not working
Next: Remove Last x Character(s) in Selected Cells
From: T. Valko on 1 Apr 2010 14:00
You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Steve" <Steve(a)discussions.microsoft.com> wrote in message
news:3581C258-F49B-4A2A-AAD6-585D268FAB55(a)microsoft.com...
> Thank you. That was it. I was starting on sheet A.
>
> Thanks again,
>
> Steve
>
> "T. Valko" wrote:
>
>> >I want to copy only the unique numbers to
>> >another column on another tab.
>>
>> Let's assume the data to filter is on sheet1 and you want the data
>> extracted
>> to sheet2 starting in cell A1.
>>
>> Navigate to sheet2 cell A1 *then* start the filter process.
>>
>> Data>Filter>Advanced filter
>>
>> --
>> Biff
>> Microsoft Excel MVP
>>
>>
>> "Steve" <Steve(a)discussions.microsoft.com> wrote in message
>> news:D9611C3C-FC5C-4991-A610-A85C2BC053DE(a)microsoft.com...
>> >I having difficulty with unigue filtering. Probably because it's too
>> >close
>> >to
>> > tommorrow.
>> >
>> > I have a range of numbers in a column. There may be up to a hundred
>> > rows.
>> > I want to copy only the unique numbers to another column on another
>> > tab.
>> > Is that possible ?
>> >
>> > 599
>> > 478
>> > 478
>> > 478
>> > 478
>> > 982
>> > 982
>> > 785
>> > 894
>> >
>> > Thanks,
>> >
>> > Steve
>> >
>>
>>
>> .
>>


First  |  Prev  | 
Pages: 1 2
Prev: IF formula not working
Next: Remove Last x Character(s) in Selected Cells