I need to format and work with lap times in the form mm:ss:ttt (minutes,
seconds and thousandths). I cannot find out how to format these so that I can
perform comparisons on them and draw up charts. Can anybody help me? I know
about "Format Cells" of course but don't seem to find ...

I created a new  column using the following formula
Cells(1, WorksheetFunction.Match("STOCK CODE", Rows("1:1"),
0)).EntireColumn.Insert
But I to goto to first cell of that new column which are created newly with

I am trying to import a *.txt file that has a semi-colon delimiter. When I
run the import, Excel places each individual record into a new column. I need
to import each record into a new row instead. Can you help?
Randy Bratton

D'all,
Can "if " search values in a list/range?  If yes plz help with an example.

A--------------B-
6N    FALSE              
6N    FALSE
7N    TRUE

I am trying to make formulae that is used regularly be more user friendly.
Is there a way I can enter a range and use that input data in a formula.
e.g. in A1 type "D3" and A2 type "D50" B1 type "E3" B2 type "E50" then use
D3:D50 and E3:E50 in a formula, e.g. =SUMPRODUCT(--(D3 ...

Help, whenever I try to makea shortcut to desk top of anything it ends up a
LNK file, all all shortcuts in Startup menu are LNK files, even if a program
wants to put a shortcut on desktop it ends up a lnk file also on startup
excel will open up a lnk file

Hi Trying to make a drop down list in excel.  I have tried the validation
method and cannot seen to get the path correct.  I have a speadsheet with say
7 worksheets the first being the main one the rest hold individual data that
I want each cell in the 1st table to look up and ...

I would like to input two numbers being the max and min available amounts and
input a third number between those two and have it calculate the percentage.
EG.
input 1: 10 min

I am trying to have what ever is entered in a group of cells format the
same(1st letter upper case, rest lower) I have done =proper(a1) and pasted to
the proper cell. The problem is once I type something else in the cell it
reverts to normal.

I have 2 EXCEL files with the same amount of data but have different sizes in
bytes.
One file size is 50KB the other, 1.5MB.  What could be contributing to this
difference in size, and how do I find out the hidden objects that contribute

Here is my situation
I have a data range that contains a six-character value. I only care about
the last character
I want to sum the values in I4:I29 where the characters in A4:H29 meet a

I am trying to use a vlookup formula based on 4 criteria, in order to return
a name value, not numeric.  On one worksheet I have several interviews set up.
Column A=Date, Column B=Time, Column C=Recruiter, Column D=Interview slot
number (they have up to 12 people scheduled at one ...

Is there a way to rotate info from a range for example:
10 134 - 1205 2.72 CELL1 FALSE FALSE
10 134 - 1402 0.12 CELL1 FALSE FALSE
into a single row where the info from above will display as follow

I'm having problems with finding the right formula.  I've been using a
countif to find the count of invoices which start with a 4.  I've not been
having much luck so any help would be greatly appreicated.
Below is my sample data and formula I've been using: