need formula that can search criteria then return entire row
i want to be able to change the titles but if i enter title 4 I want to pull the rows beneath it that are checked.
For instance title 4 would return the following values
a red
c yellow
e blue
f purple
if title 1 is entered the formula would return
a red
c yellow
f purple
procedure description title 1 title 2 title 3 title 4 title 5
a red x x
b orange x x x
c yellow x x
d green x x x
e blue x x
f purple x x x x
can't you use autofilter ?...
can't you use autofilter ?... or am I missing something...