|
|
Conditional Sum by
claude jerry
I have a Excel File Saved on this below Link
http://www.savefile.com/files/1923737
A B C D E F G
Name Type Sun ...
|
|
1 |
296 |
|
|
Median continued by
Bony Pony[_2_]
OK then. I'm going in circles on this.
I want to conditionally format the cell that contains the Median or closest
thereto.
I have a row of cells in...
( 1 2)
|
December 10th, 2008 07:53 AM
by T. Valko
|
12 |
209 |
|
|
COUNTIF by
Barry Lennox
I am having trouble with 'COUNTIF'. If I have the criteria as a single cell
reference all is well. If I enter "" or "" either alone or as a range I get
0...
|
|
2 |
114 |
|
|
Sumif based on two variable by
Memphus01
i am trying to get the sum of data from column S that meets criteria from
column b and d-
I have been able to get a count using the following...
|
December 10th, 2008 05:36 AM
by Max
|
4 |
160 |
|
|
|
|
0 |
114 |
|
|
|
December 10th, 2008 04:52 AM
by Max
|
7 |
189 |
|
|
Return First Line from a group of files by
willwonka[_2_]
I have a folder with about 150 text files. I would like a macro that
would return the first line of each of those files into a spreadsheet.
The files do...
|
|
3 |
123 |
|
|
|
|
5 |
112 |
|
|
|
December 10th, 2008 03:25 AM
by dhstein
|
2 |
102 |
|
|
Pivot table questions by
Francesco
2 questions:
1)I created a custom pivot table format, but I am unable to use it for other
documents than the one I created it into.
Any idea on how to do it?...
|
|
1 |
119 |
|
|
How to keep duplicate cells by
pwillissr
I have a file with over 11,000 ASINS on there a lot of which are duplicated.
I would like to know how to I extract those duplicate ones and keep those
only....
|
December 10th, 2008 02:42 AM
by JLatham
|
1 |
87 |
|
|
|
December 10th, 2008 02:40 AM
by Max
|
5 |
110 |
|
|
excel 2007 compatability mode by
joebrennan
how do I open a new spreadsheet that is not in compatability mode. I need to
import data that has more rows than the 65xxx allowed by earlier versions.
|
December 10th, 2008 02:27 AM
by JLatham
|
1 |
122 |
|
|
|
December 10th, 2008 01:25 AM
by Pete_UK
|
3 |
99 |
|
|
Hellp Me Excel Help!!!! pt 2 by
headbanging_Fe[_2_]
i done the previous problem and thank you to everyone.
i have to make a discount on if attendance is 5 days then they get 15% and
if the attendance is 4 days...
|
|
2 |
119 |
|
|
|
December 10th, 2008 01:15 AM
by bdmedlin
|
0 |
115 |
|
|
Lock specific cell by
Lisa
I cannot get the lock specific cell function below to work:
1. Select entire worksheet by clicking the Select All button
2. Click Cells on the format menu,...
|
|
1 |
113 |
|
|
Conditional Formatting A Whole Column by
varsityfresh
In my first column I have a list of supplies that are already in my
possesion. In subsequent columns I have listed other supplies that I need. Is
it possible...
|
December 10th, 2008 01:01 AM
by Sheeloo
|
1 |
109 |
|
|
|
December 10th, 2008 12:34 AM
by BDT
|
1 |
127 |
|
|
Updating worksheet by
sriddle
I have a spreadsheet that I use to enter information to print labels. The
worksheet is not saved, only printed. I need some of the information to...
|
|
1 |
83 |