|
|
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 |
|
|
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 |
|
|
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 |
|
|
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 |
|
|
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 |
|
|
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 |
508 |
|
|
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 |
|
|
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 |
|
|
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 |
|
|
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 |
901 |
|
|
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 |
|
|
.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 |
|
|
|
June 22nd, 2004 09:40 PM
by Trevor
|
2 |
653 |
|
|
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:03 PM
by Trevor
|
2 |
192 |
|
|
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 06:45 PM
by Trevor
|
1 |
1,227 |
|
|
|
|
2 |
166 |
|
|
Create list to choose from by
Dianah
Hi,
I'm just trying to create a short pulldown list in a spreadsheet. Instead
of having to retype repetitve selections for this spreadsheet that gets used
a...
|
June 22nd, 2004 05:47 PM
by JulieD
|
3 |
370 |
|
|
Relative to absolute by
tghcogo
Hi guys
Is there a shortcut of any sort to convert a relative value to absolute
without having to individually edit the cell.
Many moons ago I used to be...
|
June 22nd, 2004 05:17 PM
by tghcogo
|
4 |
102 |