Recent content by getpras

Thank you very much......... that array formula is too complex for me. Please don't misunderstand. I am really a average user of Excel.

Thank you.... I don't think I can explain the problem to you......never mind. If you can do it otherwise its Ok.

Thank you Bobhc... but the output i want like this, as uploaded in the file.

Thank you.... I have uploaded the sample file.

Please if could heo

user col value 413212 grade CE.04 413212 eq EK.08 342860 grade TE.03 342860 eq EK.07 user grade eq 413212 CE.04 EK.08 342860 TE.03 EK.07

Narayan, you were Right.... it was the formatting. But now there is another problem. When applied this to another range for E.g. if i need to find the max in range b1:d9 and place the result in D10 and then in E10 i paste your formula it does not work... it does not give me the correct cell...

Thanks Narayan.. But the problem is when i paste this formula in B10 the answer seems to be appearing in Cell D10

I used the Max function in cell A10 to find the max value in a range (a1:a9). In B10 i want to know the positon (Cell address) of the max value in the range (a1:a9).

I have a worksheet where in i have allowed data entry in only 2 columns of the sheet. Whats required is when data is typed in any cell of these columns i should not be able to move anywere else without entering some data in the adjacent cell. For example if Col A and Col B are the two columns...

Awesome..... Thanks Guys.

I need some help in creating a formula to replace the 1's with the column header. For Example Name A B C Faseeh 1 1 Sachin 1 1 Yuvi 1 1 Should look like this... Name A B C Faseeh A C Sachin A B Yuvi A C