Thread
:
Address & Match
View Single Post
#
3
Posted to microsoft.public.excel.worksheet.functions
Sandy Mann
external usenet poster
Posts: 2,345
Address & Match
The range in MATCH() need to be in ascending order unless the third argument
is FALSE. try
{=COUNT(SEARCH($A7,'Import Sheet'!$A$1:$A$65000,FALSE))}
--
HTH
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
Replace @mailinator.com with @tiscali.co.uk
"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
Reply With Quote
Sandy Mann
View Public Profile
Find all posts by Sandy Mann