How do I calcualte histogram of yearly dataset and compute the probability of distribution of the data. For example: Year Value 1920 311.9 1921 ...

Using office 2003. I have created a pivot table from data in excel with many columns. The data in the comments column cuts off after 254 characters (with...

I have a list of email address that are separated by the symbol. I want to separte each address to its own row

When I do a paste link of cells that are formatted as a Date field the paste link cells display 1/0/1900 as the data. I want the "to" cells to be blank until...

Been racking my brain on this one and I don't know why it hasn't worked. I'm using the Find method in my VBA query to find cells that contain the value...

My worksheet that was created by someone not here anymore has over 2500 pages. At the end of the worksheet in a cell is a little blue symbol in the bottom...

I have a worksheet in Excel there is a column titled Grade, and and another column titled car allowance, I want to give the employee with grade D only BD 100,...

I receive data daily with dates in the following formats: dd/mm/yyyy, d/m/yyyy,d/mm/yyyyy, or dd/m/yyyy... The values actually are text vs. numbers. ...

Hi Frank, Thanks for input. I've used this Formula referencing the cells with the A1-Style and works ok. Can you explain the use of =1 in this...

I have two worksheets that list, among other information, product codes. These product codes are all 10 characters long, but some are entirely numeric (i.e....

I am using this CF to find my duplicates =COUNTIF(A1:A$10000,A1)1. The next part I need is to count the number of duplicates (gray shaded & strikethough). I...

I'm getting #DIV/0! with the following formula, the cell is format as a percent. Thanks =(E34-D34)/E34 E34 = 0 D34 = 0 Result should be 0%

Hello: The client has a dual monitor. And, we have a 3rd-party Excel Add-In that "pushes" data into our accounting system from this excel spreadsheet with a...

Hello, Does anyone know why the "$" command will not work in formulas when running VISTA? Does anyone have a solution? A simple version of my problem...

OK, so I started the experiment and soon got pulled up. I'm saving my .xls file as a binary .xlsb, and the darned thing wants to put an underscore in front...

I posted this in this group on saturday. The first half is my question. The 2nd half is the response. My question today... What do I do with it. I think...

i need to hightlight a cell when i have one birthday in my list

Hello everyone, I am trying to sort a list of temperatures to analyze a chillers operation. The chiller turns on when the outside air temperature is 80, and...

Hi, I'm really struggling with what I thought should be easy. A B C D branch salesperson ...

Is there any reason my mouse won't scroll in Excel? How do I fix this?