I need to alter my code for redistributing cells in column "c" to be equal. I am using Excel2000 V9.0 The main purpose of this form is to count how many...

In an earlier post I disagreed with the observation that RAND() in XL2003 can give negative numbers. I retract this statement - there is a bug. In a sheet with...

Help! I'm using excel and the dget function to lookup product pricing data. The problem is that the pricing data is now 75 colums by 1,700 rows and I expect...

Hi, Pls help me to change the date format of the dates in my file. Whatever I do, the date still shows, 37803, while the formula bar shows the correct date as...

Dear sir, I gave hide command to one of my folder in word and now iam trying to open it and its not opening what should i do and please give me instruction...

I am using Excel for word lists. Using one workbook, the first worksheet within is the 'Master' index. Subsequent worksheets will contain words divided into...

Why can't you import a word document into an excel spreadsheet in office XP? You could do it in earlier versions.

Excel's help wrote: TBILLEQ is calculated as TBILLEQ = (365 x rate)/(360-(rate x DSM)), where DSM is the number of days between settlement and maturity...

Hello I have several columns of data all of which start in row 7. In rows 1 - 6 I have summary statistics for each column of data, e.g. min, max, mean, std...

I used the PX() function as suggested by Don in another posting, but when I continued to insert more sheets then went back to recalc the formula in the cell,...

I am trying to merge two different workbooks. I have Office2K. According to the help it said to: Open the copy of the shared workbook into which you want to...

Hi, Please bear with me as this post may be long. Any help with this problem is greatly appreciated. Using Excel97. I have a workbook where each sheet is a...

"chigins" wrote... Here is what I am trying to do. I have a list of room #s. I want to count all the unique room #'s...

Assuming "j" represents 0: =SUBSTITUTE(A1,RIGHT(A1,1),MATCH(RIGHT(A1,1),{"j";"a";"b";"c";"d";"e";"f";"g ";"h";"i"},0)-1)/100 should translate the contents of...

Joseph you could type the list in or on the worksheet range enter numbers with a apostrophe first '2 '4 '7 etc either way is tedious if the list is very...

Hi I would like to retreive the ALIAS ID defined for a email id into a EXCEL cell. Is there a way to do this? If yes, please let me know the steps for the...

How do i direct the user to enter certain cells after a certain data from a drop down list is chosen? I want to make it such that unless the respective option...

Can anyone help me with the following problem? I have a dropdown list, e.g. with 4 options. Each option is represented by a row of data below the cell with...

If you have a text column in a table that is used in a pivot table, is there any way to get it in a pivot table? Andrew

I have figured out how to add a check box to an excel worksheet, and I have figured out how to link the box to another cell. I need to add check boxes next to...