|
|
|
|
2 |
96 |
|
|
max number of spaces/letters by
willemeulen[_25_]
How do I program a cell to have let say a maximum word/sentence length
of 50 spaces.:Bgr
--
willemeulen
Blink1 *Willem van der Meulen* BSc Soil & Water Eng...
|
|
4 |
103 |
|
|
|
|
2 |
83 |
|
|
IF(OR - Help! by
j5b9721
I have tried to make this work in a cell but I must be doing something wrong...
I tried different ways shown below... what am I doing...
|
May 25th, 2009 09:08 PM
by Max
|
1 |
71 |
|
|
Function & paste special values by
backmara
How I use functios whit "paste special?
Meaning: I have data A1 and 1 use some function A2, after that I have to
delete colum A1. So A2 get #REF!, how I have...
|
|
2 |
101 |
|
|
VLOOKUP & SUMIF by
Jock
I wish to somehow combine these two functions so that if "Ford" for instance
appears six times in column 'B' then the SUMIF part then returns the sum of
the...
|
May 25th, 2009 06:51 PM
by Ari
|
6 |
86 |
|
|
4 "-" cells" help by
j5b9721
In
A1 is "-115"
B1 is "-15" ---
C1 is "-18" ---
D1 is "Week 4"
E1 is "Price"
F1 is "-65" ---
G1 is "-25" ---
H1 is "256"
I1 is "-27"
|
|
5 |
84 |
|
|
|
|
10 |
96 |
|
|
|
|
13 |
293 |
|
|
|
|
5 |
101 |
|
|
Help for Time tracker updation by
Igneshwara reddy[_2_]
Hi,
I have 9 members working on a project and require to track the timings for
all.
There are 6 columns in the spreadsheet.
column 1 contains the type of...
|
|
1 |
76 |
|
|
#DIV/0 error by
Daniell
What I am working with is a simple divide statment using two worksheets.
=('Product'!P20/'Product'!P21)
If the answer comes out to zero I get the #DIV/0!, is...
|
|
6 |
93 |
|
|
VLOOKUP by
Kevin McCartney
Hi TWIMC,
Usually when referencing into a different workbook, Excel constructs the
formula like so:
=VLOOKUP(B10;'C:\folder path\My...
|
|
7 |
79 |
|
|
Split cell by
Elton Law[_2_]
Dear Expert,
How to split a cell into 3 parts if they are like this please ?
Befo
9j36 in one cell
After:
9 j 36 in 3 different cells
Befo
10°32 in...
|
|
2 |
69 |
|
|
Get "Large" from list by
art
Hello All:
I asked already this question in not a clear manner, so I got unclear
answers. So I would like to ask again my question. I hope someone will...
|
May 25th, 2009 12:31 PM
by Joel
|
1 |
94 |
|
|
|
|
1 |
85 |
|
|
Timesheet help by
The Golfer
Am using Excel to keep a record of hours worked by 9 people who perform a
variety different tasks daily. The start time and end time are entered in
hh.mm...
|
|
2 |
73 |
|
|
worksheet function in event macro by
Ita
Hi,
I have a code in worksheet_selectionchange that doesn’t seem to work.
I intend to do vlookup in column W to Y based on changes column B & C (if
column A...
|
May 25th, 2009 10:56 AM
by Ita
|
3 |
91 |
|
|
Date format in the cell by
backmara
How I can change date format.
My problem is following: I use other program where I can export excel-file.
This program use USA format (like 05/25/2009), but...
|
|
1 |
80 |
|
|
Screen Size by
[email protected]
Is there any way to expand a selected column width to fill the screen
automatically by macro or Tab event, and if there is will it expand to
fit any size...
|
|
0 |
72 |