I have a query which I am using on a excel list.  Some of the records start
with an asterick and I would like to exclude them from the list.  I have
tried .. Not Like '~*%' but that does not work.  Does anyone have a
suggestion.

Hi all,
Anyone knows of a formula or combination of formulas to display a
number with different decimals depending on a condition?
for example;

I have downloaded this template from the website & have done some revamping
to fit our needs.  The letter codes in this template stand for different
things (of course) & each letter figures as one point.  I need two of these
letters to figure as 1/2 point.  Is there a way to do ...

I have spread sheet with a 3 columns
1. column contains the projectnumber(1,2,3 etc)
2. column contains the week
3. column contains the cost made per week and per project(manually entrie)

I want to count an "A" column where the column "B" is between a given date.
The date in column B has a date and a time("dd-mm-yyyy hh:mm:ss").  The date
arguments in the sumproduct are in the "dd-mm-yyyy" form. The formula should
find "like products", not the exact match.

Thanks for reading this post.
Is there any way I could repeat, for instance rows 1, 3 & 6 of a worksheet,
on each page? (i.e. rows 2, 4 & 5 should not repeat on each page)
Thanks

Want to assign a name to a worksheet based on user input.
DataFileName = Application.GetOpenFilename(filefilter:="Text or ASC Files,
*.txt; *.asc", Title:="Select the Data File")
'Create A New WorkBook With One Worksheet

We receive XLS files which contain columns of numbers which we then us
to calculate other fields. The columns should just contain numbers bu
some (randomly) seem to have been created as numbers in text forma
(i.e. it shows the number zero). If you try and test for them bein

Can someone please tell me how to create a formula that will allow me to
divide a number in half in the same cell of the initial number.  In
other words, if I type in the number 1000, I want a formula that will
convert that same number to 500 as soon as I hit tab, enter, or

i need a help to make a vlookup function which looks for a value
between 2 values. the calsse are defined in sheet 1 and the value in
Sheet 2. for examlpe in sheet 2 i want the class to have value C becuse
it's total is between 1001 and 1500.

I HAVE TO ENTER DATA OVER AND OVER AGAIN IN A WORKSHEET. I CAN HIT THE TAB
BUTTON AND AUTOMATICALLY GO TO THE NEXT CELL. HOWEVER, WHEN I GET TO THE END
OF THE ROW I ENTERING I HAVE TO SCOLL BACK TO THE BEGINNING OF THE WORKSHEET
OR BACK TAB TO IT. IS THERE ANYWAY TO FORMAT THE ...

Thanks for reading this post.
Is there any way I could repeat, for instance rows 1, 3 & 6 of a worksheet,
on each page? (i.e. rows 2, 4 & 5 should not repeat on each page)
Thanks

I have a spreadsheet that contains data that has three identifiers: Week,
Type & Coupon.  I was wondering if there was a way to reference this data by
calling out these three identifiers.
Example:

EXCEL 2002
When I set up a sum formula, the program adds 1 value to the total.
I am trying to duplicate a Lotus worksheet and the sums do not agree (SOME
are off 1 value, but not all are off).

How to calculate something using equation from Chart' directly?
I have some equation that gerenarted from the trendline in the chart (Power
equation). The other iteration want to use the formula directly from the
chart. Somehow I don't know how to do that since I can't find in the ...