|
|
Active Cell Border Color by
Linda Oshkosh WI
I know this can be done, I just can remember how or seem to be able to find
it under help.
I would like the border around my active cell to be a different...
|
|
2 |
1,970 |
|
|
countblank with sumproduct? by
Rene
Hi,
SUMPRODUCT(--(S3:S44="A"),--(E3:M44100),--(E3:M44=200))/SUMPRODUCT(--(S3:S44="A"),--(E3:M44"")) doesn't work unless it is E3:E44
Looking to modify...
|
May 30th, 2010 02:21 AM
by Brad
|
1 |
786 |
|
|
copy and past cells found by SUMPRODUCT by
Tromal
I have colum A and B. I use SUMPRODUCT to calculate the sum of values in
column B with a criteria.
What I would like to do is copy the cells from column A...
|
|
1 |
924 |
|
|
Password to open excel file by
Suresh Lohar
How a password is set in excel sheet. When double click an excel file, first
of all
you see protected and a window appeared, asking for password to open...
|
|
2 |
817 |
|
|
|
|
6 |
919 |
|
|
CONVERT function for Excel 2003 by
Chandrahas
I was trying to format time in decimals to days:hours:mins format. While
using microsoft excel 2003 help, they said to use CONVERT funtion for the
same. But...
|
|
2 |
880 |
|
|
Help needed urgently by
AndyW
Hi,
Im trying to check that one row of data satifies a criteria, then if it does
it counts an entry in another column adjescent to it.
Example: -
Column A...
|
|
4 |
918 |
|
|
|
|
1 |
980 |
|
|
|
|
1 |
781 |
|
|
|
|
5 |
898 |
|
|
Yes - No Interactive Text Box by
DisMusBeDaPlaz[_2_]
Working in Excel, I am looking for help using interactive fill-in check
boxes.
I am creating a form.
Setting up a cell or a bunch of cells merged, or not...
|
May 31st, 2010 12:41 AM
by Normek
|
1 |
969 |
|
|
Linking Equations to Highlights by
Q
I am interested in linking a formula to the colour of the cell. Ie. positive
number would produce a green cell & negative cell would high light the cell
in...
|
|
2 |
921 |
|
|
|
|
4 |
917 |
|
|
|
May 31st, 2010 04:47 AM
by Max
|
6 |
1,403 |
|
|
|
|
1 |
842 |
|
|
|
May 31st, 2010 06:54 AM
by Max
|
2 |
1,004 |
|
|
|
|
7 |
1,296 |
|
|
Vlookup from different sheets by
Radhakant Panigrahi
hi,
I have the below data...like this i have huge data in different sheets(which
are named date wise) and i can not consolidate them in a single sheet as the...
|
|
2 |
1,168 |
|
|
Remove non-space spaces? by
msnyc07
I have a large spreadhsheet with data I've manually copied/pasted from
various sources including web pages.
As I am trying to do things like import to Mysql...
|
|
3 |
1,085 |
|
|
Count number of people by
burtlake
We will be hosting a large fund raiser. I need to know the number of people
attending. Here's my problem................
Some people come as couples, and...
|
|
4 |
997 |