I have a sheet with many rows and i need to filter out old versions of the
row in questions,

example

Mr Smith blah blah aaa bbbb cccc 1
Mr Smith blah blah bbb ccccc 2
Mr Smith aaa bbbb ccc 3

In other words each row is a version on what ever im looking at, How do i
get rid of the old versions i.e. number 1 and number 2 and keep version 3 ??

Hope this explains it ok

regards

In an adjacent column, and assuming that the name is in column A, version in
F, add this formula

=F1=MAX(IF($A$1:$A$1000=A1,$F$1:$F$1000))

it is an array formula, so commit with Ctrl-Shift-Enter.

Copy the formula down for all relevant rows.

Filter Column F (DataFilterAutofilter), select a value of False, then
delete visible rows.

--
HTH

Bob Phillips

"dc" wrote in message
...
I have a sheet with many rows and i need to filter out old versions of the
row in questions,

example

Mr Smith blah blah aaa bbbb cccc 1
Mr Smith blah blah bbb ccccc 2
Mr Smith aaa bbbb ccc 3

In other words each row is a version on what ever im looking at, How do i
get rid of the old versions i.e. number 1 and number 2 and keep version 3
??

Hope this explains it ok

regards

Thank you for that, im not sure its working or I have done it correctly
could i send u some data to explain what I mean ?

regards

"Bob Phillips" wrote in message
...
In an adjacent column, and assuming that the name is in column A, version
in
F, add this formula

=F1=MAX(IF($A$1:$A$1000=A1,$F$1:$F$1000))

it is an array formula, so commit with Ctrl-Shift-Enter.

Copy the formula down for all relevant rows.

Filter Column F (DataFilterAutofilter), select a value of False, then
delete visible rows.

--
HTH

Bob Phillips

"dc" wrote in message
...
I have a sheet with many rows and i need to filter out old versions of
the
row in questions,

example

Mr Smith blah blah aaa bbbb cccc 1
Mr Smith blah blah bbb ccccc 2
Mr Smith aaa bbbb ccc 3

In other words each row is a version on what ever im looking at, How do
i
get rid of the old versions i.e. number 1 and number 2 and keep version
3
??

Hope this explains it ok

regards

Feel free. The addy is

bob dot phillips at tiscali dot co dot uk

do the obvious

--
HTH

Bob Phillips

"dc" wrote in message
...
Thank you for that, im not sure its working or I have done it correctly
could i send u some data to explain what I mean ?

regards

"Bob Phillips" wrote in message
...
In an adjacent column, and assuming that the name is in column A,
version
in
F, add this formula

=F1=MAX(IF($A$1:$A$1000=A1,$F$1:$F$1000))

it is an array formula, so commit with Ctrl-Shift-Enter.

Copy the formula down for all relevant rows.

Filter Column F (DataFilterAutofilter), select a value of False, then
delete visible rows.

--
HTH

Bob Phillips

"dc" wrote in message
...
I have a sheet with many rows and i need to filter out old versions of
the
row in questions,

example

Mr Smith blah blah aaa bbbb cccc 1
Mr Smith blah blah bbb ccccc 2
Mr Smith aaa bbbb ccc 3

In other words each row is a version on what ever im looking at, How
do
i
get rid of the old versions i.e. number 1 and number 2 and keep
version
3
??

Hope this explains it ok

regards

Bob see attached data ,there is alot more coloums that i have not shown but
it seems to be doing it the wrong way round, the version i want kept is the
highest version and not lowest does that make sense??

regrads
"Bob Phillips" wrote in message
...
Feel free. The addy is

bob dot phillips at tiscali dot co dot uk

do the obvious

--
HTH

Bob Phillips

"dc" wrote in message
...
Thank you for that, im not sure its working or I have done it correctly
could i send u some data to explain what I mean ?

regards

"Bob Phillips" wrote in message
...
In an adjacent column, and assuming that the name is in column A,
version
in
F, add this formula

=F1=MAX(IF($A$1:$A$1000=A1,$F$1:$F$1000))

it is an array formula, so commit with Ctrl-Shift-Enter.

Copy the formula down for all relevant rows.

Filter Column F (DataFilterAutofilter), select a value of False,
then
delete visible rows.

--
HTH

Bob Phillips

"dc" wrote in message
...
I have a sheet with many rows and i need to filter out old versions
of
the
row in questions,

example

Mr Smith blah blah aaa bbbb cccc 1
Mr Smith blah blah bbb ccccc 2
Mr Smith aaa bbbb ccc 3

In other words each row is a version on what ever im looking at, How
do
i
get rid of the old versions i.e. number 1 and number 2 and keep
version
3
??

Hope this explains it ok

regards

Got it. Put this formula in some spare column, say G3

=D3=MAX(IF($A$3:$A$1000=A3,$D$3:$D$1000))

then as before, copy the formula down for all relevant rows.

Filter Column F (DataFilterAutofilter), click the dropdown arrow, select
the value of False, then delete visible rows.


--
HTH

Bob Phillips

"dc" wrote in message
...
Bob see attached data ,there is alot more coloums that i have not shown
but
it seems to be doing it the wrong way round, the version i want kept is
the
highest version and not lowest does that make sense??

regrads
"Bob Phillips" wrote in message
...
Feel free. The addy is

bob dot phillips at tiscali dot co dot uk

do the obvious

--
HTH

Bob Phillips

