|
|
Sum with 3 conditions by
diepvic
Hi,
I have a table as below
YTD YTD YTD
Name Jan Feb Mar Apr May
A 23 34 35 2 3
B ...
|
April 12th, 2010 05:16 AM
by diepvic
|
9 |
151 |
|
|
Find 2 highest point to form resistance line by
Elton Law[_2_]
Dear expert,
Have left a post for finding 2 lowest point for form a support line.
Now, would like to find 2 highest point to form a resistance line.
Data is...
|
|
4 |
247 |
|
|
Adding dates in columns by
Roy
Using 2003, I am entering dates and trying to utilize a formula to calculate
the number of cells that fall before a certain date.
"Today()-300", calculates...
|
|
2 |
224 |
|
|
|
|
1 |
114 |
|
|
Find 2 lowest point to form a trendline by
Elton Law[_2_]
Dear expert,
Cell AH67:AH77 contain a series of data.
Actaully, they are the results from an array of formula.
Sometimes, it has 12 data. Sometimes, the data...
|
|
0 |
141 |
|
|
date Concatenation by
gb_S49
Hi,
I am trying to date Concatenate 2 cells. One contains text the other date.
How can I get the date to display as a date?
=T6&" "&U6 returns ESTIMATE 40066
|
|
6 |
202 |
|
|
Pivot table field list missing by
Dianeg
I'm using 2007 and have created several pivot tables from this particular
database but now, suddenly when I create a pivot table from scratch, the
field list...
|
April 11th, 2010 12:13 PM
by Dianeg
|
5 |
224 |
|
|
Freeze Column by
ManhattanRebel
Other than the first column, is there a way to freeze other columns in my
excel spread sheet?
|
|
7 |
234 |
|
|
Delete 3 end row by
climate
Hi
I want to delete three end row of any sheet. any sheet has different row
number.
Thank's for any help.
your's
|
|
6 |
112 |
|
|
Unprotect problem by
DJohnM
How do I unprotect a worksheet in Excel 2007 when "unprotect sheet" is greyed
out? (I have matching problem with protecting.)
|
April 11th, 2010 09:42 AM
by DJohnM
|
2 |
124 |
|
|
|
|
5 |
605 |
|
|
Customize accounting format by
Rhett
I've been banging my head on my desk for two days over this problem!
I want to customize the accounting format to show 0 as: $ 0.00
(with a $ to...
|
|
3 |
151 |
|
|
separate text and number by
raju
dear sir
in Cell A1 is "rajulu1234". i want in cell B1 "rajulu" & cell C1 "1234".
please help me.
thanks advance.
raju
|
|
4 |
102 |
|
|
Summing based on dates by
Mike
I go running and have a mileage log. I have a list of non-continuous
dates in column A (i.e. I don't run every day), and mileage figures in
column B.
On a...
|
|
3 |
102 |
|
|
Countif using cell refences by
Gnealeuk
i would like to add a formula into my spreadsheet that counts if a date in a
previous cell appears, but the date is constantly being changed so therefore
i...
|
|
4 |
99 |
|
|
Summing based on dates by
ajnmxx
I go running and have a mileage log. I have a list of non-continuous
dates in column A (i.e. I don't run every day), and mileage figures
in
column B.
On a...
|
April 11th, 2010 02:08 AM
by JLatham
|
2 |
91 |
|
|
Searching based on text by
EJ Hill
I am building an Excel to recall stats for TV sports. There are three
workbooks, Home, Away and League. The league sheet has all of last season's
stats.
In...
|
|
7 |
131 |
|
|
Macro - onAction arguments by
version83[_2_]
Hello.
I have this code:
Private Sub Workbook_SheetBeforeRightClick(ByVal Sh As Object, ByVal
Target As Range, Cancel As...
|
|
2 |
98 |
|
|
Excel 2003 formula by
Ginger
I'm trying to make a formula for a list to check and strike out another on 3
sheets. Only 2 are using the info, sheet 3 has various colums to check.
Sheet...
|
|
6 |
118 |
|
|
Running total based upon current date by
ucastores
I have cells with dollar values from formulas and i am trying to place the
total of all those values in another cell based upon the current date
backwards. ...
|
|
5 |
95 |