|
|
Max only if the last month is hte highest by
Jim
Hello,
When referencing a row of data (say, A:K), I know I can =MAX for the highest
number on this row. What I would like is a formula that will return the...
|
February 4th, 2010 12:22 AM
by Jim
|
4 |
96 |
|
|
Linking blank cells by
--Viewpoint
I created a workbook for others to use. The first sheet in the Excel
workbook has general information that I linked to cells on other worksheets.
However,...
|
|
1 |
113 |
|
|
Formula to sum values extracted from string by
Paul Martin[_3_]
Hi all
I'll preface this by pointing out that I do NOT want to use text to
columns, nor a VBA solution. I'm looking for a formula alternative -
maybe an...
( 1 2)
|
|
10 |
267 |
|
|
|
|
2 |
120 |
|
|
If Question by
Kiwi
Hi everyone
Hope this isn't a silly question (as think I may have made it harder in my
head than it needs to be! given all the formulas I'm putting in are...
|
|
4 |
119 |
|
|
refer to whole column by
Ken
Hi!
How do I refer to a whole column by a number of a cell? For example, if a
number of a certain cell is 1, then the column will be A:A. If a number of a...
|
|
2 |
127 |
|
|
Sumif() help by
sjmdhd
I have two worksheet, and I want to do a Sumif() function in sheet 1 but the
data is in sheet 2, I had no problem using this function in excel 2003,
however;...
|
|
1 |
110 |
|
|
Does Excel file retain link to template? by
Sherlock
In Word a document based on a template retains a connection to that template.
Is that also true in Excel? Or does an Excel file based on a template stand...
|
|
1 |
100 |
|
|
|
|
1 |
124 |
|
|
Variance Calculations by
Jim
Hello,
Thanks in advance for the help. I have a worksheet that lists account names
in column A. In column B I have sales from January, column C is sales...
|
|
2 |
93 |
|
|
Changing Multipule Graph's Source Data by
TysonE
So I have 8 graphs on one tab that reference data on another. I
highlighted both tabs, click copy, and I was hoping the graph's source
data would move itself...
|
February 3rd, 2010 11:41 PM
by TysonE
|
0 |
171 |
|
|
|
|
3 |
148 |
|
|
How do I edit my chart in 2007?? by
Tia
I have been using Excel XP and I would enter my data, get my chart and paste
it into word. Then I would be able to edit the chart. Now, when I get it
into...
|
February 3rd, 2010 11:24 PM
by Tia
|
0 |
91 |
|
|
Tuesday by
JDay
I have a spreadsheet where i need to count the number of the letter "T" in a
row. One row in particular however, will default to "Tue" as though I am...
|
|
1 |
99 |
|
|
SUMIF with multiple columns in sum range by
Joe M.
I have an array that I need to sum multiple columns depending of the value in
Col D.
The ws containing the array is called 'data'. I must sum cols F,J,N,R,V,Z...
|
|
3 |
136 |
|
|
Searching by
Rich
Hi,
I posted a message yesterday...yet cannot find it this morning...it would be
really useful if I could simply search for "questions posted by me".
Simple...
|
February 3rd, 2010 10:47 PM
by John
|
2 |
199 |
|
|
Excel 2007 table formatting by
Cindy[_8_]
Hi -
I can't figure out why this is happening - but some of our Excel 2007
worksheets with Format table options applied --- the formatting gets messed
up...
|
|
0 |
103 |
|
|
Inserting date from formuls by
TechGuy
Hi all,
I have a data verification drop down created and I am trying to make the
date poplate in certain cells depending on my drop down choice. The main...
|
|
1 |
85 |
|
|
fraction into date by
pm_sam
hi all members...
I have excel 2007 and when I enter
a number like 6/33 it turns it into
Jun-33.
this number 6/33 is being copy from
one note 2007 and pasted...
|
|
3 |
102 |
|
|
Lost Arrow key navigation by
Julio
I used to be able to navigate from cell to cell in a worksheet using the up,
down, left, right arrow keys. I'm not sure how I changed it, but now when I
hit...
|
February 3rd, 2010 10:21 PM
by Mike H
|
1 |
160 |