I am using Excel 2000 and wish to password protect my file. When I go to Tools, then Options, there is no option listed for password protection. When I click...

Hi all, I am working on a spreadsheet that is a little over 10000 lines long. Several columns seem to not have any data, but I am reluctant to just...

I have created drop-down lists in an Excel spreadsheet. When I do the print preview, there are extra sheets that seem to hold the drop-down formatting. I...

I wrote this fomula in a cell in the workbook book5 =SUMPRODUCT(Sheet1!$A$2:$A$16=A2)*Sheet1!$B$2:$B$16 the result of the formula is 0(not #value) Does it ...

Hi, I am looking to find a function that can assign a set of random values to a column. For example if I have a list of names I want the spreadsheet to be...

I have data extracted from a database in the following format: Leads: Date Created Opportunities: Last Modified 1/5/2006 16:19 1/10/2006 16:25 I need to isert...

Supervisor Sun Adam S Mower 11:00-16:00 Adam S Mower 11:00-19:30 Adam S Mower Off Adam S Mower 8:30-13:30 Candice S Carter Off Candice S Carter Off Candice S...

I want to set up a formula to count certain items in a row based on what the content is. So, if the cell contains an "x" count it as 1, if it contains an "e"...

hi.i ve got a data table where rows are width and columns are hight. how do i get data from the cell that matches ceartin column and row,? I use vlookup, or...

I am trying to round down a number to the next whole number. Example 9.2 would round down to 9, 6.0 would round down to 5.0

I have several columns of numbers - some numbers have leading zeros. When I concatinate the data the leading zero drops off even if I customize the...

hi all! is there any way to combine the data in two cells (row-wise) in xl? for example A1 - date; A2 - narration (text); A3 - amount B1 - blank; B2 -...

In list1 there is many phonenumbers. In list2 there is also many phonenumbers. I want to remove every phonenumbers that is in list2 from list1.

Hi all I have a large worksheet and one column contains a code consisting of two letters. The two letters represent the name of a particular...

I need to sum values in a list that match other values and know that this can be done via the SUMIF function. However I also need to split the values based on...

hi! i am having dates in A1,A4,A7,A10. i want to fill up A2 & A3 with date in A1, A5 & A6 with date in A4...so on! is there any formula for filling up data in...

Hi, I have an excel sheet which contains lot of data. And I am creating a new sheet with only selected columns from the former sheet. When I do that it...

Hi, I've got a worksheet that summarizes customer, date, and contract number (over 9000 rows). I can get subtotals by using the Subtotal function of Excel....

Hello, The first chart below shows dates and clock in time and clock out times (formatted as time). Production In Production Out December 09,...

I have a long pricelist of items that I offer for wholesale. There are over 5000 items and the prices were just recent raised. I want each item to reflect the...