LinkBack URL
About LinkBacks
I would like to extract all values from sheet (cutsold) on column BR that have greater than 0 value on EITHER column (R) OR (T).
The values should be listed on Sheet (Main) beginning on A4
I would like to extract all values from sheet (cutsold) on column BR that have greater than 0 value on EITHER column (R) OR (T).
The values should be listed on Sheet (Main) beginning on A4
Try this ARRAY formula (not VBA)...
style color desc longdesc AL20MP CML 20 ROUND MICRO MINK 20 ROUND MICRO MINK AL20MP GRY 20 ROUND MICRO MINK 20 ROUND MICRO MINK ALC33 GRY 33BOLSTER CUDDLER 33BOLSTER CUDDLER ALC33 TAN 33BOLSTER CUDDLER 33BOLSTER CUDDLER ALR28 GRY ROUND28 DIAMETERX8 ROUND28 DIAMETERX8 ALR28 TAN ROUND28 DIAMETERX8 ROUND28 DIAMETERX8 AM2622FB LGY bolster pet bed bolster pet bed AM2822RF LGY RECT.BED RECT.BED BBR110SS CML 70.5x110 Sofa Cover 70.5x110 Sofa Cover BBR110SS MOC 70.5x110 Sofa Cover 70.5x110 Sofa Cover BCDF18KC GRY 7x18 Round Kitty Cup 7x18 Round Kitty Cup
A2=IFERROR(INDEX(CutSold!A:A,SMALL(IF((CutSold!$R$2:$R$2432>0)+(CutSold!$T$2:$T$2432>0),ROW(CutSold!$A$2:$A$2432)),ROWS($A$1:A1))),"")
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
Copy down and then copy across as needed
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
looks like that worked
Happy to help and thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks