|
|
Nested If Statements by
Dave
Hoping someone can help.
I have a sheet that has 12 months of data going across 12 columns. Each
column has a heading for each month i.e 1, 2 ,3 ... There...
|
|
7 |
206 |
|
|
worksheet set up by
LBarbaraFord
How do I determine the ticket price for an event? Do I set up the worksheet
like a budget? Is there a formula that I would use?
|
|
1 |
106 |
|
|
|
|
6 |
102 |
|
|
|
|
3 |
180 |
|
|
Excel by
PS
How do you center information on the spreadsheet?
How do you add a sheet to your document ( I have 3 sheets at bottom but need
additional ones)?
|
|
3 |
110 |
|
|
vlookup by
dnmusic
i need a formula that will look up a word then give me the numbers in a cell
next to that word. the formula i'm using (which isn't working right)...
|
May 7th, 2010 09:23 PM
by Max
|
1 |
91 |
|
|
|
May 7th, 2010 09:16 PM
by Max
|
3 |
130 |
|
|
What type of "lookup" by
Kat[_6_]
I have a spreadsheet with 5 tabs. Each sheet in the tab has 4 columns (A, B,
C, D) Sheet 1, Sheet 2, Sheet 3, Sheet 4 and Sheet 5.
Each sheet pertains to...
|
|
3 |
135 |
|
|
|
May 7th, 2010 09:12 PM
by Max
|
3 |
140 |
|
|
Insert Lines by
RENEE
I have a worksheet sent to me with over 700 names on it. I need to put 4
extra lines under each name. Is there a way to do this without having to...
|
May 7th, 2010 07:59 PM
by Billns
|
7 |
144 |
|
|
Select Month, get the dates by
Gaurav[_9_]
Hi,
I want to be able to select the month from the drop down list and once the
month is selected, I want the first date cell to change itself to the...
|
|
2 |
104 |
|
|
SUMIFS question by
Eric Garcia
I am trying to use sumifs to gather information if one of two tests
are true. I would like to be able to make a purchase apear as
executed if Employee 1...
|
|
3 |
91 |
|
|
Graphs in Excel 2007 by
1 of 1
I am new in Excel 2007. In Excel 97' there was an option or using special
graphs which allowed you to have dual Y-Axis. You could then graph both $ and
%...
|
|
2 |
118 |
|
|
|
|
2 |
120 |
|
|
time format by
818jaime
Can some one please tell me how to format time exported from Avaya IQ.
example time exported 00:01:23
I need to format to only read 1:23 in excel 2007.
Thank...
|
|
4 |
117 |
|
|
Two IFS by
Sue C
It's a logical test rather than a calculation. The example I gave didn't
make much sense, but the scenario is that there is a range of products, which
can...
|
May 7th, 2010 03:59 PM
by Sue C
|
0 |
121 |
|
|
Formula Help Needed . . by
J.Scargill[_2_]
Hi all,
Hope you are all well.
To boost staff morale at my work, I am trying to come up with a World Cup
2010 Predictions Competition.
I have 3 worksheets...
( 1 2)
|
|
11 |
216 |
|
|
|
|
2 |
151 |
|
|
Columns by
Marg
keep first columns showing as i scroll down the page?
|
|
1 |
118 |
|
|
Using SUM + INDEX in array formula by
Dave Ramage
I'm having problems getting an array formula like this to work:
=SUM(INDEX(Data_Table,Row_Index_List,Col_Index_List))
Basically, I have two columns of numbers...
|
|
5 |
133 |