I received a spreadsheet from a customer with a lot of cell comments. It is difficult to read and see the comments. Is there a way to highlight the column...

I am a teacher and trying to make a bingo card with Excel. I am trying to make a list of scientific elements and let the computer randomly input them into the...

Thanks for taking the time to read my question. I am just learning how to use Array formulas in Excel. I can Sum, Count etc. I am wondering if you can...

Hi, I've a number of sheets. The 1st cell in the C column is blank on all the sheets except one. The same is true for the next cell, except the value may be...

Hi all, I have a date currently as text format "2000/Jan" and so forth. I wish to convert this to a date format as "Jan-2000" is there a way to accomplish this...

I am creating a report where the end user will select a provider. Once the provider is selected, it will look at 1) Provider 2) Month 2) Charges and go to the...

Hello from Steved How can I please combine the below Formulas into...

Hello, I am trying to write a formula to do the following: Sum the contents of a row for a specific "week" and a specific Category "Machine 1" So, if I...

how do i compare a Cell A1 in Worksheet 1 to the whole Column B in Worksheet 2 to see if part of any of the contents in Cell A are anywhere in the list...

Hi there, I work in accounting and we're trying to tie numbers very often. I would like to know of a possible function or code that can output all...

My spreadsheet has a few cells that I have locked. However when I click on protection - the only option available to me is to protect a shared worksheet. ...

I am trying to create a module/procedure code which would let me fill missing fields in Excel based on the values that are above and below it. (That is realy...

I need a formula that will count the number of occurances a month/year occur. I have a column with dates mm/dd/yy. I have another column with mm/yy...

In excel 2003 when sorting a large column of numbers, over a few hundred, they all sort properly except the top one or two. How can I avoid this or rectify it?

Im trying to get my date to automatically update to when the next payment would be due...im using excel 2003 any help would be great!

I have a single cell that can contain up to 41 different text strings that are like this: -text/text/Above 1/text- where I can have Above 1, Below 1 or...

Good afternoon, I'm looking to seperate inventory items into PRIME and SUB units.. Example: Sodas have are in cases of 24 so the PRIME unit would be 1....

Hi, I am trying to write a condition if one cell meets the condition (Example H5 = OPEN) then turn cells H1 through O1 to red (Color fill) If H5 = Closed then...

I have to calculate a monthly payment based on avariable interest rate. What is the formula I use, ex. variable rate in is A6, loan term B6, and payment C6?

How would I reference the content of a cell instead of the result? Example: A1: =IF(1,2,0) (Result is 2 formatted as number) A2: ???? (Result is "=IF(1,2,0)"...