I have a spreadsheet: Price Status 100 120 Sold 115 Sold 130 140 Sold Now I try to find the seocnd larges amout something is sold for. I

I have a list of data in coloumns A and B. I need to write a countif style formula for if column A has one set of data in it while at the same time column B...

I have the following: 1 Jan 2007 , -10000 1 Jan 2008 , 2000 I get XIRR as -80%. I understand that. If I have the following: 1 Jan 2007 , -10000 1 Feb 2007,...

Hi I want to be able to have two drop down lists using the data below. If I select Dog, the second list must present me with Meat and Bones. If I select...

COUNTBLANK function works Ok for cells A1:A10, but what if the number of cells grow to A1:A100 or beyond? How can I make the fofmula adjust automaticlly?

hi i think your have loaded your form as modal meaning that no other actions can be perform until the form is closed. if you want the form to remain open...

Hello, I have created a workbook, including many worksheets for each month of the year. The first row of each worksheet indicates the days of the month. The...

Column A is either blank or has a date Column B has a date Coumn C has a person's name I want return the person's name if Column D column A is blank or...

You can add 'Format Cells: Alignment' as a butoon on the Qucik Access Toolbar. You will then have to click on it and press Alt-K... not much of a...

Currently when I highlight a column or a row, the color of the highlighted column/row doesn't change to a darker shade so that I can tell from where to where...

How can a pivot table refresh data automatically while the file is open and the data is changed without me having to hit the refresh data button?

Is there a way with pivottable in Excel 2007 to add the rank within each group? I have table with location and products going down and Dollars and Units...

INTRARE COD Marime Intrate Price Ramase 12/2/09 8167 44-46 10 57.68 lei 5 21/1/09 8167 44-46 10 58.08 lei 10 7/1/09 8167 44-46 10 54.85 lei 10 formula IS:...

I have gotten a new computer and had all my programs and documents etc copied over to it. For some reason, in excel, all my date formats were changed from...

I have an error-checking formula in a spreadsheet: "If(Sum(A1:A30)D1,"ERROR","Balanced"), where A1:A30 are values that are entered from a source document,...

How can I rand numbers from triangular distribution? Thanks, Yaarit

Hi, I have an excel spreadsheet that contains info on referrals; date received, area received, client file number etc. I need to figure out how to track...

Hello, I have an advanced filtered sheet that has criteria in two adjacent columns for the following criteria: *pharm* *drug* *rx* *script* The filter...

Hi: Can I split a cell with text, then a formula, then with more text? If so how?

I need help creating a question sheet. I have a question follwed by a drop down list for the answer. What I need to do is have the spreadsheet return a range...