B
breezy
Hi! I would like to give a big thank you to Max for all the direction he has
given me in the discussion world!!! I'm a real rookie!
I have a template that exports results from one sheet to another based on
what is entered. It currently only returns results for a specific month and
need it to return results for several months, upto the previous year or
current year.
The following is what I currently have in my results sheet.
Inputs in A1:A3
In C2
=IF(COUNTA($A$1:$A$3)<3,"",IF(AND(Sheet1!A4=$A$1,Sheet1!C4=$A$2,Sheet1!G4=$A$3),ROW(),""))
In D2, copied to I2:
=IF(ROWS($1:1)>COUNT($C:$C),"",INDEX(Sheet1!A:A,SMALL($C:$C,ROWS($1:1))+2))
In J2, copied to M2:
=IF(ROWS($1:1)>COUNT($C:$C),"",INDEX(Sheet1!S:S,SMALL($C:$C,ROWS($1:1))+2))
Select C2:M2, copy down to cover max expected extent of source data in
Sheet1. Format cols to taste. All lines satisfying the criteria inputs in
A1:A3 will appear neatly packed at the top. Try changing the criteria inputs
to a different set, it'll return accordingly.
Thanks so much in advance for any advice you can offer!!!
Breezy
given me in the discussion world!!! I'm a real rookie!
I have a template that exports results from one sheet to another based on
what is entered. It currently only returns results for a specific month and
need it to return results for several months, upto the previous year or
current year.
The following is what I currently have in my results sheet.
Inputs in A1:A3
In C2
=IF(COUNTA($A$1:$A$3)<3,"",IF(AND(Sheet1!A4=$A$1,Sheet1!C4=$A$2,Sheet1!G4=$A$3),ROW(),""))
In D2, copied to I2:
=IF(ROWS($1:1)>COUNT($C:$C),"",INDEX(Sheet1!A:A,SMALL($C:$C,ROWS($1:1))+2))
In J2, copied to M2:
=IF(ROWS($1:1)>COUNT($C:$C),"",INDEX(Sheet1!S:S,SMALL($C:$C,ROWS($1:1))+2))
Select C2:M2, copy down to cover max expected extent of source data in
Sheet1. Format cols to taste. All lines satisfying the criteria inputs in
A1:A3 will appear neatly packed at the top. Try changing the criteria inputs
to a different set, it'll return accordingly.
Thanks so much in advance for any advice you can offer!!!
Breezy