Hoping someone can help. I have a sheet that has 12 months of data going across 12 columns. Each column has a heading for each month i.e 1, 2 ,3 ... There...

How do I determine the ticket price for an event? Do I set up the worksheet like a budget? Is there a formula that I would use?

Hi, I'm having trouble with the syntax for a logical function. Given, in A, B and C: 1 h f 2 b a 4 c e 2 f 9 e

How do you center information on the spreadsheet? How do you add a sheet to your document ( I have 3 sheets at bottom but need additional ones)?

i need a formula that will look up a word then give me the numbers in a cell next to that word. the formula i'm using (which isn't working right)...

I know, this is kinda cheesy, but seems to work - I'm just missing the right criteria. I have a column of data that continues to grow, so I need to sum the...

I have a spreadsheet with 5 tabs. Each sheet in the tab has 4 columns (A, B, C, D) Sheet 1, Sheet 2, Sheet 3, Sheet 4 and Sheet 5. Each sheet pertains to...

I have two columns of text which I have concatenated but I need the results to be text not just the results. I have tried copying the column to another...

I have a worksheet sent to me with over 700 names on it. I need to put 4 extra lines under each name. Is there a way to do this without having to...

Hi, I want to be able to select the month from the drop down list and once the month is selected, I want the first date cell to change itself to the...

I am trying to use sumifs to gather information if one of two tests are true. I would like to be able to make a purchase apear as executed if Employee 1...

I am new in Excel 2007. In Excel 97' there was an option or using special graphs which allowed you to have dual Y-Axis. You could then graph both $ and %...

I am trying to place a combobox in a spreadsheet (Excel 2002) but no down arrow appears only a line on the right side of the box. I have linked a cell and...

Can some one please tell me how to format time exported from Avaya IQ. example time exported 00:01:23 I need to format to only read 1:23 in excel 2007. Thank...

It's a logical test rather than a calculation. The example I gave didn't make much sense, but the scenario is that there is a range of products, which can...

Hi all, Hope you are all well. To boost staff morale at my work, I am trying to come up with a World Cup 2010 Predictions Competition. I have 3 worksheets...

for example : in excel i have mention 25000.00 in numerical amount , i want to know how can i convert in next colum , about word ?/; How can i put formula to...

keep first columns showing as i scroll down the page?

I'm having problems getting an array formula like this to work: =SUM(INDEX(Data_Table,Row_Index_List,Col_Index_List)) Basically, I have two columns of numbers...