fancy lookup
 

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

fancy lookup
 

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

fancy lookup
 

strwberry,

or use autofilter on the flow row?

Beege

"Bob Phillips" wrote in message
...
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

fancy lookup
 

thanks guys, thats awesome.
Beege wrote:
strwberry,

or use autofilter on the flow row?

Beege

"Bob Phillips" wrote in message
...
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

fancy lookup
 

Hi Strawberry,

Another way.

=IF(C2=1,A2&" "&B2&" "&"Flo="&C2,"")

Where Begin is in column A
Where End is in column B
Where Flow is in column C
Fill down as far as needed

HTH
Regards,


"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