Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Frequency Query
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
histograms - frequency and relative frequency? | Excel Discussion (Misc queries) | |||
Save data retreived from query without saving query | Excel Discussion (Misc queries) | |||
Anyone Else Use Database Query to Query Another Sheet in the Same Excel Workbook? | Excel Discussion (Misc queries) | |||
Microsoft Query rejects "nz" function in Access Query | Excel Discussion (Misc queries) | |||
How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) |