|
|
|
June 22nd, 2004 06:45 PM
by Trevor
|
1 |
1,226 |
|
|
Lookup or Match by
Doug
I have a sheet with inventory, col (A) material Col (B)
description and Col (C) Part Number.
I also have a sheet that does a Bill Of Materials.
It gives...
|
June 22nd, 2004 08:50 PM
by Doug
|
1 |
140 |
|
|
|
June 22nd, 2004 09:03 PM
by Trevor
|
2 |
192 |
|
|
Scorecards by
New User
I am new to excel and I am trying to learn how to create
a scorecard. For example, I want the end user to be able
to simply type a "1" in a cell but I want it...
|
|
1 |
147 |
|
|
|
June 22nd, 2004 09:40 PM
by Trevor
|
2 |
653 |
|
|
.LSP text files by
Bill DeShawn at Gregg Creghton's Office
In Windows 98, I could search within "all files" and AUTOLISP files would be
included in a search for text content in a folder. But now, in Windows XP
pro, it...
|
|
1 |
298 |
|
|
count within a range by
Andrew
Hi,
I've got a column with a list of times and want to
calculate the number of instances in the list that fall
within 12 hours.
ie. In the table below C6...
|
June 23rd, 2004 01:42 PM
by CLR
|
2 |
133 |
|
|
Save as Web Page in Excel 2002 by
Bob
Is there any way to "tone down" the code that Excel 2002
creates when saving a worksheet as a web page? We
converted to Excel 2002 this past year at work and...
|
June 23rd, 2004 02:49 PM
by Brad
|
1 |
899 |
|
|
log book by
Joe
Ok here's one that's been killing me This version works fine
B10 to 40 are numbered 1thru 31
C10 thru 40 represent the days of the month
with C3 thru 9...
|
June 23rd, 2004 04:39 PM
by Trevor
|
2 |
379 |
|
|
Copy table text to Excel worksheet by
Regina
I'm using Office XP and am putting text I typed in tables
from Word into an Excel spreadsheet due to the columns
expanding way beyond 11x17, Word's maximum...
|
June 23rd, 2004 04:51 PM
by JulieD
|
1 |
826 |
|
|
linking to stock quotes by
anne
Does anyone out there know how to link a cell to a stock
quote and automatically update the quote whenever the sheet
is opened?
|
June 23rd, 2004 04:54 PM
by chadt74
|
2 |
266 |
|
|
Opening Excel Files by
Jay
Hello,
Months ago I had origionally changed this option, but for
some reason it has defaulted back and I can't remember how
I had changed it.
How do I change...
|
June 23rd, 2004 05:59 PM
by Jay
|
1 |
507 |
|
|
Spreadsheet ideas by
6404367
Hi all,
I'm kinda doing a personal project for myself. I want to create excel
worksheet tables for all the necessities in daily life. It will range
from...
|
June 23rd, 2004 07:06 PM
by Paul B
|
1 |
239 |
|
|
Nested IF Statements by
Cindy K
Is there any way to have excel read all the parts of a nested if statement before returning a value? My formula is...
|
|
5 |
171 |
|
|
Inserting a drop down list for each cell by
RaveChic
:confused:
I need help. I read and re-read the instructions on this on the help
on Excel 2000 and I am very confused. Why do they make it so hard? I
just...
|
|
2 |
117 |
|
|
Need help Modifying a Sorting macro by
marvontherim
I have a range of dated in a column and want to arrange them in
assending order. My problem is if that this range of data is linked to
another data input sheet...
|
June 24th, 2004 08:35 AM
by Max
|
7 |
227 |
|
|
Counting of specific Conditional Formats by
Ruan
Hello,
Is it possible to count a specific Conditional Format? For example: Any
missing data in a column range due to certain criteria I highlight the cell
in...
|
June 24th, 2004 11:35 AM
by tghcogo
|
3 |
198 |
|
|
Counting in a filtered column by
greg7468
Hello all,
I am looking for a way of counting the amount of times "PASS" appears
in column B wether or not column A is filtered. I have...
|
|
3 |
114 |
|
|
|
June 24th, 2004 03:57 PM
by Paul B
|
1 |
92 |
|
|
Excel 2000 Sheet Protection by
Ed
Hello,
I'm new to this group, so any help would be greatly
appreciated. I have protected several columns in excel and
I have found that the cells that are not...
|
June 24th, 2004 04:25 PM
by ed
|
2 |
335 |