PHYZX 5.26 5.29 5.31 5.33 5.33 5.33 5.33 NAMAX 11.27 11.34 11.41 11.51 11.57 11.54 11.40 JSVAX 13.45 13.59 13.58 13.68 13.66 13.66 13.42 Assuming PHYZX is at...

I know to insert a new paragraph within the same cell to use the keystroke alt-enter, however, I'm trying to make a usable form for my boss, and I'd like to...

Calculation issue not fixed. When calculating a range of numbers I get this: 114,642.55 good When I add another range of numbers I get this: 165,707.09...

I'm working my way through learning to build spreadsheets. How would I create the function to give the area of a circle. I know the formula A=PI*r(squared)...

I need help creating a SUMPRODUCT formula that will find numbers in A:A that are in between (or equal to) the criteria in cells M2 (low value) and M3 (high...

Ive been trying to use an if statement to put a static date in a cell when a certain condition is met. I do not want that date to change(update when the...

Hey folks! Now you have me learning more and more about Excel, I am trying to do things I never thought about before! I have a list of game scores, col 'E'...

I'm self employed, for record keeping I have an invoice, expence report and balance sheet. I fill out the invoice, then the expence report moving the invoice...

Hi, Could someone please help me with this . My spreadsheet has row data in weekly buckets . I would like these weekly amounts to be summed to form the...

Hi, Is it possible show/highlight the different permutations for the cells which add up to a determined value. i.e Value to find=300 Answer A3 or A2+A1 ...

I am trying to get one cell to return a specific value when another cell has a letter entered into it. example: If R is typed in a column serveral times on...

I have a spreadsheet in excel 2003 where a range of cells contain different text. If there is no text in any of the cells within the range I would like the...

Hi All I sue this macro to find and replace a number in column I Columns("I:I").Select Selection.Replace What:="5.95", Replacement:="2.95",...

When I try to update a pivot table (created in Excel 97, later updated in Excel 2003) in Excel 2007, some of the fields from the source database are not...

I need to count up everytime a Y appears in a cell in column I ('Data Sheet'!I:I) but only when a cell contains a 3 in column F. This is one of the many...

Morning folks: I am trying to do something very simple but I just can't seem to get it to work the way I want! I have been searching for an answer for 2...

Heres what i basically need help with :p http://i590.photobucket.com/albums/ss342/xXxRichMxXx/djfrekHELP.png Thanks for helping guys this one has really...

I know this is probably simple, but i just can't get it to work :o I have a column of numbers in a worksheet. I get updated data feeds that may have changes...

I have a range that contain a coulored cells in red yellow and green (for example), How can I fillter the yellow cells? I use office 2007

How does one go about creating a spreadsheet that tracks a lead or contact and follows it through the sales cycle until it converts to a client or sale? It...