I haven't figured out how to take a specific range of data from a worksheet and use this range, say 7 or 30 days to retrieive data associated with this range...

Hello all, Is there a formula I can plug in to a populated list of dates that automatically accounts for American holidays? Thanks for your...

Hi, I can't find solution for following excel problem: In one table I have two columns - start date and end date (look like this): Start ...

Hi all, is there any possibility how to compute percentile() on a pivot table?. I know that I can use array formulas but my pivot table is based on external...

Hey everyone, Excel 2007 I have a set of data listed like such: Column A COLUMN B (DATES) (NAME) 4/1/2009 Joe 4/1/2009 Joe

Hey everyone: Excell 2007 on Vista This one is getting to me and I"m hoping you can help. My current data layout: Col C Col G Col E Florida...

Hey everyone, Excel 2007 - this one is TOTALLY baffling me. I have almost 13000 records. Performed a simple filter on one column that just shows me the...

Hey everyone, Excel 2007. This one is challenging - don't even know if it can be done. My current layout: A B...

Excel 2003 - how can I extract JUST the text from cells that contain varying lengths of numbers and text with no symbol or visible separator? ...

Hey everyone. Excel 2003. I will frequently add up a range of cells (all dollar amounts that were typed in manually). When I add those numbers up with the...

Hey everyone: using Excel 2000. I have a spreadsheet like such (each # is in a different cell), starting on A1: 1 2 3 4 1 5 6 3 2 7 4 3 1...

Hey everyone, Excel 2000 I have a range of cells like so (each number is in it's own cell) 50 20 30 60 90 30 The FIRST cell (in this case, "50") is...

Hi everyone, I have a situation where a column contains phone numbers, but all numbers are written differently. Some have areas codes and some don't. For...

Hi all, I want to extract only TEXT from a column of numbers and text. For example: WHAT I HAVE: 150mgdl 2000mg 10mgdl 500cc

Hi all, I have a worksheet with imported data. One column contains phone numbers that SOMETIMES have a three or four digit extension after them. Example of...

Hi all, How can I create a simple average calculation that does not include a cell that's blank. For example, I do a simple average all cells A2:A10. BUT,...

Hey everyone, Got a question that is sort of complex...so I'm hoping someone can help. I have a list of names that I'd like to number. The list looks like...

Hey everyone, Excel 2003 or 2007 - I have both I have a column of addresses that were entered into one cell at a time using ALT + Enter for the individual...

I have seen several similar questions posted and none of the resolutions seem to be working for me. I hope Microsoft addresses this issue in the...

Why won't my IFAND function work. below are the columns in my worksheet and example of the data that is in each column. However, my formula is returning a " "...