|
|
Tool bar functions greyed out! by
LINDA
I need to unmerge and merge cells within my spreadsheet
and the tool button for merging/unmerging is greyed out
and I cannot select it.....why? How do I...
|
November 13th, 2003 09:14 AM
by Paul
|
1 |
248 |
|
|
COUNT DATA by
Mark
Hi,
I have problem with count all item1(column B) with value 1
(column A) and give result in cell "C1"
How describe function without any filter.
A B
1 ...
|
November 13th, 2003 09:26 AM
by Mark
|
2 |
125 |
|
|
Exporting multiple worksheets to one .CSV by
Alan Cocks
Ben
I would combine all 5 worksheets into a sixth worksheet, and then save this
sheet as a csv file. I if you do have problems you can always open the...
|
|
1 |
629 |
|
|
show repeated item automatically by
toby
if i hv a file with the following data
A B C D E
no# name xx time others
... .. .. .. ..
As i keep on entering the data into different...
|
|
1 |
269 |
|
|
|
November 13th, 2003 12:15 PM
by Valeria
|
2 |
527 |
|
|
Is there a Subtract If function by
Eric
I'm trying to create a formula that will subtract two
cells if the second cell is greater than zero. I can't
find this anywhere and can't imagine Microsoft...
|
November 13th, 2003 12:32 PM
by Alan
|
2 |
233 |
|
|
Chart question by
Jesse
I need to set a data range for a chart to:
=INDIRECT(Data!$F$25)
The value of the cell F25 in sheet 'Data' is - D6:D17
My bar chart give me an error when I...
|
November 13th, 2003 01:14 PM
by Jesse
|
2 |
148 |
|
|
remove blank cells from list ? by
Morgan
Hello,
On Sheet1, I have a matrix of data (D4:R23, with many cells blank) that
is updated by users, and that I’m gradually reformatting into...
|
November 13th, 2003 01:20 PM
by Morgan
|
0 |
476 |
|
|
Round values to 0.05 or 0.00 by
Richard Hope
On an Excel spreadsheet, I'm looking to convert prices (or=20
numbers with 2 decimal places) to the nearest .00 or .05 -=20
for example =A31.42 would round...
|
|
3 |
196 |
|
|
HELP HELP - COUNT IF A SPECIFIC MONTH by
DMECONI
All I want to do is count a cell if the date (*/*/*)is of
a specific month. In other words if the cell
has "1/5/2003" in it, and I want to count that cell...
|
|
4 |
427 |
|
|
Macro to change text color by
Erin
Is there a way to create a macro that will change the
color of the text? For example, all numbers in a grid that
are 120 and over I need to be green, and all...
|
November 13th, 2003 02:29 PM
by Erin
|
2 |
244 |
|
|
|
|
2 |
224 |
|
|
convert column number to letter(s) by
Scott
how can I convert a column number into its corresponding aphabetic letter or letters? For example cell A1 contains the number 5, I want a formula in cell B1...
|
|
1 |
378 |
|
|
|
November 13th, 2003 05:38 PM
by Alan
|
4 |
247 |
|
|
Look up by
Jill
Hi,
I want to bring back data from a number of sheets in an
excel file into a one pager summary sheet.
For example in cell 1A I have a name that has...
|
|
2 |
123 |
|
|
quick formula question.... by
Dan B
I need to test the value of three cells individually in one formula. If any
one of them exceed a certain amount, I need a calulation made. Here is my
formula...
|
November 13th, 2003 06:24 PM
by Kathy
|
6 |
314 |
|
|
Vlookup help please! by
Andy Wiggins
Have you looked in the Excel Help file (press F1)? It has some very good
examples that should help you. How? Reconstruct an example, from the Help
file, in...
( 1 2)
|
|
10 |
278 |
|
|
How to code an event to call a macro? by
kris
How can I program an event, such as a double click on a
particular cell in a worksheet to excute VBA code.
Different cells in that worksheet would trigger...
|
November 13th, 2003 06:47 PM
by Kathy
|
2 |
304 |
|
|
Sendmail in Excel by
ukmalcolm
Hi,
My problem is a s follows.
I have a form on which a user will enter information into
a cell and then an email address into another cell. The
theory is...
|
|
1 |
97 |
|
|
LOOKUP to various different worksheets by
David
Hi,
I am having a abit of problem with vlookup linking to various
different worksheets within a different workbook.
I have 2 workbooks, lets say workbook A...
|
|
2 |
296 |