I started out with =VLOOKUP(F12,CSSP!A10:F2000,4,FALSE) the output returns #NA if there is nothing found The following statement works great if there is an...

MS used to have a "xlreader.*" so that a user that does not have EXEL can read spreadsheets, etc from EXEL. This is not avail. from MS now. Any solutions? John

When I try to create a custom list using text cells and accounting formated ($99.99) cells, I get an error message that cells without simple text will...

How do I collapse duplicate records and place a drop down list with the values in the fields causing duplicate records in my spreadsheet?

Is there a way to report negative "time". Example: I paid my employee 80:00:00 hours estimate (cell a1). He actually worked 72:00:00 hours (cell a2). He...

How do I randomly select cells in Excel?

I am using a checkbox in Excel. I can control the font size, but cannot seem to find a way to actually make the checkbox itself bigger

Hi, Can I copy data from word and paste into excel. I have tryed with no success. I have data in a table in word and now I have made a spreadsheet for it and...

Recently lost the ability to set traditional print parameters within the Excel 'Print Preview' panel. The "Settings..." button is still there...

how do i add the ILX menu in Excel?

I have a problem when I open certain spreadsheets that are on a server. My laptop slows to a crawl. I don't think it's an Excel problem, I think it may be more...

how do you add a zero in front of other numbers, I am using item numbers and most start with zero, just shows whole numbers when I enter. example 095421 when...

I am making a training schedule, and I need a bit of help. In each workbook, I have 12 sheets 1 for each month. Let’s say Joe is up for retraining on March...

how can i factorise numbers on excel e.g. get all the factors of the number i input?

We have an Excel file that has been linked for years to pick up numbers from a Lotus file. Now that one person who uses Lotus updated to version 9, I'm told,...

I am using a spreadsheet that contains a list of hours worked. I need to apportion the hours worked to a restricted number of hours. For example: I have 2, 5,...

I have a long Word document that needs to be converted to an Excel document. I hope it can be done. Is there way, and if so, please let me have...

in a machine with all office updates and xp sp2, when using excell (2000) if you move from cell to cell either to edit data or just to format a group of cells...

Is it possible somehow to use variable table array names in VLookup or HLookup? I would like to create a drop down list of tables, then use the look-up...

I have a server with several users that will access to the files on a "Read Only Basis" and one and only one user cand write the files (modify) Can this be...