Search results

Hi guys, any help? I have attached a sample workbook that I have done. But all the values here are done by brute force method. https://www.dropbox.com/s/kgjika5xs4ylb12/Workbook1.xlsx Thanks!

Hi guys, I have a question. Is there a way that Excel can calculate all the possibilities for receiving $2.30 change (in $2 notes, $1 notes, 50 cents, 20 cents, and 10 cents)? For example, I can receive $2.30 in 23 ten cents coins, or 21 ten cents coins and 1 twenty cent coin. Any help...

Thanks Narayan! That worked. :)

https://www.dropbox.com/s/kgjika5xs4ylb12/Workbook1.xlsx Hi, Thanks for your advice but I am still unable to work it. I have attached a link to the sample workbook that I am working on. I am trying to rank the values in column B. Any help would be appreciated. Thank you.

Values Rank 3.72222222222222000000000000000 5 3.27777777777778000000000000000 12 3.33333333333333000000000000000 11 3.77777777777778000000000000000 4 3.50000000000000000000000000000 8 3.05555555555555000000000000000 15 3.38888888888889000000000000000 10...

Hi Narayan, Thank you so much. Yes, this is very helpful.

Hi Narayan, Thank you for the reply. My data is basically a bunch of numbers which represent the closing account balances across 11 years. Drawdown (in forex terms) is calculated by the decline from the largest number (e.g. cell A1) to the next smallest number (A10) before it jumps to...

Hey guys, I'm not sure what happened to my previous post. It didn't show up for some reason. I am new to the site, just like to say I am a big fan of it! :) I am currently working on a project which analyses forex data. I can't post the info here for confidentiality issues. My question is...