Dear Richard
We have B1:B50 numbers and not in assending order we want only 5 small values in&#A0;second sheet B1:B5 and&#A0;all small value left cell text in second sheet A1:A5
--- On Wed, 3/4/09, QT - Richard Burton <qtopic-27-tHAhkTQwWtmq@quicktopic.com> wrote:
From: QT - Richard Burton <qtopic-27-tHAhkTQwWtmq@quicktopic.com> Subject: Help with Excel functions (www.meadinkent.co.uk)
To: "QT topic subscribers" <qtopic-subs@quicktopic.com>
Date: Wednesday, March 4, 2009, 1:03 AM

�A;�A;�A;
< replied-to message removed by QT >

So you want to rank the lists in ascending order of the value column.

Is that right? Then have the top 3 shown in a different sheet?

If so, I would sort the columns and read the first three sets of data from the second sheet. Do you think that would do it?

Dear Richard Burton
Thanks yr prompt reply. We have Column A1:A50 contain text and B1:B50 contain&#A0;numbers (some cell contain same numbers and not assending order). We want samll 1,2 3..&#A0;at another sheet at column B and also want smalll 1, 2, 3... Left Cell&#A0;text by puting formula INDEX & MATCH function at column A&#A0;but MATCH function return the same 1st samll&#A0;one left cell&#A0;text for same&#A0;numbers&#A0;as my last question. INDEX(range,MATCH(SMALL(range,1),range,0),1).
Waiting yr&#A0;need full reply.
Regards,&#A0;

--- On Tue, 3/3/09, QT - Richard Burton <qtopic-27-tHAhkTQwWtmq@quicktopic.com> wrote:
From: QT - Richard Burton <qtopic-27-tHAhkTQwWtmq@quicktopic.com> Subject: Help with Excel functions (www.meadinkent.co.uk)
To: "QT topic subscribers" <qtopic-subs@quicktopic.com>
Date: Tuesday, March 3, 2009, 6:48 AM

�A;�A;�A;
< replied-to message removed by QT >

Hello Zolu,

Perhaps if you can explain the purpose of your formula it might be possible to work out an answer.

Thanks

Richard

Dear Richard Burton
Pls help so what I do for solve this MATCH problem, I am very glade to u for this kindness. Regards,

--- On Mon, 3/2/09, QT - Richard Burton <qtopic-27-tHAhkTQwWtmq@quicktopic.com> wrote:
From: QT - Richard Burton <qtopic-27-tHAhkTQwWtmq@quicktopic.com> Subject: Help with Excel functions (www.meadinkent.co.uk)
To: "QT topic subscribers" <qtopic-subs@quicktopic.com>
Date: Monday, March 2, 2009, 5:40 AM

< replied-to message removed by QT >

Because Match returns the first instance of a match. Which in this case is 1. for both the 1st and 3rd item in the array.

HTH

Dear All Genius Kindly help as follows,A1=10, A2=20, A3=10, A4=40A5 CONTAIN FORMULA =MATCH(SMALL(A1:A4,1),A1:A4,0) ANSWER IS 1.A6 CONTAIN FORMULA =MATCH(SMALL(A1:A4,2),A1:A4,0) ANSWER IS 1.A7 CONTAIN FORMULA =MATCH(SMALL(A1:A4,3),A1:A4,0) ANSWER IS 2.A8 CONTAIN FORMULA =MATCH(SMALL(A1:A4,4),A1:A4,0) ANSWER IS 4.My Question is in Cell A6 why we are not getting Answer 3, Please assist me. Thanks yours passions.

Hi

I have a word file with lot of screen shots. I do not know how to convert it to excel. I want exactly the same data and screen shots in excel. Could you please help.

Regards
Prasanna

Duckling,

I'll take a look... gmcaninch@live.com

_________________

Gary Mc

Hello!

I need some help to my worksheet that I have created. Where can I forward my worksheet to?

John,

Try this....select the cell where you want the data and then click in the formula bar and then either right click and select paste or ctrl+V
_________________

Gary Mc

I am trying to paste text from a PDF document into Excel. When I paste it each line goes into a seperate cell. Is there a way to stop this?

Thank you Gary! I also found the "mid" formula works the same way.

Kathleen,

Enter =LEFT(A1,4) in cell B1

_________________

Gary Mc

If I have a cell containing a code I83A452 -- which function do I use to extrapolate a portion of the code to fall into another cell? For example, Cell A1 contains the code above. I wish to have cell B1 read only I83A. I've done this before, but I can't seem to recall the formula.

Thanks every so much for your help.