Lawrence

Posts: n/a

LOOK FOR LATEST SELLING PRICE

currently, my boss asked me to look for latest price in a large volumn of
data in excel.

the data is like this...

Product transaction date selling price
A1 5/6/2005 $10
A2 6/6/2005 $11
A1 7/6/2005 $12
A1 8/6/2005 $10.5

Is there any formulas allow to get the A1 latest selling price?

thanks a lot..

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formula for calculating price	nander	Excel Discussion (Misc queries)	1	August 4th 05 09:19 PM
MSNStockQuote Function Parameters	Bobtarrel	Excel Worksheet Functions	2	July 17th 05 02:36 PM
Macro's for figuring Price Lists?!?	MonteNOS	Excel Discussion (Misc queries)	2	April 1st 05 08:34 PM
Product Price List with 14k records, filter w/out using AutoFilter	ChrisSeattle	Excel Worksheet Functions	1	March 3rd 05 06:46 PM
Computing Sales Tax and Retail Price from a number	Lani Jo	Excel Worksheet Functions	8	February 16th 05 08:06 PM

All times are GMT +1. The time now is 05:11 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us