I need to have it look at one cell at a time, but link 20 cells in the formula. It is supposed to count the number cells that contain an X. I can't use the...

I'm working on a spreadsheet for sports and want to rank certain stats from 1 to 20, to include a 'T' if there is a tie betwen scores. Example: 1, T 2, T 2, 4...

Duke Carey wrote: You ought to receive input from some of the sharper advisors here, but for the meantime I'd suggest you use a custom function like the one...

Hello, at first place I would like to say I don´t have very good skill in excel, so if my question is stupid, please be kind on me ;) I need to create some...

I am trying to use functions to create a list of data on one sheet by replacing the data in a single cell many times on another sheet. Can this be done using...

Hello all, Is there a way to have a formula and text within the same cell? This is what I want to do: Date: =TODAY()

Is there a way to use the COUNTIF function with 2 conditions? Right now I have the function: *COUNTIF(F11:F502,"Amisys")* which works fine. I want...

Is this doable? I have a table with vertical values jan,feb,mar,apr,may,jun. I want to dynamicaly SUM values from-to ie: Rangee of the table with data is :...

I have a date and want to know in what period this is. Reference ranges: period begin end jan 1/1/2008 14/1/2008 feb 15/1/2008 ...

I´m able to find a specific phrase in a string. But when this is a number the result is still a text cel. What is the worksheet function I can use to...

Original post from kydan47 on Fri, Jul 21 2006 7:03 am Could not respond to this post because it is too old and has been closed. I have the same problem...

I am trying to Sum a Year to date range based on a month reference. Ideas? Sheet 1: Jan05 Feb05 Mar05 12345 12 34 56 67890 ...

why is it that when i tried to change my excel settings... using tools-options... im getting an error... and excel will shut down... please help TIA

I am trying to find the difference between a cell on sheet 1 and a cell on sheet 2. I want the answer to appear on sheet 3. However, when I enter = and...

What kind of formula should I use if trying to report "yes or "" for cells G10, G11, G12 and G13 if the date is 4 months past todays date? --...

Please provide any help you can... I am working on a spreadsheet that identifies due dates including year and reports back yes if the criteria is met. I have...

Hi Expert, Can somebody help me with this code. I got excel file always ask for automactic update links. If I disable at the microsoft excel at...

I am new to this forum and I really hope someone can help. I have a spreadsheet with a colum that has tons of fractions that look like this(22/8, 45/6, 313/9,...

Lotus 123 have a function called "rvbalance" where the calculations occur until result = 0 for example. I can't find where excel does this, does anyone know?...

I am making a sample inspection database and I want to assign random numbers to a series of cells. When I make a change or open the spreadsheet, the numbers...