Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
if cell does not contain ".rb" then create hyperlink on cell
Hello
I am trying to create a formula using an if statement. I was thinking it should be something along the lines of...if cell does not contain ".rb" then create hyperlink on cell. (this is for a pivot table so a preferred sort is not possible for this report. So I am wanting to create a hyperlink next to the pivot table row showing the valid links only) thanks in advance. -M example data: 090309.rb <= "no link" 110209.rb <= "no link" formulatype.html < = Hyperlink(formulatype.html) frmrate.html <= Hyperlink(frmrate.html) -- Misty :-) Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200907/1 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
if cell does not contain ".rb" then create hyperlink on cell
Hello Misty,
if your data to check for hyperlinks starts in A6, for example, you can use the following formula: =IF(NOT(ISERR(FIND(".rb",A6))),"",HYPERLINK(A6)) then you have to drag the formula till the end of your data. -- (I'm not sure of names of menus, options and commands, because translating from the Italian version of Excel...) Hope I helped you. Thanks in advance for your feedback. Ciao Franz Verga from Italy (now in Berlin) Mitchell_Collen via OfficeKB.com wrote: Hello I am trying to create a formula using an if statement. I was thinking it should be something along the lines of...if cell does not contain ".rb" then create hyperlink on cell. (this is for a pivot table so a preferred sort is not possible for this report. So I am wanting to create a hyperlink next to the pivot table row showing the valid links only) thanks in advance. -M example data: 090309.rb <= "no link" 110209.rb <= "no link" formulatype.html < = Hyperlink(formulatype.html) frmrate.html <= Hyperlink(frmrate.html) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you have both a hyperlink and "regular" words in a cell? | Excel Discussion (Misc queries) | |||
=HYPERLINK("#"&CELL("address", ADDRESS(MATCH(VALUE(B3),QuoteNotes, | Excel Worksheet Functions | |||
=HYPERLINK("#"&CELL("address", ADDRESS(MATCH(VALUE(B3),Range ... ? | Excel Worksheet Functions | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Complex if test program possible? If "value" "value", paste "value" in another cell? | Excel Discussion (Misc queries) |