I need to set a data range for a chart to: =INDIRECT(Data!$F$25) The value of the cell F25 in sheet 'Data' is - D6:D17 My bar chart give me an error when I...

I'm trying to create a formula that will subtract two cells if the second cell is greater than zero. I can't find this anywhere and can't imagine Microsoft...

Dear experts, I have 2 workbooks (say A and B). Workbook B contains a range of data, and I would like to lookup 1 value (say cell A1) from workbook A so that I...

if i hv a file with the following data A B C D E no# name xx time others ... .. .. .. .. As i keep on entering the data into different...

Ben I would combine all 5 worksheets into a sixth worksheet, and then save this sheet as a csv file. I if you do have problems you can always open the...

Hi, I have problem with count all item1(column B) with value 1 (column A) and give result in cell "C1" How describe function without any filter. A B 1 ...

I need to unmerge and merge cells within my spreadsheet and the tool button for merging/unmerging is greyed out and I cannot select it.....why? How do I...

Dear experts, I want to create a form template with a form number. This number should be unique and never reuse again. For example, the starting number is...

Help!!! in the past, Excel has always automatically updated formulas when the values in their cell references changed. as i am working on excel tonight, i...

I have to come up with a count of numbers which fall into certain ranges: 0 - 1.0, 1.1-4.0, 4.0. Short of sorting by that field and manually counting, how...

Hello, first let me insert the basic framework of my excel sheet: A: B: C: D: E: F: G: H: I: J: 1: 101 105 ...

I posted this question earlier but I did a poor job of explaining my situation. Thank you Aladin for your answer but I did not really understand it. Please...

Has anyone written a formula to calculate the check digit for a 13 character EAN code from the leading 12 characters? (The 13th is the chaeck digit.)

I am trying to import a text file in which the first column is a 10-digit number. This number has a leading zero. When it is imported into Excel the leading...

For some reason, my arrow keys are now scrolling the entire sheet instead of moving from cell to cell. How do I reset them so they move cell to...

Hi I have been here before and the help was great. OK What I need to do is have a formula which transfers scores. I have a main league with 42 people on it...

I am trying to find a the smallest number that is greater than 0. I used the following: =MIN(IF(B5:W50, B5:W5)) But I am getting an error #VALUE! What am...

The LEN function counts characters, however, I am not aware of a function to count words. Looks like you get to VB. -Jesse "Jon Capuchino"...

I am working w/ the code below to take selected worksheets and save them as individual workbooks. I now would like to modify the code to always select...

Hi there, About a year ago I found in the Internet a tutorial on how to create a formula that would detect some of cell formats. It used some long and complex...