|
|
Countifs anchoring formula when sorting by
rmclafferty1
My Countifs seems to work as long as I do not sort.
For example, I want to sort by date rather than name:
• Bob Smith that was on line 12 is now is on...
|
|
1 |
252 |
|
|
|
|
0 |
207 |
|
|
Conditional Formatting in 2007 by
Live Long & Prosper
Playing with Excel I'm trying to conditionally format cells that divided
evenly in a range, heres a simple example :)
In cell A1 I put '=50000000/row()' I...
|
|
4 |
301 |
|
|
|
|
1 |
197 |
|
|
Splitting cell contents into 2 cells by
Florence Tay
If a cell contains a set of numbers separated by a hyphen (eg, 1234-5678, can
the contents be splitted up into 2 cells without the hyphen (ie, 1234 in 1
cell...
|
|
1 |
207 |
|
|
|
May 17th, 2010 01:28 PM
by JohnH
|
0 |
199 |
|
|
Drop down boxes by
themase
Hello
i have a column of 'names' which i have used a dropdown list to produce i.e.
date name(drop downlist)
01/01/2009 ...
|
|
1 |
195 |
|
|
Divide by 0 Help by
joey_boy
=(SUM(E98:F98)+D98/2)/(I98-G98)
Any suggestions on how I can rewrite this to return 0 if I get a Dicide by 0
Error in any of the calculations. I am a bit of...
|
|
4 |
205 |
|
|
Counting Checkmarks by
John Moore
Is there a way to count checkmarks ,, I have a sheet with lots of checkmarks
in columns, I want to be able to have a count of the number of checkmarks in
any...
|
|
1 |
209 |
|
|
Div 0 help by
joey_boy
=(SUM(E98:F98)+D98/2)/(I98-G98)
This formula gives me a Div 0 error. How can I re-write it so that it stores
a value of 0 , if it encounters a Divide by 0...
|
|
1 |
142 |
|
|
Invoices by
suewalton21
I have a worksheet for 37 addresses, showing various charges
I need to produce a single invoice for each address
Any help please
|
|
4 |
239 |
|
|
Three Variable Correlation by
Eileen
Hi.
I was wondering if it was possible to work out the correlation between three
variables in excel, not just two.
My data looks like this (this is just an...
|
May 17th, 2010 12:38 PM
by Eileen
|
0 |
132 |
|
|
Three Variable Correlation by
Eileen
Hi.
I was wondering if it was possible to work out the correlation between three
sets of variables in excel, and not just two.
The data looks like this...
|
May 17th, 2010 12:21 PM
by Eileen
|
0 |
127 |
|
|
Drop down box! by
themase
Hello
i have a drop down box which contains names of workers this has been used to
populate who works where in a spread sheet! what i need to do is edit the...
|
|
1 |
189 |
|
|
|
|
0 |
143 |
|
|
Convert text to number automatically by
Matt
I am trying to compare drawing revisions from 2 different sources but am
having difficulty due to the sources having either text or number formats.
Sheet 3...
|
May 17th, 2010 09:11 AM
by Matt
|
2 |
159 |
|
|
Filling adjacent formulas with data import by
Dave
Hi all,
XL2003
2nd posting - first on ended up in the ether...
I've tried importing a .txt file (from the Data menu) with the "Fill down
formulas in columns...
|
|
1 |
232 |
|
|
|
May 17th, 2010 08:30 AM
by 資訊函數
|
0 |
132 |
|
|
Import data, fill adjacent formulas by
Dave
Hi all,
XL2003
Using the Import data from the data menu, I have just discovered, and am
trying to use, the "Fill down formulas in columns adjacent to data"...
|
|
1 |
270 |
|
|
Sumproduct of multiple sheets by
Radhakant Panigrahi
Hi,
I am using the below sumproduct formula,
=Sumproduct((Sheet1!A1:A50000="Mark")*(Sheet1!A1:A50000="Automatic"))
I have 25 sheets and i have put the...
|
|
0 |
197 |