Type: Posts; User: kweaver; Keyword(s):
(I don't have any files to upload as an example, but probably can get one).
Someone I met at a meeting said the following -- so, was wondering if someone has been through this exercise and has a...
I saw this problem which was supposed to be simplified so that there were NO NEGATIVE EXPONENTS and NO FRACTIONAL EXPONENTS IN THE DENOMINATOR.
I'm not sure that's possible, but I'm still...
Thanks, Maudibe...I guess there's not formula equivalent to the UDF, so that's my only option?!?!
Scott: Thanks; I know about HYPERLINK but in this case the cell isn't an email address nor a web...
I have copied cells using INDIRECT(formula) and only the text appears in the target cell.
The original cells are hyperlinked to URLs. I'd like the new cell to have the original text AND also be...
Unless I'm missing something (again), I think my original approach provided different colors for today's date for max and min.
For the max, I think this might work as the conditional format for all rows in the range:
I did this for the MIN:
He had lung cancer.
One of the best routines was Belushi doing Cocker WITH Cocker doing himself. A classic.
Thanks, dg1261. I pointed out to the client that what they were trying to accomplish was probably not legit, as you pointed out.
What they're planning to do is reduce the employee compensation by...
I'm drawing a blank on the math I need for this.
Normally in the U.S., FICA is shared equally between the employee and employer.
I have a situation where the real compensation is, say, $30,000. ...
AFAIK, the MAC doesn't support VBA. Although you might get it to work if you open Word in the Windows version on the MAC
I use Acrobat Pro and there's a feature in that version that allows you to do this. I don't know of a "free" product that would combine the two.
If it's a one-off thing and you'd like me to do it...
With the PDF open, try CTRL+D to display the document properties which will include the page size.
RG: I hope you realized I was kidding about the paid by the hour comment.
Maybe someone that doesn't post here might use Concatenate if they're being paid by the hour. More to type.
I also find it interesting the MS called it Concatenate rather than Catenate. Both...
With the "names" in column A, I put a 1 in B1, then this formula in B2 and filled it down.
I'm curious about xlsb format, Zeddy. Is anything lost in the Excel file if saved this way? All formulas are OK, conditional formatting, etc., etc.? Why would one NOT want to save all Excel files...
Not exchange based; names are typed, not clicked on from an address book.
Installed 2010 and still having the same problem. GROAN.
I'll look into this, but it's odd that if the address is in the TO line, it's OK, but if the same address is in the CC line -- frozen.
Webmail is no problem. But the customer prefers Outlook (it's what he's used to).
Seems to happen regardless of the email addressee in the CC.
This seems to be a nagging situation as I've found numerous references when searching the net.
I cannot find a good solution however.
Client runs Outlook 2007. Sending and receiving mail works...
There's no macro...just formulas. Go to the last bordered row (I think it was 11) and fill the cells from H to M down as you need them. Per the attached.
Just attached another.