fancy lookup

S

strawberry

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
 
B

Bob Phillips

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
L

L. Howard Kittle

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,
 
Top