|
|
Unique Values by
xpuser
is there any way to show only Distinct values in the
column i.e in the column Dept.
IT
Finance
Accountants
Adminstrations
Finance
IT
THE result shoud be
IT
|
|
7 |
169 |
|
|
multiple users sharing a workbook by
Lorena Ricci
I have several people that share files. I need to set each
person up to be able to view and edit only the data
partaining to them with out seeing other peoples...
|
|
2 |
392 |
|
|
Repeating pages by
Christine
Hi all!
Is there any way that I can repeat the same page about 100
times with a header reflecting the page number?
I need to print out one page 100 times, but...
|
|
5 |
132 |
|
|
Someone please help by
John Cookson
I have a problem that i'm sure someone can help me with.
I have a list of every area code in the USA and it's
corresponding State. I want to be able to read...
|
|
7 |
137 |
|
|
|
|
2 |
341 |
|
|
Need help with recap worksheet by
Anita Howard
I can a very large excel workbook that contains over 80
worksheets.
I would like to create a recap that looks at each
worksheet and returns a value.
All of...
|
|
1 |
149 |
|
|
compare and sort two columns of data by
Keith
Thru the DOS Prompt I created a txt file of a directory.
I then opened it in Excel.
I created a report in Access of similar data and
copy/pasted it into the...
|
|
1 |
362 |
|
|
Total Elasped Time by
Jason Zuelke
I am trying to determine total elasped time of an event.
For instance if something starts at 6:40 A.M. and stops at
16:30 P.M. what is the total elapsed time? ...
|
|
4 |
177 |
|
|
Copying Combo Boxes by
Wes
I'm creating a form that has 120 rows. Each row will
have the same functionality. There will be a combo box
at the beginning of each row. This combo box...
|
|
2 |
352 |
|
|
|
September 20th, 2003 02:25 PM
by RagDyer
|
4 |
429 |
|
|
Lookups by
Judd
I am tring to do a Lookup on a negative number. Not a
specific negative number, but the first time the number
becomes negative. I don't know to put this into...
|
|
2 |
98 |
|
|
Functions in Excel 2002 by
Dr. Paul
Is there any way to allow excel to permit more than 7
funtions in a formula. I have several formulas in a
worksheet with up to 7 functions, but if I try to add...
|
|
2 |
127 |
|
|
<<> by
Scooterdog
On my job I get paid waiting time when I arrive at terminal.
But the waiting time stops when the overtime starts.
Example: Arrive at terminal: 17:00
Overtime...
|
|
1 |
243 |
|
|
|
|
1 |
247 |
|
|
|
|
1 |
118 |
|
|
Hiding Formulas by
marty
On one of my worksheets, I can't change a cell from
showing the formula to showing the results of that
formula. Regardless of what cell I go to, all I see...
|
September 20th, 2003 03:06 AM
by M. lane
|
3 |
417 |
|
|
link color to a number by
mirko
First of all sorry for my English (I'm from Italy...)
Is it possible to link a color (green for example) to a
number?
This to have the possibility to make a...
|
|
1 |
117 |
|
|
Conditional Subtotal by
James
I would like to be able to add the values of one column
based on values in three other columns (no problem with
that), but would also like to be able to do...
|
|
1 |
333 |
|
|
pay function? by
huey
Hi:
I don't know if this has a function or is straightforward. I have used a
simple multiplication of number of hours times rate per hour to calculate...
|
September 20th, 2003 02:40 AM
by M. lane
|
4 |
118 |
|
|
Worksheet default values by
Charlie
Please help! When working in Excel both headings in the
column and row areas are numerical, making it difficult
to do simple addition using the SUM feature. ...
|
|
2 |
444 |