|
|
|
|
1 |
64 |
|
|
|
|
1 |
78 |
|
|
Parse A String into Two by
xlmate
I can't remember how do I separate the text into two
by finding the 2nd upeer case.
eg SmithJohn to Smith John
--
Appreciate your help.
( 1 2)
|
|
11 |
136 |
|
|
|
|
1 |
76 |
|
|
pick list location by
liem
I have a set of data with 10000 row
Div Market salesman Factor Result
1599 1501 John sales R
1599 1501 John Profit ...
|
February 21st, 2009 02:00 AM
by liem
|
3 |
97 |
|
|
if- then statements by
Paul
hi there. i cant figure out how to do an "if - then" type of function. If A1=
23 then B2= Red
or,
if A1= Blue then B1= Color
wheere i have a list of datat...
|
February 21st, 2009 01:06 AM
by Pete_UK
|
7 |
64 |
|
|
Extracting row with lagest amount by
Steve Walford
Hope someone can help
Using Excel 2002
I have a large spread sheet, which details the amount of fuel issued
to individual vehicles over a set period...
|
|
7 |
154 |
|
|
How do I retreive the last # in a column? by
Claudio
I am trying to substract the value in the first cell in a column from the
last value in that column using a function, which i can't find.
I want this unknown...
|
|
2 |
83 |
|
|
|
|
2 |
77 |
|
|
drop-down list by
karelina
How do I copy a drop down list easily in a column of 600 rows? Dragging
doesn't work, copying all the cells and validating doesn't work, fill down
doesn't...
|
|
2 |
68 |
|
|
Alphanumeric custom formats by
May47
does anyone know how to create a custom format in Excel 2007 that will all
you to enter this: 123456B789 and it automatically changes it to...
|
|
3 |
71 |
|
|
|
|
4 |
91 |
|
|
Need MAX value if condition is met by
SCC
I have a spreadsheet that lists usage in our computer lab. From the data I
am able to get the average usage for each day using the averageif function...
|
February 20th, 2009 09:10 PM
by T. Valko
|
4 |
55 |
|
|
|
|
3 |
98 |
|
|
Sharing by
Bridget
Hello,
I'm having trouble making a document viewable to all but one that can only
be edited by 2 other people. I went into tools to share the document and I...
|
February 20th, 2009 08:09 PM
by Bridget
|
2 |
106 |
|
|
|
February 20th, 2009 07:56 PM
by Luke M
|
1 |
66 |
|
|
|
|
4 |
122 |
|
|
2 formulas in 1 cell by
MAX
If cell B2B1 answer in A2 must be 0 and
if cell B2B1 answer in A2 must be equal to B1
|
February 20th, 2009 06:56 PM
by MAX
|
5 |
76 |
|
|
OMG Help! by
AbbysMum04
I am not an excel expert so I'm hoping someone reading this might be. I am
attempting to create a "Scoring" sheet with pre-set values for criteria.
What I...
|
February 20th, 2009 06:49 PM
by ~L
|
3 |
60 |
|
|
|
February 20th, 2009 05:53 PM
by Joel
|
1 |
62 |