Place this formula
=CELL("address",A1) - change A1 to where your list starts-
in the first row of a free column (say B1)
Autofill it down to your 500 or more cells.
Now use the autofilter, filter through what you need.
THEN: copy this column with the formula ( which tells you where the filtered
numbers reside) and paste them in another sheet or so.....

HTH

Driftwood



"Reinhard Thomann" wrote:

When using AutoFilter:
Is this correct, that i have to go through all 5000 rows to find out which
ones are hidden or not (I need the row numers in an array),
or is it possible to get immediately the results of the filtered list.
Otherwise i'm not sure if there i a time advantage in comparison to directly
check cell by cell value (5000 times).

Thanks
Reinhard


"OssieMac" schrieb im Newsbeitrag
...
You say the values are numerical so you should be able to use AutoFilter
and
set a custom filter greater than or equal to 3 and is less than 4.

--
Regards,

OssieMac


"Reinhard Thomann" wrote:

Hi
what's the fastest method to find all worksheet rows which start with the
same number e.g 3.
The spreadsheet list is unsorted and extends up to 5000 rows. The values
are
numerical.
Sample below: The routine should find for value 3 the rows with 3.1, 3.2
and
3.3 {3,4,7}.

1 Text
2 Text
3.1 Text
3.2 Text
5 Text
3.2 Text
8 Text
3.3 Text
7.2 Text
.....

TIA
Reinhard

Clever idea!

Thanks
Reinhard

"Driftwood" schrieb im Newsbeitrag
...
Place this formula
=CELL("address",A1) - change A1 to where your list starts-
in the first row of a free column (say B1)
Autofill it down to your 500 or more cells.
Now use the autofilter, filter through what you need.
THEN: copy this column with the formula ( which tells you where the
filtered
numbers reside) and paste them in another sheet or so.....

HTH

Driftwood



"Reinhard Thomann" wrote:

When using AutoFilter:
Is this correct, that i have to go through all 5000 rows to find out
which
ones are hidden or not (I need the row numers in an array),
or is it possible to get immediately the results of the filtered list.
Otherwise i'm not sure if there i a time advantage in comparison to
directly
check cell by cell value (5000 times).

Thanks
Reinhard


"OssieMac" schrieb im Newsbeitrag
...
You say the values are numerical so you should be able to use
AutoFilter
and
set a custom filter greater than or equal to 3 and is less than 4.

--
Regards,

OssieMac


"Reinhard Thomann" wrote:

Hi
what's the fastest method to find all worksheet rows which start with
the
same number e.g 3.
The spreadsheet list is unsorted and extends up to 5000 rows. The
values
are
numerical.
Sample below: The routine should find for value 3 the rows with 3.1,
3.2
and
3.3 {3,4,7}.

1 Text
2 Text
3.1 Text
3.2 Text
5 Text
3.2 Text
8 Text
3.3 Text
7.2 Text
.....

TIA
Reinhard