| 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 |
| 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) | |||
Threaded Mode
