Hi All,

I would like to use Excel's string function not VBA to filter out my
data as sample. Please help me to do that.

Many thanks

Thanh Nguyen

Ex:

input data
[A1] AGF: 4388034*73000*(1/16009)=20009150
[A2] BBC: 5600000*39500*(1/17200)=13817228

output data
[B1] = AGF
[B2] = BBC

[C1] =73000
[C2] =39500

[D1]= 20009150
[D2]= 13817228


and I would like to compare all data in column C to filter out max/min
number and display Cheap or Expensive


--
thanhnguyen
------------------------------------------------------------------------
thanhnguyen's Profile: http://www.excelforum.com/member.php...o&userid=30502
View this thread: http://www.excelforum.com/showthread...hreadid=544941