Hi, all,
The attached WB should clarifymy question.
Thanks, Ben
Hi, all,
The attached WB should clarifymy question.
Thanks, Ben
Last edited by Benjamin1; 08-20-2011 at 04:08 PM.
Try this macro.
Please Login or Register to view this content.
Martin
mrice,
Appreciate your prompt reply.
As this was only a short example of a much larger table I prefer a WS formula and not VB code.
BTH,
a) I assume you ment: Dim SearchString As String
b) The proposed macro does not end up with the requested sum.
Maybe a User defined function could serve me right if it could be merged into an Array formula like the one in my attached WB.
Thanks, Ben
Last edited by Benjamin1; 08-20-2011 at 04:28 PM.
It would be better to have only a single part number in each cell -- that's the way Excel is designed to work.
Entia non sunt multiplicanda sine necessitate
Thank you, shg,
I know that but when the list was created it didn't bother anyone.
Isn't there a way to accomplish my need with only a WS formula ?
Ben
I would never say it's not possible, but I'd change the worksheet rather than write an ugly slow formula.
here you go ,but i agree one cell per bit of data,
well it obviously is now lolwhen the list was created it didn't bother anyone.
err this is flawed it finds ca, and , aa when it shouldnt, hmm back to the drawing board
Last edited by martindwilson; 08-20-2011 at 05:30 PM.
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Thank you, Martin,
This is a big!!! progress.
I inserted the 3 "M" column cells into the formula and change it a bit.
Now I have one array result with T/F exactly what I was looking for (without any helper columns) except of the CA and AA misscounting.
If you will find a solution for that - I'm all set.
Thanks a lot and pls don't let it fall off the drawing board.
Ben
Last edited by Benjamin1; 08-20-2011 at 06:32 PM.
Cant do anything at the mo my excel has gone mad!
If I may quote Scarlett O'Hara:
"...tomorrow is another day"
Ben
here is the best i can do,by putting the helpers on another sheet which can be hidden/very hidden
Thanks.
Will study this.
Ben
Try clarifying the title, P/N could be anything
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks