Search results

Thanks Shrivallabha/Nazmul...

Dear Shrivallabha, earlier what i was doing just copy the data from Sheet1 range a1 to ap81 and paste in compile sheet. then from sheet2 same range and again paste in compile sheet a83 which go through ap164... repeating this 7 times. Regards, Parvez

Dear shrivallabha, Data range is same in all sheet... i want compile all data in one sheet with the gap of 2 rows.... A1 to AP81... some row have formula...

Hi Ninjas... I have 7 sheet which i want to compile in sheet 1 using some shortcut. Please help...

Dear T100, just press Ctrl+6 when you want to print. it will hide all object. Regards, Pavi

Hi Narayan, Now working fine. Thanks. Actually i took the value in N4 from E4 using round(e4,2) thats why i m giving N4 reference... Thanks vijay & Narayan...

how to post the Sheet.

Dear Ninjas, I m using below formula to add up & down icon in Col O4 =ROUND(F4,2)&" "&IF(F4>E4,"▲","▼") using below formula in CF but not working. =VALUE(LEFT(O4,FIND(" ",O4)-1))>N4 CF Format Blue bold Italic. =VALUE(LEFT(O4,FIND(" ",O4)-1))<N4 CF Format Red Bold Italic...

Hi All, I am Parvez from KSA and i m adicted to this site from last few month... I am very happy that i found 24X7 free excel class which I am looking from such a long time. Special Thanks to chandoo and Excel Ninjas...

Yes Narayan... When i m using format painter one-by-one then its work correctly... but when i m selecting whole area then giving wrong colour. is there any thing which will work for whole selection... Thanks...

Dear Narayan, not working... giving wrong color if greaterthan A2...

Hello Ninjas... Please help me... How can i show two icon only using formula.. A2 B2 161.85 161.92 66.84 56.39 for 161.92 green Circle & 56.39 Red circle so on... i.e if B2 greaterthan A2 then B2 Green Circle if lessthan Red Circle I want CF only in B column...

Fasseh bhai congrats... :(... when i will become ninja... ;(...

Luke the real Ninja.... It's work fine... Thanks alot Luke the Ninja...

Hi Ninjas, i want formula which give 0% if any of one value is zero... =IF(ISERROR(ROUND(D5/C5,2)*100 & "% " & IF(D5>C5,"▲", IF(D5=C5,"●","▼"))),0) I use above formula but not working for both condition. Example A2 B2 C2 1200 0 0%▼ 0...

I didn't enroll a single course on chandoo.org but i can say that chandoo will not cheat any1... if you ask him anything he will surely help you out...

Yuppiii... working fine... Deb caught me right... Thanks.. Debraj/shrivallabha/NARAYAN/Suresh... Sorry to trouble you...

sheet's calculation mode is automatic...

Dear Deb... In your file its working fine but in my file need f9 to highlite... from where i can change sheet's calculation mode "Automatic"... Please help...

Dear Deb, Macro enable. Still automatically not highlighting need to press f9.

Dear Deb, Thanks for your reply... When i m clicking in any cell that cell is not highlighting only other two is highliting.... also its automatically not highlight, when i press F9 then only other two cell highlighted. please help...

YES... exactly...

Other two cell is h3 and c13...

Mayank & Narayan... :(... not working.... both of them.. pleas help

I want to know how i can highlight the cell and respective cell heading in a perticular table. i m using below code to highlight the row and column. Private Sub Worksheet_SelectionChange(ByVal Target As Range) [SelRow] = Target.Row [SelCol] = Target.Column End Sub but i want only 3 cell...