I have a very large spreadsheet that contains a column of amounts representing dollars and cents, another column which multiplies that column by a percentage...

I know the formula to input the numbers in to calculate the monthly payment of a loan if given the interest rate, term and loan amount. But for the life of me,...

When using the VLookup function, I am using "FALSE" as the argument, for the "range_lookup" argument, because I only want an exact match; however, it returns...

Try this, In a separate new column (column D) insert the...

Hi, I am trying to change date format from dd/mm/yy to mm/dd/yy but am unable to do so, unless I do it manually. I am following : format menu -- cells.. --...

I am trying to categorize some of my data by time segments i.e. 6PM-12AM = EVENING 12AM-6AM = NIGHT 6AM-12PM = MORNING 12PM-6PM = AFTERNOON Column A would...

How can I use a function to remove spaces from a string. Before Smith , Bob After Smith,Bob Thanks,

Hi, I'm trying to use a LOOKUP function, to lookup values in another worksheet (same Excel file). The data being used for the lookup has a worksheet name of...

I currently linked worksheet 1 to a hidden and protected worksheet 2. Wksht 1 allows the user to select from a list of categories using a drop-down menu I...

I have a spreadsheet to maintain truck weights. If the weighmaster enters a Gross, and a Secondary Gross, the spreadsheet should calculate the amount of...

Hello, I've been puzzling on this one for a whle now and can't seem to come up with a solution that works for all cases. Would be grateful if anyone can...

I have an excel workbook. Workbook contains say 6 sheets. Each sheet contains information of my time sheet for that particular day. I have named each sheet...

I have used the INDIRECT formula many times on a particular spreadsheet. ie B1: D A1=2 C1= INDIRECT(B1&A1) A2=2 C2= INDIRECT(B1&A2) A3=3 C3=...

Basically, I am trying to take financial figures from three spread sheets and to put them into another sheet that is a finacial report. I have a file with...

Is there any way to use lookup formulas to have Excel find ALL of the values associated with the lookup parameter and somehow list them out? Here's an...

I WOULD LIKE TO BE ABLE TO TYPE IN A 6 DIGIT NO. EG 010101 AND IT BE CHANGED TO THIS 01/01/01 IS THIS POSSIBLE AND IF SO COULD SOMEONE EXPLAIN IT TO ME SIMPLY...

In a workeet with multiple tabs, how do you reference a tab via formula. Ex. with typed array=index(tab1,2,3) Column A(array or tab) Column B tab2 ...

I have the days of the month in row 2, starting in column A, i.e. March-1, March-2, March-3, etc. These will change according to which month it is, and so the...

Anyone? I'm getting lonely!!!!! 8) Andy "Andy Sandford" wrote in message ... Hi...

My spreadsheet is adding 2 two digit numbers and coming up with 15th digit place answer. It happens throughout the spreadsheet where ever it wants to. Does...