Address & Match
You can try this array formula** but it'll be slow.
Assume you have this formula in cell D1:
{=COUNT(SEARCH($A7,'Import Sheet'!$A$1:$A$65000))}
Enter this array formula** in E1 and copy down until you get blanks:
=IF(ROWS(E$1:E1)<=D$1,"A"&SMALL(IF(ISNUMBER(SEARCH (A$7,'Import
Sheet'!A$1:A$65000)),ROW('Import Sheet'!A$1:A$65000)),ROWS(E$1:E1)),"")
** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)
--
Biff
Microsoft Excel MVP
"ryguy7272" wrote in message
...
I used the following simple function to get the number of items found in a
list that is imported from the web:
{=COUNT(SEARCH($A7,'Import Sheet'!$A$1:$A$65000))}
CSE-entered (thanks Max and Harlan)
Let's say there were 30 items found in the entire list. Is there a simple
way to get the cell address that corresponds to each item found? Does
this
require a macro?
I am using the following now:
=ADDRESS(MATCH(A1,'Import Sheet'!$A$1:$A$65000),1)
This, however, is not the correct address! Another pair of eyes on this
would be great! What am I missing?
Thanks,
Ryan---
--
RyGuy
|