|
|
Macro to hide rows by
Dick Stumbo
I have an excel template with 20 worksheets. I want to make
an election on the 2nd sheet in a specified cell of either
1, 2, 3, 4 or 5. With this election I...
|
|
1 |
447 |
|
|
lookup for double column by
ibo
Hi
I think this is very easy question but couldn't do it myself below sample.
std sheet is:
a b c d e f g h
kk rr ...
|
September 18th, 2003 05:21 PM
by ibo
|
2 |
477 |
|
|
Calculate Year by
MS
I would like to calculate the year a person turns 70 1/2
years old. I have the birthdate and would like to have
some kind of formula that would give me the...
|
|
1 |
169 |
|
|
|
|
1 |
598 |
|
|
import data by
cgkeel
I have a workbook with 6 worksheets. I need to pull
specific data from one sheet to one of the other 5. For
example: If O99 ="X" the I need all the data from...
|
|
2 |
262 |
|
|
EXCEL TEMPLATES by
MARC D.
I HAVE FOUND A DOWNLOAD FOR
EXCEL 2002 ADD-IN: TEMPLATE WIZARD WITH DATA TRACKING.
IT INDICATES SUPPORTED OPERATING SYSTEMS: WINDOWS 2000
WINDOWS 98, WINDOWS...
|
|
1 |
110 |
|
|
Check 2 columns in the same sheet. by
Abhiram
Hi,
Can someone suggest me if there is any function in
Excel with which i can compare 2 columns?? I dont want to
write lengthy code.
Actually i am running a...
|
|
1 |
376 |
|
|
Cell with multi equations by
Robert
Quick question,
I have several cells clculation an equation.
A1+B1=C1
A2/B2=C2
Answers C1&C2 will always be the same, as (for example)
A1=1, B1=2, A2=6,...
|
|
4 |
115 |
|
|
countif and AND by
kate
It should be so simple.... I am trying to get excel to
count the number of values for 2 conditions in a
worksheet. i.e. I want a count of the number of times...
|
September 18th, 2003 06:50 PM
by Dan E
|
1 |
102 |
|
|
Time - Covert to number by
Richard
Hi
I am working on over-time claims.
On A1 is start time, B1 is end time and C1 is sub-total
time. All cells format are :mm
Example:
A1 B1 C1
18:00 ...
|
September 18th, 2003 07:04 PM
by JohnB
|
2 |
146 |
|
|
Format of a date cell by
Glenn Johansen
Can someone tell me how to format a date cell so the user does not have to
enter the "/" marks when entering a date?
I would like the user to be able to use...
|
|
6 |
140 |
|
|
Random Numbers by
L. Howard Kittle
One way.
Enter your 1 to 10 in column A. In column B enter and pull down =RAND().
Now sort the two column by the rand column and pick the top two in column...
|
|
1 |
543 |
|
|
excel by
Carolyn
I have a column with a list of names with commas, example:
Smith, John. I want to either make the first and last
names in seperate columns or make the comlun...
|
September 18th, 2003 07:29 PM
by Rick C
|
1 |
117 |
|
|
HIGHLIGHT not working by
denise
We just received new computers and the highlight option is
not showing on the main screen, but items do show as
highlighted when I click on PRINT PREVIEW. How...
|
|
1 |
131 |
|
|
Sorting years prior to 1900 by
Jean
It appears Excel doesn't recognize years prior to 1900
for sorting. Has anyone ever found a format fix for
this? or have a suggestion to get around it...
|
|
1 |
134 |
|
|
vlookup when value is in a range by
jcollins
I have the following table (simplified) that indicates what shipping
zone will be assigned to a shipment based upon the first three digits
of the package...
|
|
3 |
278 |
|
|
range calculations by
Carol
I need to compare and calculate a range from two separate
worksheets
|
|
1 |
103 |
|
|
multiple returns. by
Ian P
I am trying to do a search on a list of names (around 1000)
the columns listed are first name, surname and employee
number.
I want to be able to search on...
|
|
4 |
258 |
|
|
microsoft excel by
carol cadelli
does microsoft xp have excel word as i can not find it
please help thank you
|
|
1 |
98 |
|
|
How do I change Syntax in Excel? by
RoseMarie
I downloaded a mailing list and it is all in CAPS (i.e.
PHILIP SMITH). I need to do a mail merge & need to change
the Syntax to upper & lower case (i.e. Philip...
|
September 18th, 2003 08:35 PM
by Paul B
|
1 |
208 |