Book2 (10).xlsx
i would like to copy all numbers that are above "pick" and in a row with "w" so i have them writen down for analysis
i tryed this formula =IFERROR(INDEX($G$4:$G$324;SMALL(IF(($C$4:$C$324="W")*($G$5:$G$325="PICK"),ROW($G$4:$G$324)-ROW($G$4)+1);ROWS($O$1:$O1)));"")
but it returns an error.
please help me with this problem
i would like to copy numbers 2.25, 1,62 but not 3,9 and 2,1 and so on..
if someone can solve this, plese explain what is wrong with this formula
Last edited by kronikjb; 01-31-2015 at 02:36 AM.
i started in O3 space
or if someone can find different solution for my problem
I think this is a regional setting problem. I changed a;; the ; to , and it worked...I see that you have at least 1 , in there (just before the ROW() function. Try changing that to ; then use CSE again
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
solved, i changed the comma to ; and it worked thanks
It's always the little things
Happy to help, thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks