|
|
Help Please - VBA Excel by
Bill
I would be grateful if somebody could advise
if there is a simpler way of deleting duplicated
cells in a spreadsheet
Spreadsheet
Add1 Unique
Add2
Add3
Add4 ...
|
June 13th, 2004 01:53 PM
by JulieD
|
7 |
166 |
|
|
Office 2003-Excel by
[email protected]
When I was using Office 2000-Excel, it was a very simple procedure to make a
calculation of e.g.: -
(L8+L9)-E9=
Now when I want to make this simple calculation...
|
|
6 |
151 |
|
|
creating cost sheet by
John
hi there i'm trying to make a cost sheet for pricing up jobs i have many items which are defined by a number and need to copy complete line which corrisponds...
|
June 13th, 2004 06:00 PM
by CLR
|
2 |
408 |
|
|
Default Value for an empty cell by
Jimbo
I am trying to use an "IF" statement which it checks the value of a cell. If there isn't any input, including a zero, I want it to do one thing and another...
|
June 13th, 2004 06:16 PM
by CLR
|
2 |
557 |
|
|
countif by
cp
I am trying to count a range of numbers in a column I
created in excel to see how many times a particlar range
appears. For example, I have a column with 10...
|
June 13th, 2004 07:28 PM
by Ragdyer
|
6 |
272 |
|
|
|
|
3 |
105 |
|
|
Most likely Lookup -formula problem by
John Doe
Hello there,
sorry for quite uninformal subject...
anyways, the problem as follows:
I want to make excel sheet , which has information about distances...
|
June 13th, 2004 10:40 PM
by CLR
|
4 |
306 |
|
|
match? lookup? by
dabblingenglishprof
Here's a copy of my worksheet
FULLNAME STUDENTID Column3
Ace Elizabeth 000-00-0000 Ace Elizabeth
Alece Stephanie 111-11-1111 Ace Elizabeth
Alvis Gina...
|
|
3 |
128 |
|
|
file pathway as footer by
gabrika
Hi, Does anyone know if it's possible to add the file
filename and path automatically in an Excel Workbook as a
header or footer? I know you can do this in...
|
June 14th, 2004 02:54 AM
by CLR
|
2 |
139 |
|
|
|
|
1 |
450 |
|
|
|
June 14th, 2004 11:19 PM
by CLR
|
3 |
160 |
|
|
global changes from alpha to numeric by
jdavis777
I have large strings of numbers that need to be keyed into my worksheet and in order to save time, would like to assign an alpha character so I can just go...
|
June 15th, 2004 12:47 AM
by CLR
|
3 |
325 |
|
|
Formula for cycle time by
JBell
Hi,
I need a formula to determine cycle time... actually to
calculate the number of days from the date in one cell to
the date in the other and put it in a...
|
June 15th, 2004 12:51 AM
by CLR
|
3 |
220 |
|
|
date formats by
casino guy
How do you make the date format 1/1/2004 appear as the day of the week Saturday?
|
|
3 |
212 |
|
|
Help on SUMIF please! by
boxcarracer15
Hi,
I have a spreadsheet where I am trying to insert a function in a cell
which would say:
'Display the sum of cells B5, C8 and B10. If the value contains...
|
June 15th, 2004 02:45 PM
by Vaughan
|
2 |
167 |
|
|
Create variable formula by
Jacqueline
I am trying to create a table where the value of a cell in Column C depends on the value of the previous cell in column C + The current value of cell in Column...
|
|
2 |
287 |
|
|
|
June 15th, 2004 11:20 PM
by CLR
|
2 |
639 |
|
|
|
June 16th, 2004 01:02 AM
by Arch
|
4 |
272 |
|
|
TextToColumns question by
Arch
I want to split full name column into three columns, first, middle, last. Some of my full names do not have middle initials. In that scenario, the last name...
|
|
2 |
121 |
|
|
reading excel files by
dave
I do not have excel loaded onto my computer. All I want
to be able to do is read xls. files from email sent to me
or xls. files from the internet. What do I...
|
|
3 |
492 |