Hi all
I need a formula that can scan down column "M" and column "N", if it finds a "no"
return the delivery number in column "B" and vendor in column "c"
to a new table/worksheet where I can graph the results.
best regards
Jim
Hi all
I need a formula that can scan down column "M" and column "N", if it finds a "no"
return the delivery number in column "B" and vendor in column "c"
to a new table/worksheet where I can graph the results.
best regards
Jim
Hi and welcome to the forum
i would suggest you upload a sample work book, (all sensitive data removed), showing what data you are working with, a few examples of what your expected outcome is, and how you arrived at that. That way we can see your layout etc
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
Hi and thanks for the response
here is an example of what I hope to achieve
take a look at the attached. I added a helper column to sheet1 column P and copied this down...
=IF(OR(M4="no",N4="no"),P3+1,P3)
and then referenced the values in that column to return te values you wanted...
=IFERROR(INDEX(sheet1!$A:$O,MATCH(ROW(A1),sheet1!$P:$P,0),MATCH(C$6,sheet1!$A$3:$O$3,0)),"")
Please note though, that for the index/match to work, the headings MUST be identical
Hi thanks,
did you attach the correct example ?
I'm not following
LOL sorry, apparently not. Thats what happens when you get a couple of "example" files from different members. Try this 1 instead
Hi, thanks again
it will take me a bit of time to go through that and understand it, however I note their are no "counts" in columns e and f of sheet 2?
forget my last, have realised what you said about titles being the same and this has rectified it
thanks.
you'r welcome. If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neat and tidy lol, and consider adding the reputation to those that helped (see points 2 & 3 below my 1st post to you)
Thanks again,
how can I get it to total the number of "no" by each vendor ?
regards
Jim
ps seemingly I cant add to your reputation until I spread it around.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks