I have a file that was not originally protected and for some reason now is. I tried to unprotect, however, it is greyed out. This workbook has macros as...

how to convert a numeric value in text

I have a problem with Customize List in Excel. I want to delete or edit Customize List in Option window in Excel. But the Delete button is not visible. At...

I have a number of worksheets that employ the same macro and on occasions I need to update the information with the macro. To stop having to repeat the...

I have a column of 722 numbers and I want to add them but when I click the sum function and select all the cells it returns with a 0. I have made sure they...

WinXP Excel 2k3 I have a pivot and I'm building a matrix. I want to count how many records in the pivot fit within the range given in my matrix...

Is there a way to return the date of a particular day after a date, i.e. my work month always starts on the 26th, but the week ends on sunday. I would like...

Ok I have seven unique text items in two columns and need a formula that will give me all the possible combinations in a list. The columns are as...

I have 7 games and 10 players, each player will need to bring a snack or drink to a game, how can I do this equally as possible?

is it possible to swap cells without having to cut and paste? if i have data in b3:b5 and c3:c5, and i want the data in each column to switch, is there a...

Hello - Does anyone know if there is a limit to the number of nested subtotals Excel will display when the the details are hidden? I have a spreadsheet that...

I need a formula to calculate employee vacation time from number of days worked. ex. after one year each employee receives 40 hour or 5 days of vacation...

Hi there I need a If statement to Extract data in a worsheet array column B IF COLUMN A IN THAT Worksheet meets a certain condition else the if statement...

I would like to avoid using two cells to represent the following: 2017 TOTAL PPs. (all in one cell) I would like to use only the number part of the cell...

Hi, I#m looking for a Formula that returns me the Value of a specific day of a month. Example: Colum A Dates Colum B Values. Now I need the Average Value for...

j --

When I take Auto Sum option it returns #REF instead of totals. Worksheet integrity seems to be fine.

I am trying to create a macro that will perform the same function on different tabs in a workbook, but whenever i try to run the macro for various tabs, the...

I need a button, that when selected, will cause the total in another cell to increase by a given number associated with the button.

I lost my pass word for my excel worksRandy Jettheet, How can I change it?