Find/Find all
 

Hello

I've got a spreadsheet that I need to do a search for on part numbers, and
there may be multiple part numbers. If there are duplicate then I'll use
the Revison letter of the latest occurance. The cloum headers never change,
so i know that b2:b500 is a range for the part numbers that I need to
search, and e2:e500 is the range for the rev letter.

Can I use the find function, or the findall function, to return me a range,
or a count of numbers of cells that is equal to the part number I need? If
the count is 1, I can just grab that row, if the count is greater then one,
then I need to look at the cell that contains the value of the Rev letter
used to determine the latest entry.

Whats the best approach here

Find/Find all
 

If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Peter" wrote in message
...
Hello

I've got a spreadsheet that I need to do a search for on part numbers, and
there may be multiple part numbers. If there are duplicate then I'll use
the Revison letter of the latest occurance. The cloum headers never
change, so i know that b2:b500 is a range for the part numbers that I need
to search, and e2:e500 is the range for the rev letter.

Can I use the find function, or the findall function, to return me a
range, or a count of numbers of cells that is equal to the part number I
need? If the count is 1, I can just grab that row, if the count is
greater then one, then I need to look at the cell that contains the value
of the Rev letter used to determine the latest entry.

Whats the best approach here

Find/Find all
 

Thanks, but I figured out the sytanx for the find function.


"Peter" wrote in message
...
Hello

I've got a spreadsheet that I need to do a search for on part numbers, and
there may be multiple part numbers. If there are duplicate then I'll use
the Revison letter of the latest occurance. The cloum headers never
change, so i know that b2:b500 is a range for the part numbers that I need
to search, and e2:e500 is the range for the rev letter.

Can I use the find function, or the findall function, to return me a
range, or a count of numbers of cells that is equal to the part number I
need? If the count is 1, I can just grab that row, if the count is
greater then one, then I need to look at the cell that contains the value
of the Rev letter used to determine the latest entry.

Whats the best approach here