Hi Harry,
I am getting the same answer . Hope you are not following BODMAS rule.
If n=69 and r=5 then the formula will be :
=(FACT(C2))/(FACT(C3)*(FACT(C2-C3)))
Hi,
Solution has been done using VBA. Write function Join_Data anywhere in excel and select then range from Q6 upto last cell and press enter then you have the city name in which 0.00 is placed. Make sure that your first row must be start from 6 or if any change then you need to go in program...
Hi John , please confirm that do you have your data in correct form because if the number will like this 143211 in which 32 does not belongs to any date for month.
you can unlock your workbook with this code:-
Sub unlock_workbook()
Workbooks.Open "Enter your file path here", Password:="enter your file password here", writerespassword:="enter your read/write password here"
End Sub
Hi
it is very easy to change cell format according to your requirement and also you can easily sort this data. Go through with my attachment. If you want any change please reply.
the very simple answer of this query by Index-Match function:
=IFERROR(INDEX(Permanent!$B$3:$K$14,MATCH('Master sheet'!$A4,Permanent!$A$3:$A$14,0),MATCH('Master sheet'!B$3,Permanent!$B$2:$K$2,0)),INDEX(
Answer of Question# 3
Right Click on pivot table > click on pivot table option > select Layout & Format and unchecked "Auto fit column width on update"