Recent content by Ruba

You are right Luke. I have a huge list of Names and the distances. They are names separated by commas. Ex: John, Paul, Chandu. all three names are in one cell. All three are taking the same cab to work. the first pickup would be Chandu who is at a distance of 50 km. the second pickup is Paul...

My question would help me in solving a transport issue. There are three people coming from differnt places and travelling in the same cab. X is 15km away from work, Y is 10 km away, and Z is 5 km away. X is the first pickup and the cab driver would be given allowance basing on the maximum km...

You truly Amazed me Hui. I am dumbstruck at ur excellence. U r just Awesome. i am so happy looking at the results. more than happy i was surprised as to the wonders of Excel. and yes i admit my question in the first instance wasnt clear. thanks again so so so much.

column/row A 1 2 What is your name? 3 A. eena 4 B. meena 5 C. teena 6 D. deena 7 8 what is your pet's name? 9 A. Ivan 10 B.Divan 11 C.Shivan 12 D.Vivan 13 14 What is your age? 15 A. 25 16 B. 30 17 C. 40 18 D. 50 This is the example. i wanted to give 'Question 1', 'Question 2'...

i have dumped a good number of questions and answers in Excel. If A2 has the question, A3 has the answer. left a row empty A4, and then followed the same pattern of questions from A5 and went on. now if i want to label the questions as 1 and 2 etc starting with A1.how can i do it? i tried...

WOW. it amazed me. Thanks so much Hui and Chandoo. i'm kind of experimenting with Xcel. With this kind of response, am certain to get back to u with more queries. :-)

Hi Luke, the formula i used is: =INDEX(Sheet2!A$1:B$67,MATCH(D4,Sheet2!$A$1:$A$67,0),B) thank you

Thanks so much Hui. i've tried but it throws a NAME error. dont know why.

Hi, i have my itemised phone bill with all the numbers i used in one sheet. i have another sheet with the list of unique numbers and the names against them. firstly excel needs to match the numbers in the first sheet with the ones in the second sheet. then display the names against each number...