|
Small blank pictures hiding borders in 2003
When I open an Excel 2000 worksheet in Excel 2003, sometimes some of the
cell borders appear to be hidden. When I click one of those hidden borders,
I see six handles and a green rotate handle surrounding what appears to be
nothing. When I drag one or more of those handles, the object expands to a
large white rectangle. When I right-click on the white rectangle, one of the
options in the...
|
1 |
26.09.2006 19:32:05 |
|
|
X Y position
Hi
Can someone confirm that the figures at the end of the code below, relate to
the position of where the input box will appear on the screen?
I then need to be able to explain to a non techie how that relates to a
screen.
Thanks
A
InputBox("Enter destination of call", "Call made to", " ", 2500, 2000)
...
|
3 |
26.09.2006 18:55:45 |
|
|
If Statement
Hi In an If styatement, how would I go about testing to see if a cell
contained a text string please
- If (E2="*Phone","True","False"), which is what I assumed the syntax was,
doesm't work
Thanks
A
...
|
4 |
26.09.2006 18:25:05 |
|
|
Excel Group/Ungroup doesn't work
Hi
I am running Excel 2002 SP3
My spreadsheet is not protected and I still can't group rows. It
doesn't return any error message or any other strange behavior.
Any ideas ?
Thanks
...
|
2 |
26.09.2006 16:22:16 |
|
|
Standard trend function versus array
Can someone explain the array function to me. And, what is the
difference between trending data using the standard trend function, and
adding an array to the trend?
I have five data points (utilization rates for 2001-2005) that I want to
trend out for 30 years. I would like to do it annually for the first 15
years, and then in 5 year increments.
Thanks,
Angie
...
|
3 |
26.09.2006 15:13:02 |
|
|
Saving Data Into Columns ?
Hello:
I have copied the following data from a web page that has it listed
in three columns:
311.000 AM STRATCOM primary
321.000 AM STRATCOM secondary
243.000 AM Distress/guard
However, as expected, if I just do a copy on these columns that I've
highlighted, it wants to put them all in a single column in Excel.
What I would like is to put the column data f...
|
5 |
26.09.2006 11:34:11 |
|
|
Password
Will creating password for excel 2003 (97/2000 compatible) at a user account
be unable to open at another user account?
...
|
2 |
26.09.2006 03:28:49 |
|
|
Cells no longer highlighted in XL2003 edit mode?
In Excel 2003 edit mode, with F2 or double-clicking in the cell...
I USED to be able to see the highlighted cells and the formula, but with
or without Edit Directly in Cell enabled, and the formula displayed in
the cell, referenced cells are no longer highlighted in edit mode...
Any ideas how to restore the cell highlighting?
...
|
3 |
26.09.2006 03:17:20 |
|
|
Excel User Conference Information - October 25-27
There's a wonderful conference for Excel Users. Led by Excel MVP's and Excel
gurus. Find out details at
http://www.exceluserconference.com and sign up! This is the 4th time it's
been done - Fort Worth, Atlantic City, London, and now Marina Del Rey,
California.
Come one, come all!
...
|
1 |
26.09.2006 02:39:43 |
|
|
Range Commands in Macros
I have attempted to create a column insertion macro that dynamically copies
a static value of 'Active' into all the rows in the range. To this end,
during recording, I move to the column to the left and use an END-DOWN.
However, when I replay the macro, it copies the values to the static number
of rows that existed during the recording rather than the number of rows in
the current sheet...
|
5 |
26.09.2006 00:02:31 |
|
|
Counting the number of MONTH in a column
Hi, just wondering how I can count the number of times a month occurs
within a column.
Example
Date
=====
8/9/06
8/9/06
8/9/06
9/10/06
9/10/06
9/10/06
8/9/06
8/9/06
Answer:
8/9/06 = 5
9/10/06 = 3
Thanks. Done it before but can't remember how the heck I did it. I
blame alcohol.
Kind regards,
Ka Kwok
...
|
7 |
25.09.2006 23:46:16 |
|
|
Finding Minimum and Maximum Values of first fifteen days
Hi All,
I have data as follows
Column A - Date (daily basis)
Column B - Qty
Column A spans more than 300 rows (dates) now.
I want to find minimum and maximum values of Qty for every date range
(1 to 15) and (16 to last date of month).
What formula should I employ?
Thanks,
Nimish
...
|
2 |
25.09.2006 23:14:50 |
|
|
Refer to only certain cells in a named range
Is it possible to refer to only certain cells in a named range. ie. I
want to use in a formula the 2nd cell in a named column range, how do I
reference it in the formula?
...
|
2 |
25.09.2006 22:56:17 |
|
|
Protect sheets not allowing entering of data in multiple sheets
Hi All,
I have a customer who has a workbook with protected sheets in it. They have
cells that are unlocked that they enter information in. The user may want
to enter the same information in the same cell in multiple sheets. If the
information is numeric it will allow it. If it is text, the data will
disappear when the user presses enter. Has anyone run across this and found
a so...
|
1 |
25.09.2006 22:55:20 |
|
|
Using a COUNTIF function on large text fields
Hello all,
I am trying to use a countif function to count the number of
occurrences of a specific phrase within a column of data:
=COUNTIF(<column>,"*text*")
The problem I am encountering is that the countif function stops
searching after the first 254 characters in each field.
Any ideas how to get around this?
Thank you in advance.
...
|
2 |
25.09.2006 22:04:02 |
|
|
Using COUNTIF function on large text fields
Hello all,
I am trying to use a countif function to count the number of
occurrences of a specific phrase within a column of data:
=COUNTIF(<column>,"*text*")
The problem I am encountering is that the countif function stops
searching after the first 254 characters in each field.
Any ideas how to get around this?
Thank you in advance.
...
|
1 |
25.09.2006 21:48:57 |
|
|
Formula problem
I'm using excel to just added to columns. I don't know the values of the
coulmns yet but obviously i know the formula. How do i input the formula
without the result showing as zero before the data has been input....
|
4 |
25.09.2006 21:36:07 |
|
|
formula to replace cell with over 8 characters with word LAN
Hello Group,
I hope someone will be able to help. I need a formula that can check each
cell in column "D" and if it has over 8 characters in the cell, return a
value of the word LAN in column "F". Anything with 8 or under should remain
as is. There will be up to 600 row entries in column "D".
example of col: 799Z
777X
79BM
08/30/06(An)
08/30/06(Put)
08/3...
|
3 |
25.09.2006 21:14:26 |
|
|
Delete fixed rows in Excel
Is it possible to delete fixed rows or columns in Excel.
Thanks in advance.
Regards,
Arjun...
|
6 |
25.09.2006 20:23:36 |
|
|
No macro's but still macro warning
Hi,
I opened an Excel '97 template containing macro's in Excel 2003 .
I removed all macro's from menu Extra | Macro's and saved it.
But still when opening this template a macro warning asks
[Disable macro's] [Enable macro's] [Help]
Apparently something about macro's is still in there.
How to remove this so I can raise macro protection back to High.
Any suggestions ?
TIA,
Joh...
|
3 |
25.09.2006 19:45:41 |
|
|
Dynamic Range Not Working
I created a named range called HarvestData.
In the refers to box I typed the following:
=OFFSET(Harvest!$A$2,0,0,COUNTA(Harvest!$A:$A),COUNTA(Harvest!$1:$1))
I hit ok.
If I go back into the "Define Name" dialog box and select the name
"Harvest" and have it point to the actual range in the worksheet, it
highlights cells A2:B20. The problem is, there are data in columns A
to N. Why ...
|
4 |
25.09.2006 17:10:50 |
|
|
Error in VLOOKUP REFERENCE?
The following formula is in a cell in a worksheet called MODEL. It
pulls data from the named range HarvestData. Problem is, if I add a
column before "M" in the named range HarvestData, effectively moving
data from M to N, my lookup formula obviously no longer works. Does
HarvestData need to be a dynamic range (it is not) or does the problem
lie in the VLOOKUP? Somehow I need to update t...
|
4 |
25.09.2006 15:46:15 |
|
|
Cell Format
In Column A, I have a general categories of problems. (There happens to be 12
categories, which isn't important beyond letting you know there are multiple
categories).
In Column B I give examples of the problem. The examples are numbered. Is
there a way to set the cell format so that it acts like a bullited list i.e.,
the number, a tab, then wrapping from the tab to the end of the cell....
|
2 |
25.09.2006 14:34:09 |
|
|
Problem trying to create a "values only" sheet
I have a rather large spreadsheet full of basic data and a lot of derived
statistics - the stats are in 1 of the worksheets. I want to be able to send to
a number of folks ONLY the statistics sheet and in a values-only form. I did a
"COPY" and "PASTE SPECIAL - VALUES" for the stats sheet and then deleted the
other sheets. It all works fine except for the charts that are in the stats
shee...
|
3 |
25.09.2006 13:12:04 |
|
|
Identify Unique Items
Consider the list below. I want to somehow count the number of unique
assignments for each manager.
Manager Assignments
Fred Neil
Joe Ian
Joe Dave
Fred Alan
Fred Rick
Joe Dave
Fred Neil
Joe Andrew
Fred Rick
Fred Alan
Fred Rick
Joe Dave
Joe Neil
Fred Alan
Fred Dave
Joe Neil
e.g. using filter, Fred has 9 assignments, but some are duplicated, and so
has only 4 unique assignm...
|
5 |
25.09.2006 10:08:56 |