Would it still be practical if I had 250 rows of data total and
needed to pull in 10 columns for only about 20-40 rows?

That should be Ok but you'll have to see how it affects performance and then
make that determination for yourself.

I'm going to break for dinner but I'll put together a sample file that
demonstrates this (unless Max beats me to it!<g) and post a link to the
file.

Biff

"Rikki-Handgards" wrote in
message ...
Thanks Biff. Would it still be practical if I had 250 rows of data total
and
needed to pull in 10 columns for only about 20-40 rows?

"Biff" wrote:

Is there a way to do this with a formula and not a pivot table?

Yes, but whether or not it's practical depends on how many cells from the
row you need returned and in general, how big is the table of data this
data
is being extracted from.

For example, if your table is 50,000 rows by 150 columns and you need all
150 columns of data extracted for each instance of "value", then a
formula
approach is not practical.

Biff

"Rikki-Handgards" wrote in
message ...
Hi. Is there a way to list, on a separate sheet, only rows of data
with a
value in a specific column? I want to list inventory items (and all
data
in
that row) as long as there is a value in column F. If there is no
value
in
column F for that inventory item, I don't want it to be the separate
summary
sheet. Is there a way to do this with a formula and not a pivot table?
Thanks!