|
|
Highest Values Comparison by
Darren
I have a list of 20 names all with 24 separate attributes. Using the max()
function, I can get the highest value for each attribute. With the highest...
|
April 15th, 2009 12:41 PM
by Mike H
|
4 |
69 |
|
|
Excel virus? by
NZuser
Hello,
I work with a s/sheet that a few other users have access to, every now and
then really old data seems to come back into the s/sheet - data that had...
|
April 15th, 2009 11:13 AM
by NZuser
|
8 |
178 |
|
|
|
|
1 |
85 |
|
|
|
|
1 |
101 |
|
|
Count functions by
Jalal
Hi,
I would like to count the number of records which have a certain value in
one column and a certain value in a different column.
E.g. Each record in...
|
April 15th, 2009 08:51 AM
by Jalal
|
4 |
120 |
|
|
Repeat Cell Based on the Value-Excel 2003 by
Elaine
Hello,
I want to repeat a formula based on the value in another cell.
Example:
Formula/Result located in Cell B8
Value 5 located in Cell A2
How do I repeat...
|
April 15th, 2009 08:41 AM
by Stefi
|
3 |
112 |
|
|
|
|
2 |
223 |
|
|
|
April 15th, 2009 06:11 AM
by Bernd P
|
4 |
139 |
|
|
Symbols by
Crissy
I am trying to put in a cell "30Û« ~35Û« " but when I do it switches the 35Û« to
53Û«. I have tried the cell format on "general" and "text" as well as the...
|
|
8 |
162 |
|
|
Vlookup by
Networking Issues Error 0X80070005
How do you use vlookup when you have several items you want to look up and
return a total value. In this example I want to add all 3 items for a total
of 15....
|
|
6 |
104 |
|
|
|
|
1 |
95 |
|
|
Data Conversion - times, dates & rows by
Sara
Hi there,
I have a huge spreadsheet that is downloaded out of another program every
week listing all staff and their rosters for the week.
The dates and...
|
April 15th, 2009 03:44 AM
by joel
|
5 |
107 |
|
|
percentage formula by
David Wilson[_2_]
can someone give me a formula to dicount by percent.
Example:
A1 B1 C1
£50. -33% £33.50
...
|
|
3 |
95 |
|
|
SUM, AVERAGE and PRINT with #N/A cells by
PaulinaDi
Thanks Sheeloo and T. Valko but I still have questions about this issue. I'm
just copying my new questions on this new post to make it easier or you may...
( 1 2)
|
|
11 |
235 |
|
|
|
|
2 |
108 |
|
|
Screen Size by
[email protected]
Is there a way of having the cells you want to see (Width) fit
whatever screen it is connected to?
ie: I have a spreadsheet which has many columns but I only...
|
April 15th, 2009 01:53 AM
by Dave
|
2 |
106 |
|
|
|
|
3 |
119 |
|
|
|
|
3 |
126 |
|
|
|
|
4 |
119 |
|
|
IF Statement - compare to coloured cell by
LinLin
Hi Everyone
I'm not sure how to write an IF statement.
If Cell A1 is shaded RED, I want cell B1 to to say OK
If A1 is not red, then no message.
The IF...
|
April 14th, 2009 11:43 PM
by LinLin
|
7 |
113 |