Recent content by Mudassar.freedi

Dear Narayan, yes! you are right. i want to go directly to D2 instead of A2 as you mentioned above. is there any short cut..? I have to cross check an excel file with more that 500+ indirect formulas. thanks.

so, what to do if i have to use shortcut way to go for linked cell on =INDIRECT(ADDRESS($A2,I$1,,,$A$1)) where $A2 is column reference I$1 is Row referece $A$1 is sheet name (other sheet) thanks for your time spend.

=INDIRECT(ADDRESS($A2,I$1,,,$A$1)) $A2 is column reference I$1 is Row referece $A$1 is sheet name

Dear Excel ninjas, I have to trace excel formula =A1 in spread sheets mostly. I can easily go to normal linked cell address using Ctrl+[ but when my colleague use indirect function like =INDIRECT(ADDRESS($A2,I$1,,,$A$1)), i can not go directly on linked address. is there any short way to go...

thanks Anand

Hello ninjas, when i open my file, a popup msg 'unable to open' appears on my screen. i have to click OK for more than 15 times which takes 4-5 mins to let me in. i go to edit links but i can not see any external link there. how i can break & deactivate the external collaboration links in an...

Dear Excel masters, i have data with sales location wise. i just need to show positions (1,2,3...) on the basis of maximum sales. i have uploaded file on below link. kindly advise how i can position them on yellow highlighted format...

Dear all, I am facing a magical excel formatting error and could not fix it. the case is, i have a file with more than 10 excel sheets, after some formatting on those sheets, i had closed the file clicking on save button. on reopening the file, the file will show u that there was no...

Dear i have to work in 10 standard sheets simultaneously. can you help me to Freeze 10 grouped sheets in one attempt? Thanks Hafiz Mudassar

Hurraa, thanks a lot Hui i was sure that i will receive 100% resolution from chandoo.org it is the best excel forum. thanks again.

Dear all, Please help me to show business results in graph format as mentioned in below file. http://www.2shared.com/document/ppQTLQ8O/Graph_sample_required.html Thanks, Hafiz Mudassar

Dear all, When I hide unnecessary columns of my workbook, i received below message. please guide. "Cannot shift objects off sheet" Thanks, Hafiz Mudassar

Dear All, Please help me to understand what is the difference in between Indirect Farmula & direct link reference? thanks Hafiz Mudassar

it's worked. thanks for your efforts. can you plz explain the logic, you used. i have not much idea regarding vb. thnks again.

THAT'S WHY I could not succeeded due to inner vlookup. Sorry for not informing you for this 'if logic'. actually, my vlookup farmula on each cell is:- =IF($B19=$B20,0,IFERROR(VLOOKUP($B19,Grouped_Data,8,),0)) now please guide me.