|
|
Counting number of characters in cell by
saturnin02
Hi,
I need a formula to return in cell A2 cell A1 if cell A1 has more than just
one letter: "Bob" for example but if cell A1 only has letter "B" or is
blank, I...
|
|
4 |
494 |
|
|
Excel Number Format Codes by
MBB
I can't figure out how to format numbers so that when you type 3220 it will look like 32.20 kinda like how you can enter numbers on an adding machine. I would...
|
|
3 |
415 |
|
|
A Turing Machine in Excel by
George W. Cherry
I'm just learning my way around Excel. I'd like to
see how to program a Turing Machine in Excel.
I Googled:
microsoft excel "turing machine"
and got over 700...
|
|
2 |
175 |
|
|
Worksheet alignment is out on pc by
teddybis
I tried opening different workbooks on my PC and the alignment all seemed to 'overflow' from the A4 size setting. I had opened the same workbooks on a few...
|
|
1 |
149 |
|
|
Use defined names in VBA? by
JRocket02
Hi all
Any way to have Excel generate links or dimension variables so that VBA can
use the defined names on the spreadsheet (menu: insert name define)? ...
|
|
1 |
163 |
|
|
|
|
5 |
483 |
|
|
using countif() to parse string by
tivarney
I am trying to use countif() to parse a cell which contains a string.
For example, the string could be "This is the example string."
Can I use the countif()...
|
August 3rd, 2004 08:13 AM
by JulieD
|
3 |
171 |
|
|
Text format by
Me
Hy,
I have an text how looks like this: "AA-BB CC-dd". I want to select the text until the "-dd", so the result would be "AA-BB CC". So the text until "-"...
( 1 2)
|
|
10 |
212 |
|
|
converting dates by
rexmann
Hi All
I have a couple of excel problems to do with dates (Excel XP/2002).
I have a formula that displays one date minus another and displays the answer as...
|
|
4 |
358 |
|
|
alternative to INDIRECT reference by
Nornny
Hi everyone, I have a really big Excel workbook with hundreds of
INDIRECT references to other sheets within the workbook. That is the
ONLY type of INDIRECT...
|
August 3rd, 2004 03:40 PM
by Nornny
|
3 |
239 |
|
|
|
|
2 |
354 |
|
|
|
|
3 |
433 |
|
|
#NUM! error by
Richard
Whats wrong.
{=SUM((Sheet1!A:A="*")*(Sheet1!B:B="\\\\\\CC\\\\\\")
*Sheet1!E:E)}
thanks in advance
( 1 2)
|
August 3rd, 2004 04:50 PM
by RagDyeR
|
12 |
318 |
|
|
|
|
1 |
284 |
|
|
Too many different cell formats by
André Martins
I have one worksheet with this problem but in despite of=20
doing a lot of modifications, some time after the problem=20
is still happens. Someone know how can...
|
|
1 |
193 |
|
|
Print Rows at Top only on some pages by
S.J. Ring
I have a spreadsheet which contains two types of data, a
total of 12 pages.
The first 10 pages are formatted identically and when
setting the print ranges I...
|
|
2 |
472 |
|
|
Always negitive by
HessInAMess
is there a way to tell excel to always make any numbers in a cell
negitive? even when the number wasn't entered with a - sign? I've been
trying to use the...
|
|
2 |
157 |
|
|
if color then formula in cell by
Jonsson
Hi,
Can anyone help me to write a code that says:
IF text in cell B4=red, choose formula in cell C4
IF text in cell B4=black, choose formula in cell D4
IF...
|
|
4 |
339 |
|
|
Happy Face Graph ... Is it possible? by
Ken
Excel 2000 ... Is it possible to create a "HAPPY FACE"
Graph where the Face would incrementally turn from a "SAD"
Face to a "HAPPY" Face as Customer...
|
|
5 |
271 |
|
|
funcres.xla by
Fritzj
When openning excel, I now get a message that funcres.xla
is not in right place or gone. What do I do? It did not
use to do this.
|
|
3 |
208 |