software

column A has dates, column B has a,b,c,.......
I need to count by Fiscal Year Quarters (10/01/05-12/31/05)only those that

Hi all,

I wish there was an option with VLOOKUP so you could tell it to treat numbers
stored as text and plain text numbers the same.

Why can't Excel Auto format for Tuesdays and Thursdays or Monday and
Wednesdays. 2 cells make up a week. The 2 cells refer to Tue and Thur. I

My 1st tab is a summary report... references information for all the other
tabs. I want to be able to automatically update the summary report on the

Hi I am trying to find the cells containing the text defect and wanna

I have a series of rows that I need to auto fill in a certain way - It

Hello,

I recently downloaded a document onto Excel instead of Office. How do I
change this document so I can read it?

Hello All,

Hi all,

I'm creating a list of all the sales appointments that have been set for our
sales staff. The list will track which salesperson went on the appointment,

Is there a way to sort by the last character of each cell without using the
formula =RIGHT(A1,1) in another column and sorting on that new column?

How do I change the size and location of the MsgBox.
Hi there Dan,

Is is possible to determine the number of blank characters entered in a
cell? What I mean by Blank, is when the user uses the spacebar to clear the

Hi,

How I convert date formatt of dd/mm/yy to mm/yy (not cell format) ?
I want to use the histogram option from tool menu (add-in) to count the

I have the following info setup, I need to be able to sum by customer for
each month. The days represent shipping volumes for each day. This same

I am having difficulty finding a loan amortization template for Excel that
allows for a first payment date that is greater than 30 days from the loan

should have be written as explained at #extract instead of #VAL
www.mvps.org/dmcritchie/excel...ng.htm#extract