|
|
Add to Summed Figures by
acopper57 via OfficeKB.com
I am wondering how to add to a previously summed number. For example, I had
+ .4420+.0080+.0020-.0025 + .0075 - .0040 in a cell with a closing value of...
|
|
0 |
63 |
|
|
Add to Summed Figures by
acopper57 via OfficeKB.com
sorry ignore first part, see tables. Change example, forgot to delete
acopper57 wrote:
I am wondering how to add to a previously summed number. For...
|
|
0 |
85 |
|
|
Count number of occurances in column by
acorbally
Sorry, when I posted it, it made it look a bit different. It should be
the answer is four because there are four occurances of one in column
b.
---
Message...
|
|
4 |
517 |
|
|
Count number of occurances in column by
acorbally
I would like to know how to create a formula to count the number of
occurances of a specific item in a column. I want to count the
occurances of 1 from cell...
|
|
0 |
307 |
|
|
|
|
2 |
92 |
|
|
custom number format by
ACotton
I need the following number to look as follows:
Is: $ 1,075,245
Want: $ 1,075.2
Not all of the numbers are millions so I want the $ to line up to the...
|
November 15th, 2006 08:11 PM
by ACotton
|
3 |
60 |
|
|
solving for a sum by
acp20770
I have a group of numbers, some of which add up to a given sum. How can I
find out which numbers make up that sum?
|
|
1 |
129 |
|
|
|
|
2 |
103 |
|
|
|
|
2 |
53 |
|
|
Problems losing changes in shared workbook by
ACraig
Has anyone else had problems losing changes on a shared workbook? I have an
Excel 2003 workbook shared between multiple people and saved on a network. We
have...
|
November 16th, 2005 03:02 PM
by ACraig
|
0 |
185 |
|
|
combining worksheets into one sheet by
acremax
I have created a new workbook then started uploading data. The data then got
divided into 1,233 seperate sheets. I would like to combine all the data on
to...
|
|
1 |
89 |
|
|
|
|
7 |
74 |
|
|
Worksheets by
Acrumly
I have a file that I have to fill out for one of our buyers and it has two
sheets to it. Some of the information that I enter on one worksheet can also
be...
|
|
2 |
72 |
|
|
Prevent unhide sheet by
acss
I know how to hide a sheet but i do i prevent a user from performing the
unhide? Does it have to be done using VB or hiding a particular toolbar?
Thanks,
|
|
2 |
59 |
|
|
Simple Math by
acss
This is probably the most simplest question;;
I have an amount in e4 and i need that amount subtracted by 50 percent for
the results to be in f4.Can someone...
|
|
9 |
71 |
|
|
Vlookup question by
acss
New to excell and i would like to utilize vlookup to avoid repetitive steps.
I have the formula for a two column list =VLOOKUP(A9,A1:B7,2,FALSE) but not
sure...
|
|
7 |
52 |
|
|
Formula for Value by
acss
I am working on various cells that are repetitive. I have two countries which
have a total amount but need a percentage subtracted.
brazil total...
|
June 21st, 2008 09:02 PM
by Dave
|
4 |
75 |
|
|
Pivot Table missing data item by
acss
I have columns that list invoices ,invoice dates, accounts ,subtotals and
totals. When i try to drag the data item into the DROP DATA ITEMS HERE , it...
|
|
1 |
83 |
|
|
Automate Column Amts by
acss
I have column E and F which contains dollar amounts and users need to enter
same dollar amounts in both columns. For example column E is 100 and column F...
|
|
3 |
122 |
|
|
Copying links by
ACULAK
I have 2 excel files.
I would like to link multiple cell in file 1 to file 2
I am trying to get around from going to each cell & going back & forth from
file...
|
April 26th, 2006 03:18 AM
by Max
|
1 |
78 |