|
|
Rounding numbers up or down by
Michelle
Is there a function (or other method) that we can use to round currency to the nearest 5 cents, ie $27.28 would round up to $27.30, and $30.01 would round to...
( 1 2 3)
|
April 8th, 2009 03:03 PM
by Jose
|
24 |
380 |
|
|
|
|
24 |
444 |
|
|
Formula vs. Constant by
rk0909
Is there a way using excel funtions (not UDF) to find if a cell contains a
formula vs. a number (constant).
I looked around the forum but did not find...
( 1 2 3)
|
January 14th, 2010 07:34 PM
by rk0909
|
24 |
391 |
|
|
Highlighting by
gwenturpin
:confused:
I am wanting to change the default highlighting when you hover over a
cell/row.
E.g. I will be working on a large list of contact details when...
( 1 2 3)
|
|
23 |
639 |
|
|
Simple Formula by
Canon
Excel 2009
I am looking for a formula that will do the following;
If cell A1 in workbook one = Brent, then cell B1 must equal the amount in
cell A1 of...
( 1 2 3)
|
|
23 |
591 |
|
|
File integrity checking? by
bogstick
I like to routinely check my documents against backups by comparing MD5
signatures.
However, I find this impossible with Excel files because the MD5 value...
( 1 2 3)
|
October 1st, 2009 06:32 PM
by Bob I
|
23 |
297 |
|
|
Find Last Saturday of the Year by
jlclyde
I am trying to find the last Saturday of the year with excel. There
are a few sites that I visited, but they specify weekdays and I want
saturday.
Thanks,
Jay
( 1 2 3)
|
March 18th, 2008 02:14 PM
by jlclyde
|
23 |
323 |
|
|
separating alpha numeric vlue by
Narasimha
Hi all,
how do separate alpha numeric value for example I have values like
ABC123,AB234
starts with alpha but the length may be 2 or 3 or 4. just I want alpha...
( 1 2 3)
|
|
23 |
206 |
|
|
How to trim a string to the last "." by
VCKW
I have 11,000 long text strings in Excel... I had used LEFT operation to
limit the strings to 500 charaters, now I need to trim the strings to the
last...
( 1 2 3)
|
|
23 |
140 |
|
|
Linking to Password Protect Workbooks by
Paul Ferris
Hi Guys
I have a summary workbook, that links to several password protected
workbooks. Currently when I open the summary workbook, it prompts me for the...
( 1 2 3)
|
|
23 |
184 |
|
|
Calculating days in a month by
STFC
Hello,
Hope someone can help.
A1 = Start date B1=End Date eg A1 = 1st Jan B1=4th April
C1=Days in Jan D1=Days in Feb E1=Days in Mar etc until...
( 1 2 3)
|
|
23 |
237 |
|
|
Problem by
damanwitdaplan
I have a scoresheet I am trying to compile for someone. I ran it through like
it was a real time match and these are the results. This is what I have right...
( 1 2 3)
|
|
23 |
164 |
|
|
Macros to delete check boxes by
GWB Direct
I need to find a way to delete the check mark within a checkbox button so the
customer can clear chcked items. I tried a macro but it will not uncheck the
box....
( 1 2 3)
|
|
23 |
435 |
|
|
Index Match Vlookup? by
IntricateFool
How would I go about having a function return a single value from searching
several different columns and matching the proper "name" with its "county"?
Here...
( 1 2 3)
|
October 3rd, 2006 10:39 PM
by PapaDos
|
23 |
283 |
|
|
|
|
23 |
332 |
|
|
VlookUP Multiple tables by
joeldsmt
Hello,
I dont have a clue what to do and any assistance would be greatly
appreciated. Here is what i want to do:
I presently have a worksheet that has for...
( 1 2 3)
|
July 19th, 2006 02:46 AM
by Max
|
23 |
212 |
|
|
|
|
23 |
323 |
|
|
How do i do this? by
R.P.McMurphy
Im trying to set up a holiday accrual worksheet for my employees, so that i
can tell at a glance how much holiday they have left.
basicaly, employees acrue...
( 1 2 3)
|
|
23 |
209 |
|
|
|
|
23 |
599 |
|
|
Dates by
Ms. Beasley
I'm trying to do a worksheet that will autotmatically enter "today's date" in
a field but will not update when the spreadsheet is opened tomorrow. Can...
( 1 2 3)
|
|
23 |
232 |