subset

Hi everyone, I can't figure out how to do that: I have the records of a flow of foretasted price. Means that every 2 minutes I have new price coming for the same point of time in the future. My goals is to extract of every period of time the latest foretasted point. As the last forecast should...

Hi There, I have a spreadsheet with 500 rows of data. I need to be able to select a subset of this data based on data in another spreadsheet (which is variable) to update it; and if possible flip this selection. It is like a filter in which you can paste the desired subset to filter the main...

I have reports that are formatted like so: A:A Vendor: [Vendor A] Item 1 Item 2 Item 3 Vendor: [Vendor B] Item 1 Item 2 Vendor: [Vendor C] Item 1 ... 1) the number of items per vendor varies 2) the vendor lines are always in bold 3) the item lines always begin with "??-" (as it would be...

I am trying to figure out the excel 2007 database/list/array function which would take a cell containing a list of text values, look them up in a table go to the corresponding row in another column get its value and then return the maximum value for all the items in the list. A simple...

Hello, I have a spreadsheet that tracks stocks I'm interested in. The first 3 columns are (the rest of the columns being data such as P/E, Yield, etc.) # Ticker Name 1 BAC Bank of America 1 WFC Wells Fargo 2 IBM IBM 2 ORCL Oracle 2 CSCO Cisco The '#' is an arbitray...