|
|
MROUND by
emz486
Hope someone can help but whenever I use the MROUND function the answer is
always (#NAME?). Does this even when I copy the example from the help menu.
Anyone...
|
|
3 |
74 |
|
|
Comparing 3 Columns by
[email protected]
I've been searching for a while, but I am out of my league trying to
figure this one out on my own. I would like to compare three columns.
A B C
1 ...
|
|
2 |
143 |
|
|
concatenate won't work by
TracySLPS
I used a .txt file to import into excel. i have saved it as a .xlsx file and
now i need to concatenate columns p-t. all columns are text columns, i used
the...
|
|
6 |
95 |
|
|
Lookup table for rates? by
Wanda
Hi All! I'm still getting used to Excel2007 :-| Here's my question.
I'm trying to create a worksheet that will calculate interest on accounts on
a daily...
|
April 22nd, 2009 07:08 PM
by Wanda
|
4 |
91 |
|
|
|
|
6 |
93 |
|
|
simlple question by
Darius
In a cell F8 I have a number as for example: 3115
now in Cell M2 I want to say :
=J3115
Problem is this 3115 number may change, so how M2 value change the J...
|
|
3 |
80 |
|
|
cells selection by
Davey
When I use the curser to select a single cell, multiple cells are selected.
If I tab, the highlight stays within the selected cells. When I use the
arrow...
|
|
7 |
198 |
|
|
One text for particular period by
kashish
If A1 = Any date, I need a formula for A2 with conditions like
If A1 between 01 Jan 2009 to 31 Mar 2009 then A2 = Q1
If A1 between 01 Apr 2009 to 30 Jun 2009...
|
|
5 |
83 |
|
|
Automatically add and subtract by
BadBoy
Hello all,
I had such great success with my last question that I am going to attempt
one last question which will save me plenty of headaches if answered.
I...
|
April 22nd, 2009 05:52 PM
by BadBoy
|
3 |
73 |
|
|
average with N/A by
dernspiker
I have a spreadsheet with 9 worksheets (named by employee last name).
On the 9th worksheet I want to get the average of cells B4 from each of the
other...
|
|
3 |
72 |
|
|
"Validation" question by
Shannon
When validating a cell from a list, is it possible to create a formula tied
to that validation? For instance:
column A - each cell has a drop down option...
|
April 22nd, 2009 05:08 PM
by Eduardo
|
2 |
66 |
|
|
circular reference - iteration by
rock
I am building a forestry growth and harvest model that forecasts out twenty
years ahead. I need to be able to change assumptions such as beginning
volume...
|
April 22nd, 2009 04:50 PM
by rock
|
5 |
163 |
|
|
|
April 22nd, 2009 04:49 PM
by sabow71
|
4 |
112 |
|
|
Sumif query by
ArcticWolf
Hi,
I have a sheet of sales data (c1000 lines) and need to sum it all up into
areas.
My sales data is:
Area,Value,Include
1,10,Yes
2,9,Yes
3,8,No
|
|
4 |
86 |
|
|
Formula for selecting a Leap Year. by
BadBoy
Hello,
The first formula below checks to see if the word February is in one cell
and the year 2012 in another and if so, will place the number 29 in another...
|
|
9 |
80 |
|
|
Countifs by
Carl
Excel 2007: Trying to use Countifs
To simplify, in column B, over the range B2:B1250, I have the letters a,b,c,d
I need a count of "a", =countif(...
|
|
1 |
56 |
|
|
Concatenate Dates by
EllenM
Hello,
I need help to concatenate a date field. For example, I'd like one of them
to say "Posted 1/12/2007". Instead I'm getting "Posted 39094".
Thanks in...
|
April 22nd, 2009 04:14 PM
by EllenM
|
2 |
55 |
|
|
All my textbox disappear.. by
Hwee
Hi I am currently doing some work on excel 2003 and suddenly all my textbox
disappear. I can no longer use the textbox function. Please help. I have a
lot of...
|
|
1 |
64 |
|
|
change date format without retyping dates by
sarajane82
i am trying to fix a spreadsheet that a coworker made. it includes a formula
that subtracts one date from another. the problem is that the person put the...
|
|
3 |
85 |
|
|
Keep Leading Zeros in Concatenation by
EllenM
Hello,
I have a column of numbers that I've added leading zeros to make 6 digits.
I've done this using the a custom format of "000000". So 1 becomes 000001,...
|
April 22nd, 2009 03:47 PM
by EllenM
|
5 |
299 |