Hi I have struggling with one part of my macro. Basically, I have a row of cells with names. Alex, John, Martha, Jim, etc. Each person has a list of data...

How do you convert a flat rate of interest into an annual reducing rate?

Good Morning, I have a listing in Excel where I have a field that should only contain dates using number characters. The issue is that if part of the date...

Hi! I have a pivot table. In the actual table the data is shown as number of occurences. Also the automatically created colmn and row "Total" shows the total...

I have spreadsheet with 5 columns for weekly closing stock and a month to date total. I want the total column to pick up the last weeks closing stock. What...

Hi, I am struggling to make a formulae to sum based on other criteria. I have the following formaulae that has been...

Once again thanks for all the previous help from these forum. Here my problem is i need to lookup up multiple values existing in a sheet and copy them in to...

Hi, I have a formula that works out the average of four miles per gallon figures. =AVERAGE(G2,J2,M2,P2) Basically I am going to automate the values in those...

I can insert a formula like this into lookup and other functions and they work fine but when trying to insert into a reference, it will allow $B:C(row()-1)...

In June 2008, I added a government spreadsheet to a previously created workbook in 2003 Excel, which now I am using Excel 2007. So now when I try to email...

I have tried over and over to put in the formula to return multiple values. I have spent the last several hours trying to figure this one out, and I am at...

I'm trying to use the LOOKUP function to search a LOOKUP VECTOR that is not in ascending order. Putting the values in ascending order is not an option. Is...

I am trying to COUNTA rows of 7 cells that contain data. i do not want the cells counted if they meet one or more conditions. For example: count non blank...

I am trying to set up a worksheet to tally the number of actual attendance/number of possible sessions to attend. I want to keep the two numbers in one box....

I am trying to use the INDEX and MATCH functions based on a calculated value. =INDEX(Scoring!G11:H50,MATCH(C3,Scoring!H11:H50,0),1) Cell C3 is a calculated...

Hi All, Having a little problem getting this indirect to work. =SUM(INDIRECT("RC:RC",FALSE)) Where I am aiming to sum the current Row from column 37 to...

Hello, Here is what I want to do: I have a table of two rows: one row for the months of the year, the second one with values. Each month has 3 columns, the...

How do you know when to use ctrl+shift+enter to create an array formula vs just hitting enter?

NOTE: I posted this question in general questions (I'm not familiar with the website). Please before answering check if someone alreadyhelp me over...

I'm doing a VLOOKUP using FALSE and when it does not find the value I'm searching for it either returns an #N/A or it returns blank. I thought it was...