Returning Cell Refrences/range Refrences

K

ksnapp

I need a sub that searches a column and finds the first cell that say
"PORK", then it has to search fruther down and find the second instanc
of "PORK" and give some form of cell refrence/ range reference that
can plug into a furmula. (I can write that part, I hope). Then I nee
it to do the same thing for each successive instance of "PORK." Eac
time it says pork im gonna run different formulas in 3 or 4 cells t
the right using the range that the sub returns.

Is this possible
 
F

Frank Kabel

Hi
you may explain this with some more detail :)
- where do you want this result to be stored (as this could return
multiple values - on for each 'Pork')
- you may tell us in what kind of formula you want to use the results
- even better: Try Explaining what you're trying to achieve with some
sample data (plain text, no attachments please)
 
A

Alan Beban

If the functions in the freely downloadable file at
http://home.pacbell.net/beban are available to your workbook, and
assuming your data is in a range named "dataRange", the following, array
entered into a vertical range sufficiently large to accommodate the
occurrences of "PORK", will return a vertical column of the cell
addresses of all occurrences:

=ArrayMatch("PORK",dataRange,"A")

Alan Beban
 
Top