Thread: FIND the exact P/N in a multi P/N range of cells

Hi, all,

The attached WB should clarifymy question.

Thanks, Ben

Try this macro.

Sub FindSpecial()
Dim Cell As Range
Dim SearchString As Range

SearchString = Application.InputBox("Please enter search string")
For Each Cell In Selection
If Cell = SearchString Or Cell Like SearchString & ",*" Or Cell Like "*," & "SearchString" & ",*" Or Cell Like "*, " & "SearchString" & ",*" Then
    Cell.Select
    Exit Sub
End If
Next Cell
End Sub

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

It would be better to have only a single part number in each cell -- that's the way Excel is designed to work.

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,

when the list was created it didn't bother anyone.

well it obviously is now lol
err this is flawed it finds ca, and , aa when it shouldnt, hmm back to the drawing board

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

Cant do anything at the mo my excel has gone mad!

here is the best i can do,by putting the helpers on another sheet which can be hidden/very hidden

Try clarifying the title, P/N could be anything