Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Address & Match
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) Lets 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
use the result of match function as a part of row address | New Users to Excel | |||
Partial Address match in an array | Excel Discussion (Misc queries) | |||
Dynamic Range, Data Validation and Address, Match and Offset Funct | Excel Worksheet Functions | |||
long address list, name-address-city, listed vertically, how do y. | Excel Discussion (Misc queries) | |||
How do I import Office address book to Outlook Express address bo. | Excel Discussion (Misc queries) |