Why in a column do I get a (0) result from a formula in one cell in the column and get a - for a result in the same column, different row with the same...

I want to hide all the equations which I wrote, and it is allowed when you enter the right password.

I have a spreadsheet that has a formatted cell for todays date. What I need is a formula that looks to see if it is Sunday thru Thursday or Friday and...

I would like to combine two different Excel files into a new 3rd file. It's important that each row is in sync with a reference cell. Each of the original...

I recorded temperatures every 15 minutes for four months, and I need to use the minimum daily temperatures for statistical calculations. I used the...

While attempting to access an Open XML format based spreadsheet we get the error message: “Microsoft Excel has encountered a problem and needs to close. We...

I have a workbook that has different classifications based on a dates (Classifications = Red, Green, Yellow). On the cumulative sheet I have all and then I...

I have formatted a column to text. Currently in the column is a list copy and pasted from MAS 500. Contents of each cell look something like this: ...

How do I pass values from one textbox from the 1st tab to the 2nd tab? For example: me.textbox1 is on the 1st tab and has a value of 1234. On the 2nd tab...

I have a spreadsheet with 2 pivot tables side by side. One pivot table is created using data from cash application and the other pivot table is from bank...

I want filter column, means all headings are in coumn A1: A20 and Datas are in column B1:D20, Now I want to filter the the datas from left to right according...

I have a form in one spreadsheet and data in another, how can i perform a "mail merge" to get the data to go in the correct fields in the form? --...

how can i change the format of a highlighted range? when i select a range of cells i want them to show up as highlighted while they are selected. right now...

i want the space between word, i used the following VB Code, But its not work. When i run the VB code, i get word seperated from number, but there is no...

How can I display the content of merged cells in the adiacent empty cells? e.g. if I put some long unwrapped text in A1 I can see it in A2 and A3,as long as...

Hello. I have a SS that has different accounts. I have a COUNTIF working against a column that puts together 3 aspects of the accounts that need to be...

I am creating a spreadsheet to import values into my accounting software. The first row is the product name (actually a reference to another worksheet ...

Is there a way to do this via VBA or formula? I want to show the values that are added instead of the cell references. Let's say I want to Add use a cell to...

I have put some serious hours into to trying to make this invoice template work with Office 2007 and Windows 7. It came originally with Office 97 and Office...

Hello- Any advice for best practices for protecting data/methods/macros within Excel? Clearly, password protecting a sheet isn't the best security (free...