"dc" wrote in message
...
Thank you for that, im not sure its working or I have done it
correctly
could i send u some data to explain what I mean ?

regards

"Bob Phillips" wrote in message
...
In an adjacent column, and assuming that the name is in column A,
version
in
F, add this formula

=F1=MAX(IF($A$1:$A$1000=A1,$F$1:$F$1000))

it is an array formula, so commit with Ctrl-Shift-Enter.

Copy the formula down for all relevant rows.

Filter Column F (DataFilterAutofilter), select a value of False,
then
delete visible rows.

--
HTH

Bob Phillips

"dc" wrote in message
...
I have a sheet with many rows and i need to filter out old
versions
of
the
row in questions,

example

Mr Smith blah blah aaa bbbb cccc 1
Mr Smith blah blah bbb ccccc 2
Mr Smith aaa bbbb ccc 3

In other words each row is a version on what ever im looking at,
How
do
i
get rid of the old versions i.e. number 1 and number 2 and keep
version
3
??

Hope this explains it ok

regards

SED00001672 FALSE TRUE 1
SED00001672 FALSE FALSE 2
SED00001672 FALSE FALSE 3
SED00001672 FALSE FALSE 4

that's the results i was getting for the first query and the second one you
sent was everything false except the very last record in the whole sheet, If
poss I want the forth version in this list to be the true one....

Sorry Bob for being very confusing...

"Bob Phillips" wrote in message
...
Got it. Put this formula in some spare column, say G3

=D3=MAX(IF($A$3:$A$1000=A3,$D$3:$D$1000))

then as before, copy the formula down for all relevant rows.

Filter Column F (DataFilterAutofilter), click the dropdown arrow, select
the value of False, then delete visible rows.


--
HTH

Bob Phillips

"dc" wrote in message
...
Bob see attached data ,there is alot more coloums that i have not shown
but
it seems to be doing it the wrong way round, the version i want kept is
the
highest version and not lowest does that make sense??

regrads
"Bob Phillips" wrote in message
...
Feel free. The addy is

bob dot phillips at tiscali dot co dot uk

do the obvious

--
HTH

Bob Phillips

"dc" wrote in message
...
Thank you for that, im not sure its working or I have done it
correctly
could i send u some data to explain what I mean ?

regards

"Bob Phillips" wrote in message
...
In an adjacent column, and assuming that the name is in column A,
version
in
F, add this formula

=F1=MAX(IF($A$1:$A$1000=A1,$F$1:$F$1000))

it is an array formula, so commit with Ctrl-Shift-Enter.

Copy the formula down for all relevant rows.

Filter Column F (DataFilterAutofilter), select a value of False,
then
delete visible rows.

--
HTH

Bob Phillips

"dc" wrote in message
...
I have a sheet with many rows and i need to filter out old
versions
of
the
row in questions,

example

Mr Smith blah blah aaa bbbb cccc 1
Mr Smith blah blah bbb ccccc 2
Mr Smith aaa bbbb ccc 3

In other words each row is a version on what ever im looking at,
How
do
i
get rid of the old versions i.e. number 1 and number 2 and keep
version
3
??

Hope this explains it ok

regards

Can anyone help pwith this pls ???

Bob has given me the query but it works in opp way i want it to ...



"dc" wrote in message
...
SED00001672 FALSE TRUE 1
SED00001672 FALSE FALSE 2
SED00001672 FALSE FALSE 3
SED00001672 FALSE FALSE 4

that's the results i was getting for the first query and the second one
you
sent was everything false except the very last record in the whole sheet,
If
poss I want the forth version in this list to be the true one....

Sorry Bob for being very confusing...

"Bob Phillips" wrote in message
...
Got it. Put this formula in some spare column, say G3

=D3=MAX(IF($A$3:$A$1000=A3,$D$3:$D$1000))

then as before, copy the formula down for all relevant rows.

Filter Column F (DataFilterAutofilter), click the dropdown arrow,
select
the value of False, then delete visible rows.


--
HTH

Bob Phillips

"dc" wrote in message
...
Bob see attached data ,there is alot more coloums that i have not
shown
but
it seems to be doing it the wrong way round, the version i want kept
is
the
highest version and not lowest does that make sense??

regrads
"Bob Phillips" wrote in message
...
Feel free. The addy is

bob dot phillips at tiscali dot co dot uk

do the obvious

--
HTH

Bob Phillips

"dc" wrote in message
...
Thank you for that, im not sure its working or I have done it
correctly
could i send u some data to explain what I mean ?

regards

"Bob Phillips" wrote in message
...
In an adjacent column, and assuming that the name is in column
A,
version
in
F, add this formula

=F1=MAX(IF($A$1:$A$1000=A1,$F$1:$F$1000))

it is an array formula, so commit with Ctrl-Shift-Enter.

Copy the formula down for all relevant rows.

Filter Column F (DataFilterAutofilter), select a value of
False,
then
delete visible rows.

--
HTH

Bob Phillips

"dc" wrote in message
...
I have a sheet with many rows and i need to filter out old
versions
of
the
row in questions,

example

Mr Smith blah blah aaa bbbb cccc 1
Mr Smith blah blah bbb ccccc 2
Mr Smith aaa bbbb ccc 3

In other words each row is a version on what ever im looking
at,
How
do
i
get rid of the old versions i.e. number 1 and number 2 and
keep
version
3
??

Hope this explains it ok

regards