Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
match vs find question
right now i'm using find to search a row of values for an item, if it find it, i
use the rngfound row to enter some data below. if it doesn't find it, it adds an item to the range. i could use application.match to return the position, too, so i'm just wondering if one way is preferred over the other. -- Gary |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
match vs find question
I would guess that Find is aesthetically better, as it is not Excel
dependent, and has more flexibility in the search pattern and then looking for next. Match scores if you want to do a nearest value find. Horses for courses I guess. I tend to use Application.Match in responses I give, but I actually use Find more in my own code. I have no idea if one is faster ( I would guess Find), never had the need to time it. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Gary Keramidas" <GKeramidasATmsn.com wrote in message ... right now i'm using find to search a row of values for an item, if it find it, i use the rngfound row to enter some data below. if it doesn't find it, it adds an item to the range. i could use application.match to return the position, too, so i'm just wondering if one way is preferred over the other. -- Gary |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
match vs find question
thanks for the response, bob.
-- Gary "Bob Phillips" wrote in message ... I would guess that Find is aesthetically better, as it is not Excel dependent, and has more flexibility in the search pattern and then looking for next. Match scores if you want to do a nearest value find. Horses for courses I guess. I tend to use Application.Match in responses I give, but I actually use Find more in my own code. I have no idea if one is faster ( I would guess Find), never had the need to time it. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Gary Keramidas" <GKeramidasATmsn.com wrote in message ... right now i'm using find to search a row of values for an item, if it find it, i use the rngfound row to enter some data below. if it doesn't find it, it adds an item to the range. i could use application.match to return the position, too, so i'm just wondering if one way is preferred over the other. -- Gary |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
match vs find question
Another point I forgot to mention Gary is that Application.Match is useful
in testing if a value exists in an array. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Gary Keramidas" <GKeramidasATmsn.com wrote in message ... thanks for the response, bob. -- Gary "Bob Phillips" wrote in message ... I would guess that Find is aesthetically better, as it is not Excel dependent, and has more flexibility in the search pattern and then looking for next. Match scores if you want to do a nearest value find. Horses for courses I guess. I tend to use Application.Match in responses I give, but I actually use Find more in my own code. I have no idea if one is faster ( I would guess Find), never had the need to time it. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Gary Keramidas" <GKeramidasATmsn.com wrote in message ... right now i'm using find to search a row of values for an item, if it find it, i use the rngfound row to enter some data below. if it doesn't find it, it adds an item to the range. i could use application.match to return the position, too, so i'm just wondering if one way is preferred over the other. -- Gary |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
match vs find question
ok, appreciate the follow up
-- Gary "Bob Phillips" wrote in message ... Another point I forgot to mention Gary is that Application.Match is useful in testing if a value exists in an array. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Gary Keramidas" <GKeramidasATmsn.com wrote in message ... thanks for the response, bob. -- Gary "Bob Phillips" wrote in message ... I would guess that Find is aesthetically better, as it is not Excel dependent, and has more flexibility in the search pattern and then looking for next. Match scores if you want to do a nearest value find. Horses for courses I guess. I tend to use Application.Match in responses I give, but I actually use Find more in my own code. I have no idea if one is faster ( I would guess Find), never had the need to time it. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Gary Keramidas" <GKeramidasATmsn.com wrote in message ... right now i'm using find to search a row of values for an item, if it find it, i use the rngfound row to enter some data below. if it doesn't find it, it adds an item to the range. i could use application.match to return the position, too, so i'm just wondering if one way is preferred over the other. -- Gary |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
find the second match using the match function | Excel Worksheet Functions | |||
Find an exact match and go to that match | Excel Discussion (Misc queries) | |||
Find partial match from column A,B and fill partial match in C? | Excel Discussion (Misc queries) | |||
Find Exact Match using INDEX, MATCH | Excel Worksheet Functions | |||
newbie pivot table question (using match to find a value) | Excel Discussion (Misc queries) |