Hi Claude,
Don't know if this fits the bill or not but, how about this entered if F:
=IF(A5="","",LEFT(A5,3))
Hope this helps
shalom
Auto
Knew it Was too good to be true.
I'm getting a Runtime Error 13 Error.
Private Sub Worksheet_Change(ByVal Target As Range)
' code provided by
'Chandoo.org(Hui)
If Target.Address = "$D$9" And Target.Value = "HSR Health Safety & Regulatory" Then...
Thanks Hui!
That's pretty much what I did.
I'm now trying an "option" form control button but, I can't hide the buttons when the conditions are negative. Any thoughts?
Failing anything else I'll stick with the first option.
Thanks again!
Auto
Hi Folks!
I have a drop down list with four choices. If one particular choice is made then I would like a pop-up (or some other option)to ask a yes/no question which requires a response. Is this possible using data validation or conditional formatting or a combination of both? I'm even prepared...
First off Hi Folks!
Now, not your normal Excel question I know.
Does anyone know of a formula to convert microwave output wattage cooking times?
e.g. from 700w to 900w
There are a ton of sites offering tables and such but I'm looking for a universal formula.
Any help appreciated.