I am using a combo box to chart a data series (prices) versus another
series (GDP) depending on a ticker. For some of my tickers, the data
doesn't go back as far as GDP does. I would like to cut off my chart
to only go back as far as my price data does for each ticker. I've set

Pls tell me how to sort out datas (A-Z or alphabetical oreder) without
affecting the format (like spaces or rows in between). Any help would be
greatly appreciated. Thank you.

When I enter data into a cell, and move over with the arrow keys to another
cell, Excel creates a random formula in the place of the entered data.

Hello Excel Guru's,
I am trying to cross out any names that do not appear in a list using
conditional format.  I have named the list Members.  Listed below is my
sample list:

When importing data from a SQL-Server, I want to create an automatic
hyperlink to one of the cells retrieved from the db. The link can be built
based on the data in the database. When I build the function
"=Hyperlink("http://eskoplanet.esko-graphics.com/planet/wt ...

Your technique works a treat when I insert the code; however, when I save the file and reload it (after having saved it as a Macro-enabled Worksheet in 2007), the code does not seem to work.
Am I doing something wrong?
Regards,
Anand

Is there anyway to password protect a workbook that is shared. The problem
at the moment is that this file is required to be shared for marketing
access but sometimes the marketers go in there and change the formulas. I
know I can lock certain cells from editing but this is only ...

I need some help on a common problem in our company.
We have several clients that we have agreed to do some Excel 2003
spreadsheets for.  The spreadsheets analyze our performance for them.
These spreadsheets follow a very specific formatting that the clients

how to download excel help preferably in the form of chm?

How would I specific items within a cell or column?
EX:
x,y,1,4,3*,2,x
x,4,9,y,z,y

I can't remember what the best way to post this is... what group or
groups, I mean, so my apologies if this too not appropriate.
We receive 3-4 files per month. These are flat files; a header row
with a variable number of records on the following rows. We have a

I have data in Col A & B,\. The data starts at line one and CURRENTLY goes to
line 214..but that will  increase over time.
In order to better display this data I would like a micro that would display
all the data in 5 blocks accros the screen.

there is a formula
=IF(ISERROR(VLOOKUP(A3691,A$1:A3690,1,FALSE)),"") &
IF(ISERROR(VLOOKUP(A3691,A3692:A$6867,1,FALSE)),"")
when I change A$6867 to A6967

I have the following formula in a cell
=LEN(SUBSTITUTE(A1,",",""))
This is for counting data such as:
1,2,3,4

is it possible to use 2 criterias?
tia