Thread: fancy lookup
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
strawberry
 
Posts: n/a
Default 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