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