Recent content by subhapratimdas

Thanks Luke, it was APR compounding, even I would love to find out some investment avenues with 9% daily.. @ Narayan.. yes its 10000+75 which will form the Principal Amount for months 2 computation.. Regards Subha

I would like to prepare a template for knowing how much Interest will I receive on a Monthly basis if I invested 10k at 9% daily compounding interest Enter Investment Amount -- 10000 Enter Interst Rate(Daily compounding) - 9% Time of Investment-(Term in Years) - 5 If I input above then...

Thanks Hui, it worked and also understood my mistake, good learning. Regards Subha

I pasted the function in Module. Can you please a share a sample workbook with this function please. Regards Subha

http://hotfile.com/links/147183673/3cd0e39/FOOD_SALES.xlsm http://hotfile.com/dl/147183673/5c99ba6/FOOD_SALES.xlsm.html http://hotfile.com/dl/147183673/5c99ba6/FOOD_SALES.xlsm.html

More links to the file http://hotfile.com/links/147183673/3cd0e39/FOOD_SALES.xlsm Forum link: http://hotfile.com/dl/147183673/5c99ba6/FOOD_SALES.xlsm.html HTML link: http://hotfile.com/dl/147183673/5c99ba6/FOOD_SALES.xlsm.html

I did the same I pasted the stuff Function Cell_Math(myRange As Range, source As Range, Optional myType As Integer = 1) As Integer ' ' Use =Cell_Math( Range, Ref Range, Type) ' ' Type=0 Sum cell values that match Ref Range color ' Type=1 Counts cells that match Ref Range color Cell_Math...

More links for files http://hotfile.com/links/147183673/3cd0e39/FOOD_SALES.xlsm Forum link: http://hotfile.com/dl/147183673/5c99ba6/FOOD_SALES.xlsm.html HTML link: http://hotfile.com/dl/147183673/5c99ba6/FOOD_SALES.xlsm.html

http://hotfile.com/links/147183673/3cd0e39/FOOD_SALES.xlsm Forum link: http://hotfile.com/dl/147183673/5c99ba6/FOOD_SALES.xlsm.html HTML link: http://hotfile.com/dl/147183673/5c99ba6/FOOD_SALES.xlsm.html I did the same I pasted the stuff Function Cell_Math(myRange As Range, source As...

http://hotfile.com/links/147183673/3cd0e39/FOOD_SALES.xlsm Forum link: http://hotfile.com/dl/147183673/5c99ba6/FOOD_SALES.xlsm.html HTML link: http://hotfile.com/dl/147183673/5c99ba6/FOOD_SALES.xlsm.html I did the same I pasted the stuff Function Cell_Math(myRange As Range, source As...

Yupp, I did that Pasted this function Function Cell_Math(myRange As Range, source As Range, Optional myType As Integer = 1) As Integer ' ' Use =Cell_Math( Range, Ref Range, Type) ' ' Type=0 Sum cell values that match Ref Range color ' Type=1 Counts cells that match Ref Range color...

Hi, I tried pasting the vba code and adding the formula, but its still not working. I don't know much of VBA, could you please let me know, where and why its not working. File attached http://hotfile.com/dl/147183673/5c99ba6/FOOD_SALES.xlsm.html Regards Subha

Hi, Would like to do categorywise sales which can be identified based on colours. Sorry missed to attach the excel workbook http://hotfile.com/dl/147170471/80d0946/FOOD_SALES.xlsx.html

Thanks Faseeh, its cool.

Hi, I need to match blank cells in between in Column B and Column C. In Column C ie between 450 and 50 there is one cell which I have to delete, similarly 50 and 120 so that I can find corresponding to Column B the values in Column C ie D.EGG.D.CHK.ROLL 50.00 is showing in Column B but in...