|
|
filter? by
Jan
I have a column that contains a bunch of repeating
information. what I would like is to somehow filter the
column so that only one of each topic appears.
for...
|
June 15th, 2004 12:42 AM
by AlfD
|
2 |
366 |
|
|
averaging time values by
Karen
I have a worksheet with data per week that I need to average for the month. However, until all weeks are completed the Avg/Month is wrong. Is there a way...
|
|
1 |
372 |
|
|
Validation blues by
Hari
Hi,
I have created different validations in my worksheet using a list as
dropdown.
Strangely when I click on the cell which has validation then the...
|
|
5 |
562 |
|
|
Hyperlinks by
engmgriff
Hi
I have set a number of hyperlinks up in excel to jump to different
worksheet in the same workbook. My problem is when i hide the
worksheets my hyperlinks...
|
|
1 |
356 |
|
|
Seperating Text Out Of All Text Fields by
Vato Loco
can I use the "find" function using no special text?
I need to seperate the names out of the following string:
first JIM mi T. last JOHNSON
---
Message...
|
|
1 |
530 |
|
|
Export to DBF by
Paul Masters
I am trying to save a spreadsheet into dbase (dbf) format
but find that cell contents and headers are truncated in
the created file.
any ideas would be...
|
|
3 |
457 |
|
|
Document not saved by
johnfli
I am trying to save a spreadsheet.
Everythgin seems fine excpet for the message "Document not saved"
Why is it telling me this and how can I save my work?
I...
|
|
1 |
582 |
|
|
Selective Workbook Data Summing by
donkirk
I've created a Monthly Plant Activity workbook, with 31 Daily Reports.
Each Daily Report has a list of Serialised Equipment used and the hours
they worked....
|
|
1 |
364 |
|
|
Code wont work "Visible=xlSheetVeryHidden" 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...
|
|
3 |
483 |
|
|
Scrollbar Problem by
The Wonder Thing
Hi, I'm having the age-old problem of having a billion rows on my worksheet for some reason (44327 to be exact), when this particular sheet only uses 263 rows....
|
|
3 |
443 |
|
|
|
|
1 |
393 |
|
|
Hyperlinking within a workbook by
keith0628
I have a workbook with more sheets than I can easily navigate through.
I would like to create hyperlinks that jump to other pages, but after
following the...
|
|
4 |
400 |
|
|
sum of colors by
borrowedfreedom
I am working in Excel 2003 and have a spreadsheet built that used to sum
up specified colors in a cell with an old version of Excel (used to
have Windows 95,...
|
|
4 |
472 |
|
|
delete multiple rows by
Continental Translations
I want to delete rows 4,6,8,10,12 etc etc.... So, from row 4, I want to
delete every other row. My rows go up to 4000 or so
Any ideas?
|
|
2 |
481 |
|
|
Question by
Alex
I would like to do somethings as follows,
e.g
Sheet 1
a b c d e
1 orange Apple pear grape Pineapple
2 ...
|
June 15th, 2004 07:43 AM
by Alex
|
3 |
380 |
|
|
|
|
1 |
1,060 |
|
|
new user desperate for help by
drooby
hello all,
I am wondering if anyone has the answer to this.
my first column A has a lot of repetitive...
|
|
2 |
448 |
|
|
Printing landscape Excel97 by
Rob Rijs
I'm looking at the following problem: Excel97 on a NT4
Workstation worksheet is setup to print landscape but
the printer (HP Business Inkjet 2250) gives...
|
June 15th, 2004 10:27 AM
by
|
2 |
427 |
|
|
Using IF in formula by
I am trying to build up a YTD value in a cell on a
worksheet named YTD. The YTD value is the sum of cell
ref "A17" on each worksheet named JAN, FEB, MAR...etc...
|
June 15th, 2004 10:30 AM
by
|
7 |
414 |
|
|
Using COUNTIF with MONTH in formula by
Kevin
Hello,
I have a number of formulas where I use the COUNTIF() formula to
count the number of occurences of a particular item in a range.
Now I would like to...
|
|
6 |
475 |