Search results

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...

Column C 435 80 50 825 450 50 120 70 810 160 1120 250 1710 260 70 75 150 75 90 130 130 100 120 240 240 85 425 250 90 200 120 140 355 480 160 100 60 65 70 80 75 240 255 90 1440 170 285 475 240 168 220 200 240 120 50 195 25...

Column A Column B Column C PLU SalVal SalVal EGG ROLL 435.00 435 DB. EGG ROLL 80.00 80 PANEER ROLL 50.00 50 CHK.ROLL 825.00 825 EGG CHK ROLL 450.00 450 D.EGG.D.CHK.ROLL 50.00 MUTTION ROLL 120.00 50 EGG MUTTION ROLL 70.00 CRUNCHI FISH FRY 810.00 120 FISH FINGER 160.00...

Thanks a ton Luke, its amazing Subha

Input Given TABLE_NAME COLUMN_NAME ACCOUNT_POOL_MAPPING N_RUN_SKEY ACCOUNT_POOL_MAPPING FIC_MIS_DATE ACCOUNT_POOL_MAPPING N_ACCT_SKEY ACCOUNT_TXNS V_PROD_CODE ACCOUNT_TXNS FIC_MIS_DATE ACCOUNT_TXNS V_ACCT_NUMBER Output required ACCOUNT_POOL_MAPPING...

Input Available data snapshot Table Column ACCOUNT_POOL_MAPPING N_RUN_SKEY ACCOUNT_TXNS V_PROD_CODE APPLICATION_PLANS N_PLAN_TARGET_NUMBER ATTRIBUTION_DEFINITION V_ATTRIBUTION_ID ATTRIBUTION_EXECUTION_MASTER N_ATTRIBUTION_RUN_SKEY BENCHMARK_MASTER V_CCY_CODE BENCHMARK_RATES N_TENOR...