Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Number vs Text
I have a string range1 insted of A1:C1, for instance.
My search cannot be completed because the formula is somehow unable to search for the string, it searchs for the the text "range1", which is really odd. How can link the search to the cell without the ("") in the cell? Thank you, -- FS |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Number vs Text
A string referring to a range in a FORMULA will not work. You need to
hightlight the range and name it in the name box (to the left of the formula box) or use insertnamedefinefill in the namein the refers to box type in the range reference. Then =sum(range1) In a macro myrange=range("a1:c1") for each c in myrange do something next -- Don Guillett SalesAid Software "felipe_mfds" wrote in message ... I have a string range1 insted of A1:C1, for instance. My search cannot be completed because the formula is somehow unable to search for the string, it searchs for the the text "range1", which is really odd. How can link the search to the cell without the ("") in the cell? Thank you, -- FS |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Number vs Text
I've already named it and I cannot use the function SUM because the formula
is related to a LOOKUP function. Example: LOOKUP(A1,B1) ; B1 = "range1" range1 = C1:F1 Get it?So I should probably used another function that doesn't change the ranges properties. The question is, which function? Tks -- FS "Don Guillett" wrote: A string referring to a range in a FORMULA will not work. You need to hightlight the range and name it in the name box (to the left of the formula box) or use insertnamedefinefill in the namein the refers to box type in the range reference. Then =sum(range1) In a macro myrange=range("a1:c1") for each c in myrange do something next -- Don Guillett SalesAid Software "felipe_mfds" wrote in message ... I have a string range1 insted of A1:C1, for instance. My search cannot be completed because the formula is somehow unable to search for the string, it searchs for the the text "range1", which is really odd. How can link the search to the cell without the ("") in the cell? Thank you, -- FS |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Number vs Text
Perfect!! I've a little rusty...
Ow, and sorry about that hehe... Thanks very much! -- FS "Don Guillett" wrote: GOT IT!!!!! Always nice to say what you mean the FIRST TIME. Get it?. Try this. =LOOKUP(a1,INDIRECT(b1)) -- Don Guillett SalesAid Software "felipe_mfds" wrote in message ... I've already named it and I cannot use the function SUM because the formula is related to a LOOKUP function. Example: LOOKUP(A1,B1) ; B1 = "range1" range1 = C1:F1 Get it?So I should probably used another function that doesn't change the ranges properties. The question is, which function? Tks -- FS "Don Guillett" wrote: A string referring to a range in a FORMULA will not work. You need to hightlight the range and name it in the name box (to the left of the formula box) or use insertnamedefinefill in the namein the refers to box type in the range reference. Then =sum(range1) In a macro myrange=range("a1:c1") for each c in myrange do something next -- Don Guillett SalesAid Software "felipe_mfds" wrote in message ... I have a string range1 insted of A1:C1, for instance. My search cannot be completed because the formula is somehow unable to search for the string, it searchs for the the text "range1", which is really odd. How can link the search to the cell without the ("") in the cell? Thank you, -- FS |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Number vs Text
Glad to help
-- Don Guillett SalesAid Software "felipe_mfds" wrote in message ... Perfect!! I've a little rusty... Ow, and sorry about that hehe... Thanks very much! -- FS "Don Guillett" wrote: GOT IT!!!!! Always nice to say what you mean the FIRST TIME. Get it?. Try this. =LOOKUP(a1,INDIRECT(b1)) -- Don Guillett SalesAid Software "felipe_mfds" wrote in message ... I've already named it and I cannot use the function SUM because the formula is related to a LOOKUP function. Example: LOOKUP(A1,B1) ; B1 = "range1" range1 = C1:F1 Get it?So I should probably used another function that doesn't change the ranges properties. The question is, which function? Tks -- FS "Don Guillett" wrote: A string referring to a range in a FORMULA will not work. You need to hightlight the range and name it in the name box (to the left of the formula box) or use insertnamedefinefill in the namein the refers to box type in the range reference. Then =sum(range1) In a macro myrange=range("a1:c1") for each c in myrange do something next -- Don Guillett SalesAid Software "felipe_mfds" wrote in message ... I have a string range1 insted of A1:C1, for instance. My search cannot be completed because the formula is somehow unable to search for the string, it searchs for the the text "range1", which is really odd. How can link the search to the cell without the ("") in the cell? Thank you, -- FS |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting a mixed text/number column based on text in another colum | Excel Discussion (Misc queries) | |||
how do I count the number of times text in column A matches text i | Excel Worksheet Functions | |||
convert text-format number to number in excel 2000%3f | Excel Discussion (Misc queries) | |||
Why does this fail? =TEXT(RC3,Number)&" / "&TEXT(R32C,Number) | Excel Worksheet Functions | |||
not able to convert text, or graphic number to regular number in e | Excel Worksheet Functions |