I am attempting to count the number of times a phrase occurs in a column, but this column has reasons in a phrase dropdown list form (generated from a hidden...

I may not know the correct terms but I am adding columns to a spreadsheet already built. There are vertical and horizontal formulas and it appears that...

I created this formula, but it is not working. =SUMPRODUCT(--($AX$4:$AX$7312000)+--+($BA$4:$BA$73125), --($BA$4:$BA$73200))*($AX$4:$AX$73) The column AX has...

How can excel be used to do a spectral decomposition on data?

Hi, This may sound like the easiest question, but believe me its not. I'm strugling with it for quite some time now. Let me explain what is that I want. I...

Our quarter runs September through November, I need to count the number of Tuesdays, Wednesdays etc., remaining in the quarter. I've come close by digging...

I want to sort a worksheet which has date entered in UK Format ie dd.mm.yy

I have a long blurb that I need to show up at the bottom of every page, anyone figure out if there's a way to do that? -- martinson portland

Question - I have a pull down menu in Cell T. I want excel to copy Cell T to Cell U when I double click on Cell T after selecting something from the pull...

I've been working on a formula for adding expenses using multiple criteria for about nine hours now, and I would realy appreciate some help! Here's my...

Column C Column D Column E $42,368.96 Jack Smith $153,550.00 Michelle Fuerth Above, I have the total sales in Column C and D, with each...

I have conditional formating & color in a cell, but I want to color the entire row of conditional formating cell. Is there any option to do it ?

Can anyone help A B C 1 John 01/10/07 Yes 2 John 01/10/07 Yes 3 John ...

I am trying to create a macro (attached to a transparent rectangle in cell A) that will copy contents of cell B to Cell C and paste as a value. Problem I...

Can anyone tell me whether there is a way to count up the number of cells in a column that contain a specific word but only if there is a specific word in...

Hello everybody. I maintain our school data in exce. The following is marks data NO Sec English maths Science Social 1A1 1A 25 25 25 25...

Hi! ;) When subtotals have been created in an excel file - when viewing the formula in the address bar what does the "9" stand for: =SUBTOTAL(9,H2:H23) --...

We only charge for a meal tray served if the number is over three per month; if they only get three, no charge, if they get four, we charge for one, five, we...

Good morning to all: I have a spreadsheet S1 where a cell B1 contains the value "MN" and a cell A2 contains the value "AB" I have a spreadsheet S2 where I...