How would I go about returning the sum of the QTY column for each unique date. (You will notice that there are some rows with duplicate dates.) This data...

Hi everybody, I am working with Excel XP. I have a database with 2000 records and dbase formulas (mainly dsum) to calculate results in date ranges. The...

I applied the ACCRINT formula to a security with maturity: 09 Feb 2010 issue: 09 Feb 2005 (adjusted to exclude coupons already paid) first interest: 09 Feb...

I'm trying to format rows in my spreadsheet based on the values existing in two cells on that row. If the date is before today, and there is no entry...

i need to find a list of excel formulas and there different functions within a worksheet

There is a template in Excell for to do list for Projects. In this workbook one can check off each item as completed by typing a letter in the column and a...

Why do I get different values for the same arrays when I run CORREL and ad r-squared value to a scatter plot?

I would like data to be displayed in a different cell. e.g. formula would be in a cell in sheet2, but saying something like, if sheet1 A10, then print the...

J'utilisais Excel et Ã* un moment, je changeais des données dans une page de calcul, je me suis rendu compte qu'il n'actualisait plus le résultat...

I would like to move several rows from one part of work page to another. How do I do this without having to create new rows where I want this text? I have...

Hi I want to create a combo box and I want it to list values from a specific column. I'm making a price list so that I can use a filter process to get the...

Hello! I have a very large spreadsheet and I need to search it for a duplicate invoice numbers. I am entering invoice numbers in the first seven columns. ...

i need a formula to place in my spreadsheet that provides the following: If a number is or a value, then place an alpha character in the cell. I am a...

I have a main spreadsheet with columns as follow: A C AT Product ID Group TOTAL BBB TOP ...

I am creatng an Excel document. I have created the first row #1 with the info that will follow below in each cell. As I get to the additional pages I want to...

How do I set the IF function to do a "not equal to" or "does not equal" or something similar? As opposed to =, , , =, =.

Hello you techies out there. I have been asked to explain the following - can anybody make clear to me so I acn in turn explain to others. Thank you. =IF('TL...

I run a fantasy racing league with some friends. I am trying to find out how to return a previous cell's value, such as a player's rank from last week. I am...

I have many sheets in an excell spreadsheet that I need to sort in alphabetical order how do I do it?

My spreadsheet contains the days of the month & I need the last value entered to display in a cell. ( not the total but the actual last value entered). Thanks...