|
|
Validation? by
seftonbarn
I need some help. For arguments sake my worksheet has only one column.
In row 1 is a Y/N field. If the user enters "N" in row 1 I want the
cell in row 2 to...
|
|
2 |
450 |
|
|
automating function change by
leeners82
I'm wondering if there is a way to alter a function so that each month,
a reference in a function changes. More specifically, in this case,
every month the...
|
|
3 |
385 |
|
|
Lookup based on list of names by
tojo107
I need to import a file everyday that looks like this, but there are 250 people listed.
I want to be able to enter a formula that will look for just my team...
|
|
1 |
427 |
|
|
reading wdb file with excel by
JennaLyan
someone e-mailed me a wdb file that was created in
Microsoft Works. Can I import or convert it to be
displayed in Excel?
PLEASE HELP!!!
Thank you
|
June 15th, 2004 07:37 PM
by hglamy
|
2 |
467 |
|
|
|
June 15th, 2004 07:42 PM
by hglamy
|
2 |
714 |
|
|
Formula for returning a yes or no answer by
Bonny
Can anyone tell me what the formula is for returning a answer of yes or no, i.e.
you have a list of cars and you want to mark all the ford cars with a yes and...
|
June 15th, 2004 07:48 PM
by Paul B
|
1 |
346 |
|
|
Conditional Formats by
AlfD
Hi!
A simple thought: you seem to be interested if the biggest value
occurring in your list is 100%.
If so, set your flag to show if max(A1:A200)=100%....
|
June 15th, 2004 07:48 PM
by Et3rnal
|
3 |
382 |
|
|
|
|
2 |
637 |
|
|
array data type by
anjem
Hi, I'm trying to take a column of integers and input them into an array
which I can then use for a loop instead of using this format:
If...
|
|
3 |
343 |
|
|
How can I check 2 cells? by
Aversin
How can i check Cells D1 and C2 to see if there is a anything written in
them? (notes)
I would like to check D1 first, and if it is empty check c2, and...
|
|
1 |
227 |
|
|
Left Justify in a Custom Footer by
Dave Y
Hello,
I need to add a legend for a spreadsheet as a Custom
Footer in the center section of the Footer dialog box. Is
there a way to left justify the text...
|
June 15th, 2004 08:28 PM
by Dave Y
|
2 |
517 |
|
|
Hide selective sheets "veryhidden" by
Jonsson
Hi,
I have record this code to get certain sheets hidden. The WB contains a
lot of sheets and I only want to hide some of them.
The code works great as long...
|
June 15th, 2004 08:29 PM
by Jonsson
|
5 |
611 |
|
|
Create hyperlinks using VLOOKUP? by
lunker55
I would like to enter a model number(CM3636a) in A1.
When entered, is there a way to lookup in a table and create a hyperlink
automatically?
I have hundreds of...
|
|
4 |
528 |
|
|
Function needed! by
dwboiler
I need a function that will search a column of dates and count the
number of occurances in each month so I can graph the number of records
by month.
My first...
|
|
2 |
524 |
|
|
Need Help on IF statements by
JMyers
I am trying to create an xls template.
I have it where in like B27, the user enters a numeric varialble. once
that variable is entered, in D27 it will...
|
|
2 |
317 |
|
|
|
|
1 |
678 |
|
|
Mail by
Sashi
I had used the "E-Mail" button to mail a workbook. Since
then , whenever I open that workbook, the Outlook Express
log-in window pops up. How do I stop...
|
June 15th, 2004 09:10 PM
by
|
2 |
409 |
|
|
naming sheets by
James
hi guys!
is there a way to rename multiple sheets in a workbook at the same time,
keeping them in sequential order? for example instead of sheet 1. sheet...
|
June 15th, 2004 09:25 PM
by James
|
3 |
482 |
|
|
Formatting Cell Text by
Ben
Can you set a text up to display number's in foot and
inches example 12 would appear as 1' 13 would appear as
1'1' etc.?
Thanks,
Ben
|
June 15th, 2004 10:28 PM
by Ben
|
2 |
226 |
|
|
Overlapping time ranges by
jsollman
I am trying to create a formula to show the total time a factory line
was down during a given shift.
my problem is the overlapping times. If i just sum the...
|
|
2 |
375 |