If I have a field where I enter a time can I have another field count  how
many times a time is entered.

Please I have a column of middle names. Most middle names are 1 character and
some are more than 1 character. Is there a formula that can help me know if
some middle names are more than 1 character and possible highlight or color.
All help totally appreciated.

i have this formula so i can seperate a set of number when needed. for
example a selected amount of diffrent numbers will equal a specific
number.  i need to add more to this formula so i can have it
completed.

i have a workbook where i need to set a start date to end date
i already have a a vba code copying specific columns from sheet1 to
sheet2.
on columnA of sheet1 there is a date and a time.

In excel 2003 if working with a data base and you want multiple answers you
get an error with the dget function. In excel 3 there was an extract function
that would give you multiple answers without getting an error. Is there a
similar function in excel 2003.

Every time I copy and paste values from one workbook to another, I end up
overinflating the size of the second file considerably. The data from the
first workbook is filtered, and when I copy, I copy the columns. For some
reason, it picks up something from the blanks in the first ...

Dear
i m using excel logical functions for some calculation,
eg
=IF(AND(C2="EBRK",K2=1),0.0001,IF(AND(C2="EBRK",K2>1),J2/K2,IF(AND(F2>1,E2>1),0.0001,IF(AND(J2<-2000),0.0001,IF(AND(E2>100000),1,IF(AND(K2=10000),3,IF(AND(F2>1),2,(J2/K2)*4)))))))

Whenever I have a user form in my project I am annoyed by the fact
that the VB editor constanly pop-ups during debug etc with the form
displayed instead of the code I have been working on and debugging.
Is there a way to tell Excel not to display user forms in this way?

I have created a Combobox on on 'Sheet1' thats displays a drop down from
'Projects'
As the length of the list on 'Project list' will change over time, i have
used the following function for the name range:

I need a excel macro code to open my existing txt file(test.txt), i have
saved test.txt in c: drive, my macro should open test.txt fiile then it
should copy the Book1.xls data to test.txt file...

This is my very simple nested IF statement.
=IF(H5=$C$2,"=VLOOKUP(H4,$B$5:$C$11,2,FALSE)",0)
Basically, I want the VLOOPKUP function to "work" when the value is
false,

Hi I've been using
Dim x as DataObject
x.SetText "Mytext"
x.PutInClipboard

Here is my code.
The value in "C12" range is a date but my loop is not able to detect
the date in the column.
Sub RamPlan()

Hi, I have several workbooks with over 50 worksheets.  I have to change the
font size of the text in the headers to 14 points on every sheet.  Is there a
quick way to do this with VBA?  I tried doing it without VBA, by selecting
all the sheets at once and changing the font size, ...

Please does anyone know if I can use pivot table to bring out unique values.
I have thousands of rows and columns with firstname, middlename and lastname.
Some names are duplicate and I just want to bring out only unique names.