|
|
conting cells? by
alberto
Hi,
it´s possible, in excel 2003, using a function, conting the number of cells
in a collum that have text in black and text in red charaters.
ex: collum...
|
April 1st, 2007 07:40 PM
by alberto 
|
2 |
86 |
|
|
counting cells by text color by
alberto
Hi,
What formula can i use to get the total of cells by counting text with
diferent color?
ex:
NAMES
david
joe
richard
David and Richard are writen in black...
|
April 6th, 2007 11:54 PM
by alberto
|
6 |
166 |
|
|
|
counting cells? by
alberto
Hi,
it´s possible, in excel 2003, using a function, counting the number of cells
in a colum that have text in black and text in red charaters.
ex: colum...
|
April 4th, 2007 02:16 PM
by alberto
|
4 |
68 |
|
|
|
refresh advance filters by
Alberto Ast
How do I refresh advance filters without going manualy into the
data-filters-advance filters menu?
|
|
0 |
51 |
|
|
|
Advance Filter by
Alberto Ast[_2_]
How do I refresh my data once the filters are modify...? I have a table with
100+ rows and want to filter using advance filter... I want to use a
validation...
|
|
0 |
78 |
|
|
|
Moving one cell with macros by
Alberto Ast[_2_]
Using macros I want to move down one cell from where ever position I am..
have tried recording a macro but it always give the the specific cell I
moved... I...
|
|
4 |
87 |
|
|
|
Variable Links to tabsheets by
Alberto Pinto
Hi!
How can I make a link to another sheet be dependable on one cell value
(without ifs)?
I give you an example:
I have a worksheet with three sheets...
|
November 25th, 2005 07:12 PM
by Max
|
6 |
95 |
|
|
|
INDIRECT function by
Alberto Pinto
Hi!
is it possible to return this kind of string from the indirect function
(to use in a LOOKUP function):
'VARIABLE'!B$13:B$46
where VARIABLE is in the...
|
|
2 |
107 |
|
|
|
Count coloured cells in range by
Alberto Pinto
I would like to count how many coloured cells exists in a range:
for example 5 blue, 2 red, 3 yellow,...
Is there any function for this?
Thanks in advance
|
|
2 |
81 |
|
|
|
|
May 14th, 2010 04:26 PM
by Glyn
|
11 |
453 |
|
|
|
Scenario Manager by
Albie
I have a relationship developed between annual production volume and number
of operators required to meet daily production volume requirements. I want
to...
|
|
2 |
110 |
|
|
|
Now function by
Albie
I would like to use the now function to record the current system time with
seconds, but I do not want this function to update when I type another
instance...
|
September 14th, 2007 02:56 PM
by Albie
|
3 |
64 |
|
|
|
|
May 15th, 2007 07:54 PM
by Albie
|
3 |
84 |
|
|
|
Allowing sort of protected cells by
albie60
I have data within certain cells I want to protect but I also want to allow
sorting of those same cells. In other words, I want to allow users to sort
ALL...
|
|
1 |
94 |
|
|
|
Looking up multiple values by
Albuquerque Bill
Is there any way to lookup multiple answers to a lookup formula. Normally, Excel will stop at the first match it finds and return that as the answer when, in...
|
|
1 |
87 |
|
|
|
SUMPRODUCT problem by
Alby
Hi all
I have a workbook that I am using the sumproduct function:
Spreadsheet:...
|
February 6th, 2004 04:26 AM
by Alby
|
2 |
65 |
|
|
|
decimal places by
Alby
Hi all
I have a series of data that works on averages,:
The formula in C27 through C 54 is :
=IF(B27="","",AVERAGE(B11:O11))
However when the cell calculates...
|
February 19th, 2004 03:49 PM
by RagDyeR
|
2 |
310 |
|
|
|
IF ISNA VLOOKUP problem by
Alby
Hi all,
I have a postcode file A1: H16563
Column A = postcode
Column B = suburb
I also have a spreadsheet with either suburb names or postcodes. What I'm...
|
March 25th, 2004 12:41 PM
by Alby
|
3 |
319 |
|
|
|
|
|
1 |
242 |
|
|
|
IF Ranges by
Alby
I just posted a reply to show nothing if cells are blank:
IF B9 =5 C9=1 D9=2 E9=3 ...
|
January 14th, 2004 12:11 PM
by Alby
|
2 |
78 |
