Hi I've got a PDL that has 2000 names on it and I need to update it. I have a list of names in excel which is the latest informaion that I need to compare...

I need to calculate text for each letter, it is possible for using for numerlogy name calculation. for expl: Joy +1+7+1=9 j...

I would like to make changes in excel options, to select 'set precision as displayed' which i can do in each time, but i want this option selected for each...

I have over 4000 entries as the prd code & need to enter them on a worksheet. By using DATA VALIDATION is there a feature to shortlist the list when typing...

Excel2003 ... I wish to setup a Pivot which has Several Orders. Is it possible to drag ALL Orders from the Pivot Table Field List to the "Drop Data Items...

A B C DATE 1 Supplier DATE 2 12-Nov BTT 10-Nov 12-Nov BCT 11-Nov 13-Nov BTT 12-Nov 11-Nov BLL ...

I have a fairly simple spreadsheet in Excel 2007. As data is entered into a new row, some of the formulas from the previous row automatically extend into...

I need to come up with a formula that will result in Good or Busted The racers speed must be within 1.25% (+ or -) of the speed entered into the equation...

Syntax seems right but I get a #value result. Am i right to assume date arent usable?

I would like to have a box pop-up to alert me when two numbers in my spreadsheet do not match. Can somebody please let me know how this is done? If that is...

I have a spreadsheet in Excel which contains a very long list of clients (30,000 or so). I have them sorted alphabetically, but I would like to be able to...

The following IF function works in Excel, but when I copy it into VBA so I can excute it in a range it will not work. Range("p6:p40").Formula =...

Using the Template Wizard Add-in, I have created a form/template and have successfully sent inputs to an excel database. Is it possible to retrieve data from...

I have about 8 files that have links between themselves. Not always, but most of the time if I have more than one of them open, when I go to save one, the...

I write to inquire if there is an efficient way to get stock values into excel 2007? Additionally, I would like to be able to get dividends into the same...

How can I get min/max of a single cell reference from up to 50 worksheets in a single workbook?

I am now using Excel 2007. What file format should I use for my Excel 2003 documents? How do get that file format? Thank you.

Is there a way to have an underline (single accounting) in an empty cell? -- MarcB

I'm trying to sort a column that contains both text and numbers so that the numbers appear in order instead of 1,10,11,12,19,20,21, etc. I can't use...

All nums are text nums In A1:A3 would be 3 "winning" 4-digit text numbers, eg: 0044 1234 4233 In C1 down will be input 4 digit text nums such as: