Search results

Hi PRAVEEN 1. copy & paste data to new workbook, than go to page layout, change it and view. check if works otherwise increase your font size. if you share your file...it would be helpful fir better solution Thanks & Regards, Muhammad Shakeel

plz guide me how

can someone guide me how can i change my avatar?? i have visited above file but fail to understand

Hi =IF((D34+D74)=COUNTA(Comp!A:A)-1,"Y ","N ")&IF((G34+G74)=COUNTA('Pending 1'!A:A)-1,"Y ","N ")&IF((I34+I74)=COUNTA(Created!A:A)-1,"Y ","N ") I hope its work now. :) Thanks & Regards, Muhammad Shakeel

Hi Basavaraj! Please find the formula below =IF(Q14=COUNTA(Comp!A:A)-1,"Y","N")&IF(Q11=COUNTA('Pending 1'!A:A)-1,"Y","N")&IF(Q11=COUNTA(Created!A:A)-1,"Y","N") feel free to ask if find any issue Regards, Muhammad Shakeel

Hi Basavaraj Can you share you file

Hi Serene, if you could upload your file it will be helpful. :) Regards, Muhammad Shakeel

Hi Maria Clara, Please find below the attached file. if you are using Excel 2010 you can use Slicers as filter https://www.dropbox.com/s/l5bp34iookms4pc/Pivot%20Example-Maria%20Calara.xlsx Regards, Muhammad Shakeel

if you have any further issue feel free to ask

Hi d380013 =IF(A2=0,"",A2)&IF(B2=0,"",B2)&IF(C2=0,"",C2)&IF(D2=0,"",D2) i hope its work Regards, Muhammad Shakeel

what do you mean programmatic method?

hi gwstudent hope you are fine I have a solution for you if you have excel 2010 or 2013 i have used slicer in pivot table as filter in older version you can use filter option in pivot. i did both in below file...

Bohbc :P its Faseeh Barkat

thank you Faseeh i did it

yes

any solution plz?

Hi Dears Excel Greats I want to get ledger in excel using pivot. i have a sheet in which i am entering advances (Dr.) and their adjustment (Cr.) Format is Date Name Description Debit Credit in pivot i am using slicer of name that i can get the balance (due amount)of a person in...

Hi Dear ANNLEE Please click on pivot table than on menu bar you will see a pivot table tools. click on it than option than data change data source pivot table tools > option > data > change data source here you can change your data reference. Regards Muhammad Shakeel

Help plzzzzzzzzzz Friends i have use this in module but its not working Option Explicit Private Sub Workbook_BeforeClose(Cancel As Boolean) On Error GoTo ErrorHandler If IsEmpty(Sheet1.Range(Sheet1.Range("A1"))) Then MsgBox "Please fill in cell " & Sheet1.Range("A1") & " before...

Hi Anupam i try your link but not working

need help and guidance

is there no solution?

Hi Brilliants! I have two issues with my file: 1.i have used chandoo's checklist in my file, but at the time of opening its shows an error which repair the file and save as new file. 2. i want a code that someone can not close the file untill fill the required fields. The file i attached...

you can search on this chandoo site by searching 2nd value vlook up chandoo.org/wp/2010/11/10/vlookup-second-value/ i uploaded the file which chandoo already shared https://www.dropbox.com/s/6b0jthq9327zmj2/vlookup-2nd-value.xls it is best to use :) Regards Muhammad Shakeel

Hi polarsiking