|
miscalculation in excel
adding 989.89 to 165.2
cells G23 H23
=G23+H23 in spreadsheet
answer should be 1155.09 calculation given is 1155.04
...
|
4 |
30.09.2006 20:54:11 |
|
|
Named ranges with dependencies
I've started converting some charts I have whose data gets
updated very frequently so that the charts update their
data ranges automatically. For example, there is a
method outlined here:
http://www.j-walk.com/ss/excel/usertips/tip053.htm
That uses the "Name" feature (Insert / Name / Define)
to set up ranges that rely on COUNTA to see how long
the range is. Cool.
I'm interested in ...
|
1 |
30.09.2006 20:52:42 |
|
|
time sheet question
I have a time sheet form that calculates regular time,over time and holiday
time. I can't seem to get the formulas correct.
Would anyone look at it and give me some advice?
It is only 17K
I tried to copy it to this message but it was very confusing
oldjay...
|
3 |
30.09.2006 20:28:02 |
|
|
Date format
I have list of Date and time in the column,
but I need Date only , not date and time,
I was try to use format sell , but it just hiding time but not deleting it.
Is any way I can separate date and time and delete time in 1 shot ?
LastActionDate
1/2/2006 9:09
1/2/2006 9:22
1/2/2006 9:33
1/2/2006 9:35
1/2/2006 9:35
1/3/2006 10:22
1/5/2006 11:01
------------------
KSA
...
|
6 |
30.09.2006 20:23:01 |
|
|
Macros or the Fastest way to Autofill Rows
I need a macros to autofill rows. I am working on one now but have a few
problems. I have one spreadsheet that has a row for each employee for each
payperiod. It has the employee name, check number, date, hours worked,
vacation sick, pay etc, earnings. The hours worked may be in 3 column
depending on if it is regular pay, overtime 1 pay, overtime 2 pay, and
commission - (which is an...
|
2 |
30.09.2006 20:04:36 |
|
|
Microsoft office pic manager wont open my pics,only checkmarks...
I cant have my pics opened by MOPM, instead a lot of red checkmarks framed by
a box appears...
|
2 |
30.09.2006 19:56:19 |
|
|
Named ranges interfere with simple formulas
I am my own worst enemy. I created a macro that utilizes named ranges when
it creates spreadsheets. If my users want to create their own formula and
inadvertently use my named range, the results are incorrect.
A simple formula they'd put in such as =d3/c3, becomes =d3/RoysNamedRange.
of course, when they copy this formula down a column, =d4/RoysNamedRange is
not a relative reference ...
|
2 |
30.09.2006 19:48:14 |
|
|
Breaking Links
Hi,
I was wondering if there is a way to break links in Excel such that it
does not retain the data that is currently in that cell. What I am
trying to do is set up a summary sheet that links multiple different
workbooks (around 20 or so), however I want the associated linked data
to become "NA" or someother irrelevant value if I delete 1 of the
workbooks. In otherwords instead of breaki...
|
1 |
30.09.2006 19:37:42 |
|
|
how do i maintain same figure with formula link to another file
if i create a formula linked to another file and i need to save this to
another folder and deleting the original source where i link the file is
there a way that i can maintain the same figure and won't affect it
eventhough the file that link originally was gone?...
|
2 |
30.09.2006 19:15:02 |
|
|
Filters and totals
I have a sheet with data that includes totals in the bottom row.
I would like to be able to invoke automatic filtering such that
the totals change dynamically to cover only the visible rows.
I can't figure out any reasonably easy ways to do this. Folks?
A second question: how can I create filters that include my Totals
row without having to go in manually each time and change something?
E...
|
15 |
30.09.2006 18:57:16 |
|
|
Splitting Numbers Into Different Columns
Hi
I have a small problem which I can partly solve but not fully. The scenario
is following:
I have columns formated as number with 2 decimal places however I need to
split these columns into whole number and decimal number but I need the
whole number to be 4 digits in length. Example
New Columns
Original Col Whole Num Decimal N...
|
4 |
30.09.2006 18:57:01 |
|
|
"The Title of a Song" to "Title of a Song, The" possible?
I'm creating a spreadsheet of my music collection and am having trouble with
the way things are sorting.
1. Data was entered as: "The Allman Brothers Band" through importing data
from another source.
2. I would prefer it to be sorted as "Allman Brothers Band, The" instead.
Is there a way to format the text (not each entry and not through the
replace functions) to display and sort in the...
|
5 |
30.09.2006 18:33:57 |
|
|
Microsoft Excel
How do I do the IF function formula for calculating the shipping cost for an
order
If the standard shipping cost is $8.95 and express is $14.95...
|
2 |
30.09.2006 17:46:02 |
|
|
Microsoft Excel
How do I do the IF function formula for calculating the shipping cost for an
order
If the standard shipping cost is $8.95 and express is $14.95...
|
2 |
30.09.2006 17:21:06 |
|
|
Round up Formula Help
If cell E1 has, lets say $1.75 in it. Is there a way to leave E1 as it is
$1.75, BUT round it up to the nearest dollar and put the difference only .25
in cell F1....
|
3 |
30.09.2006 17:20:01 |
|
|
can you have excel automatically save in 2 locations
I need to make a backup onto a server for every file I save. Is there a way
I can have excel save 2 copies - one where I have access, and one in the
backup file in my server?...
|
7 |
30.09.2006 16:49:01 |
|
|
Problem trying to generate a report with a formula
Hi all,
I'm trying to generate a report and am having trouble with the formula.
Any help would be greatly appreciated.
Here is what I need to be able to do.
I have 6 worksheets in the same workbook, worksheets 1 - 5 are
identically laid out and the sixth is the one I want to generate a
report on. Column A is for peoples names, Columns B-H are labelled
Monday - Sunday on top. If ...
|
1 |
30.09.2006 16:45:27 |
|
|
Excel error "Cannot shift objects off sheet", can I fix?
When I use Excel, and change column width, I get error message of "Can not
shift objects off sheet"
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web...
|
2 |
30.09.2006 16:27:40 |
|
|
How to show date printed, updated only when worksheet printed?
I have a timesheet spreadsheet with worksheets for each day. I want the date
that a specific worksheet (e.g., Tuesday) is printed and don't want that date
to change on the worksheet until/unless that specific worksheet is printed
again. Each worksheet could/should have a different print date. Using
header/footer shows the date it is printed, but changes each day. Is there a
way to do ...
|
3 |
30.09.2006 15:55:41 |
|
|
Always enter number as a decimal <1
I want to be able to enter an integer into a cell and have it
automatically displayed and perceived by excel as a decimal less than
1.
In other words, if I enter "456" into the cell, I want it to display as
".456" all the time. I would further like this formatting to apply to
any number entered in that cell, regardless of how many sig figs there
are, AND I only want it to apply to one cel...
|
12 |
30.09.2006 15:53:28 |
|
|
Link Word form to Excel source file
I have 2 Excel and 3 Word files that have nearly the same
information. Each file is a 20+ page insurance application type
form. I would like to enter information into one excel file
(source) and then have everything linked to the appropriate data
within that file. The file i would like to use as the source has
VBA and i will not be able to use VBA in that case. The other files
can ...
|
1 |
30.09.2006 15:39:19 |
|
|
count number of appearences in cell
Hi all,
A certain character or group of characters appears a number of times in the
content of a cell (3a appears two times in d763ah555#3abds3j. With what
formula or code can I count that number? I think I knew it once, but I can't
remember.
Jack Sons
The Netherlands
...
|
9 |
30.09.2006 15:31:52 |
|
|
Set message subject here ...
--
--------------------------------- --- -- -
Posted with NewsLeecher v3.8 Beta 3
Web @ http://www.newsleecher.com/?usenet
------------------- ----- ---- -- -
...
|
1 |
30.09.2006 15:23:24 |
|
|
Very annoying prob with the Office / Excel "Beta 2 Technical Refre
I had been running the Beta 2 of Office no problem. When I installed the
Technical Refresh, I now have a problem where Excel will not open any Excel
files. Each time I get a dialogue box indicating that Excel can't open the
doc b/c my virus software is not up-to-date or b/c there is a virus. There
isn't - and I've checked and updated my AV software. Excel will open NO
other Excel fil...
|
1 |
30.09.2006 15:17:02 |
|
|
Formatting Decimal points
I want to do a custom number format that will automatically mark off two
decimal places just like my adding machine does.
Ex: type 12345 entry becomes $123.45...
|
3 |
30.09.2006 15:15:01 |