Search results

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.

Hi Dear, Yes. you got my point. Rgds

Dear all, I have more 500 rows, 12 column for 12 months, 5 XL sheets for different locations. Each Row contains different farmula like:- - vlookup - subtotal & - sum on end of each month, the rows contain Vlookup func. need to be copy, pasted as values. how i can select & give command...

Dear Guys, Sparklines is not active in my excel 2010. how can i use it? Hafiz Mudassar

Vijay, thanks for your comments. you are right but i have used little example here instead i have a big assignment contains more than 100 words in each cells. now tell me; how can we find a word if excel contains more than 100 words in each cells x 1000 rows x 20 columns data? Rgds, Hafiz

Dear, can excel highlight the "lazy dog" in a cell, if we search text by using CTRL+F? like, if A1 cell contains "A quick brown fox jumps over the lazy dog". then "lazy dog" should be highlighted if search command given. Thanks Mudassar

Dear, Thanks for the links but i could not found what i need. can anyboday help me out? Mudassar

Please guide me what is the keyboard shortcut to go for subtotal options i.e. 1 2 3 Thanks Hafiz Mudassar

Sparkline in my excel 2010 ribbon is not active. how i can activate sparkline? Thanks, Hafiz Mudassar

@ magbo, great idea, thanks for your comments.

ok.... thanks again for your time spending. wishing you a great day.