Lawrence

Posts: n/a

looking for latest selling price..

i have a file like this...

Items Date price
AAA 15.5.2005 1.5
BBB 16.5.2005 1.6
CCC 17.5.2005 1.4
DDD 18.5.2005 2.3
AAA 19.5.2005 1.4
CCC 20.5.2005 1.3
VVV 21.5.2005 1.2

in another worksheet i have a worksheet like this...but without the price
and date

Items Date Price
AAA ??? ???
BBB ??? ???
CCC ??? ???
DDD ??? ???
VVV ??? ???

can i know how to find the latest selling price in second worksheet???

if possible for both price and date...

thanks...

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
create a formula for price * discount* tax =final price	anton	Excel Discussion (Misc queries)	6	October 12th 05 07:51 PM
LOOK FOR LATEST SELLING PRICE	Lawrence	Excel Worksheet Functions	8	October 5th 05 10:27 AM
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

All times are GMT +1. The time now is 09:28 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us