ahmed

Hi All, Thanks in advance for your help. we have the following sheet, its a sample sheet (have data approx 90 row and 100 column) Excel 2010 32 bit ABCDEF 1MarksRamRaviRoziSunnyAhmed 245NaNaNaNaNa 365NaNaNaNaNa 425YesYesYesYesYes 535NaNaNaNaNa 626YesYesYesYesNa 798NaNaNaNaNa...

I have two columns : one with names in Arabic and the other with names in English which are sorted alphabetically I used ( look up ) formula but it returns wrong results =LOOKUP(G$1:G$100;$A$1:$A$100;$B$1:$B$100) <tbody> <colgroup><col width="72" style="width:54pt"> </colgroup><tbody> احمد...

Hello All, i need to split the some data like : Ahmed // ABC.com // call // 123456789 or Ahmed // Abc.com // Mail // abc.com issue and i need when ever the excel find that format *.com/*.net/*.edu put that data in product column and wherever find number put it in the number column o know i...

Dears, i need to limited the below formula and make it working automatically when i increase the column the row increasing after divided it i used the below formula =INDEX('[TESTSHeet.xlsx]Customers INFO'!$B$2:$B$201,ROWS('[TESTSHeet.xlsx]Customers...

Hi all, tell me how i can values in group wise below mention table. <colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody> Person Age majid 19 sajid 25 khalid 20 ahmed 60 nasir 35 khan 45 gulraz 31 </tbody>...

Please any expert here can help me to find the data of whole column A(3000 rows) in sheet 1 in another column A in sheet 2 rathar than search for each row and when the row is matched copy the whole column of sheet 2 in sheet 1 with in the same row for example copy the data column b & c from...