J
John Moore
Hi, I am looking for a solution to a problem. I want to be able to return
every instance from a report using 2 criteria ( product and type ). Currently
I am using the following ... where Attach is the tab where the report is held.
=IF(ISERROR(SMALL(Attach!$E:$E,ROWS($B$3:B3))),"",
INDEX(Attach!B:B,MATCH(SMALL(Attach!$E:$E,
ROWS($B$3:B3)),Attach!$E:$E,0)))
This works using type as a criteria, is there a way to amend this formula (
or is there another more powerful formula ) so that I can capture the data
using both product and type categories ( The Attach tab uses colum E to show
the row numbers where the type criteria is being met ). ROWS($B$3:B3)
represents the cell where the type name is.
every instance from a report using 2 criteria ( product and type ). Currently
I am using the following ... where Attach is the tab where the report is held.
=IF(ISERROR(SMALL(Attach!$E:$E,ROWS($B$3:B3))),"",
INDEX(Attach!B:B,MATCH(SMALL(Attach!$E:$E,
ROWS($B$3:B3)),Attach!$E:$E,0)))
This works using type as a criteria, is there a way to amend this formula (
or is there another more powerful formula ) so that I can capture the data
using both product and type categories ( The Attach tab uses colum E to show
the row numbers where the type criteria is being met ). ROWS($B$3:B3)
represents the cell where the type name is.