Why not use conditional formatting to highlight them when flow = 1?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"strawberry" wrote in message
oups.com...
my table

begin node , end node , flow
1 2 1

flow is either 0 or 1, i want a function that will show all of the rows
where flow =1. its a rather large table so it needs to be dynamic and
only show where flow =1. it should display the values in begin node and
end node, or 2 seperate functions will do the job just as wll.

many thanks