|
|
|
|
2 |
111 |
|
|
Averaging with IFs by
John
I am trying to average data if it matches a criteria and if its greater than 1.
A B C
Team 95 ...
|
February 4th, 2010 06:08 PM
by John
|
2 |
101 |
|
|
Cell =Now() Can I get this to auto-update? by
Paul Kraemer
Hi,
I am using Excel 2007. In one cell, I entered the following formula:
=Now()
After I typed in the formula and hit Enter, my cell displayed the current...
|
February 4th, 2010 05:55 PM
by Luke M
|
2 |
104 |
|
|
|
|
33 |
538 |
|
|
Extract the month name from a month by
Grd
Hi there,
I have a month column with just a number like 1 , 7 etc. I'd like to see Jan
instead of 1 and Jul instead of 7. Is there a formula for function for...
( 1 2)
|
|
11 |
210 |
|
|
Sorting in Custom Alphabetical Order by
Raj[_4_]
Hi,
I need to sort a list of names in a different alphatecal order eg.
D,C,A,B. The Custom sorting in Excel works if I make a custom list of
complete strings...
|
|
2 |
110 |
|
|
If Function by
Jen_T
I was wondering if it is possible to add to this formula, if all cell values
are blank than formula returns, blank.
Current Formula in...
|
|
1 |
109 |
|
|
Stoping Excel from Calculating? by
John
Can you stop excel from executing any formulas temporarily? Meaning while I
update info in the workbook nothing will calculate till I say go? Thanks
|
|
2 |
103 |
|
|
Deleting Duplicates by
Angie M.
I have a list of numbers in column A as follows:
133150
133150
133150
133154
133154
133154
133155
133156
|
February 4th, 2010 04:55 PM
by Iriemon
|
2 |
79 |
|
|
Combine Sumif and Countif by
John
I need to combine sumif and countif. I am trying to add up data in a an area
say D1:O256 if it matches a criteria. Thats easy. Sumif. Then I want to
divide...
|
February 4th, 2010 04:42 PM
by John
|
3 |
98 |
|
|
|
February 4th, 2010 04:41 PM
by Pluggie
|
2 |
81 |
|
|
Lookup by
Joe
The setup of the spreadsheet is as follows:
Column A: Item Number, Column B: Quantity, Column C: Price
I want to create a spreadsheet to lookup values in a...
|
February 4th, 2010 04:36 PM
by Joe
|
0 |
60 |
|
|
|
February 4th, 2010 04:26 PM
by Frode
|
7 |
82 |
|
|
percentages by
Mich
I need the formula to give me the percentage between 2 numbers - i.e.
increase or decrease of 20%.
Thanks.
|
|
2 |
64 |
|
|
Percentage format by
dpal
I have this workbook that was working fine. Now every new and old cell
changes everything to a percentage. Even if I make a new sheet in that
workbook.
ex....
|
February 4th, 2010 03:14 PM
by FSt1
|
1 |
91 |
|
|
|
February 4th, 2010 03:10 PM
by SV
|
7 |
80 |
|
|
|
February 4th, 2010 02:36 PM
by Eamon
|
3 |
74 |
|
|
How do i stop functions? by
2Lipps
i am using an excel sheet and there are numerals in a column. But they are
not to be added together at the bottom of the column. Unfortunately i'm
getting...
|
|
3 |
88 |
|
|
look up by
nader
hi
i have sheet1:
A B
benz 123
jeep 456
fiat 789
benz ...
|
|
2 |
95 |
|
|
Autofilter by
JPDS
I have a large spreadsheet (3000 rows) with staff data which contains details
of which directorate, department and team they work in. The spreadsheet feeds...
|
February 4th, 2010 09:35 AM
by JPDS
|
0 |
68 |