|
|
Counting cells based on color by
djm
I am looking for a "counting" formula that will count cells in a range
based on their color, so that if I color a series of dates (to show
'vacation) the...
|
|
1 |
364 |
|
|
Comments by
felix
Is it possible to copy a value in a cell and add it as a
comment? How would such a macro look like? Preferably the
comment box should be resized to just reveal...
|
|
4 |
208 |
|
|
|
August 4th, 2004 02:43 PM
by Dave O
|
2 |
316 |
|
|
Automatic removal of rows by
Peter
/ Hi,
If I have worksheet where I want to delete all the rows that have (say) 0 in column C is there an automatic / formula way to do it. I've tried filter and...
|
|
1 |
191 |
|
|
|
August 4th, 2004 01:38 PM
by BBLB
|
2 |
399 |
|
|
lookup in vba by
nyn04
I am trying to write a vba code that accomplished the following excel
code,
can anyone help
=IF(ISNA(VLOOKUP(...)),"",VLOOKUP(...))
I have wrriten the...
|
August 4th, 2004 01:27 PM
by nyn04
|
2 |
204 |
|
|
|
|
2 |
157 |
|
|
|
August 4th, 2004 10:59 AM
by Jazzer
|
1 |
415 |
|
|
|
|
3 |
457 |
|
|
create dynamic range for chart by
Aja
Hello,
I want to export data from Excel, perform some calculations on it, and then link the data to an Excel chart. Although the exported data has a named...
|
|
2 |
368 |
|
|
convert cell content to html automatically by
Prometheus
I am managing in excel a flat database of over 1000 names, committees, etc., where email addresses are found using vlookup function. How do I convert these...
|
|
3 |
364 |
|
|
Inclusive number of days and running total by
Chris
Hi,
I have a column of start dates (B) and a column of end dates (C).
I would like to have the inclusive total of days.
I would then like to have a running...
|
|
6 |
391 |
|
|
SAVING EXCEL FILE AS .CSV by
Dwayne
I'm trying to save an excel file in .csv format with
Excel 2003. After I get out of the file and get back in
the format of the cells has changed. For...
|
August 4th, 2004 03:15 AM
by Dwayne
|
2 |
190 |
|
|
"x" v.b.a. code entry question by
Vato Loco
I am currently using this code ti click "x" in to a column of cells. Is
there a way I can select only certain cells in a column, like b2:b8, or
individual...
|
|
3 |
169 |
|
|
clocking by
ah
i am looking to add a clocking system into my spreadsheet
so colleagues can clock in and out and the time they
worked is recorded, how can i do this??
|
|
1 |
164 |
|
|
Wingding Font List ... by
Ken
Excel 2000 ... looking for Font List that will reflect
corresponding Wingding symbols vs alphanumeric cell
entry ...
Thanks ... Kha
|
August 4th, 2004 01:44 AM
by RagDyer
|
3 |
153 |
|
|
copy and paste multiple selections by
cip
I am trying to split a column with negative and positive numbers. I can use the custom autofilter and get all the positive numbers that I need to move to the...
|
|
3 |
599 |
|
|
|
|
3 |
424 |
|
|
Save values and formatting but not links by
cphenley
I would like to save a file with multiple sheets while retaining the
current values and format, but not the links so I can minimize file
storage space and load...
|
|
2 |
388 |
|
|
Fixed Column Width by
Carlo
Hi
I have an Excel spreadsheet that ultimately I need to save as a plain
text file but with specific column widths in the text file. (I have
tried changing the...
|
|
2 |
319 |