https://docs.google.com/open?id=0B1Yt3Yl95LuPcE5EM2tGcHQ5VEU
Hi all,
I'm trying to write a formula to find out the 2nd and last occurence of accounts. See link. I can get the 2nd occurance but how do I identify the last occurance without using filter and manually work them out? My...
I have searched around but I can't find a short cut in formula.
A1 is an input cell. You can enter any whole number from 1 to say 1000. in column B501:B1500 are the data. I'd like to sum the first X (from A1) number of rows between B501:B1500
Example
if B501=20, B502=35, B503=12...
hi all, just returned from a weekend break. so I see Debraj had found the bug. :)
I was using Excel 2010 and I'd never try to break such an elaborate model Chandoo has built. But bugs somehow always find me.
A little side story, in one of my old college class there was a jar with red...
https://docs.google.com/open?id=0B1Yt3Yl95LuPUnY5R1VMNWQ1eDg
OK. it is obviously i'm hopeless in sports and here is the excuse not to hit the gym any time soon (or any time at all!).
But I'm curious how come I only made 18 errors (i know I only made one) but took 112 years to finish the...
Thanks, sthomas. But as you can see the first column of name and first column of data are not side by side. But may be in the future I can modify the report to utilize your formula.
Thanks, SirJB7. Great idea. I thought about that, too. I was just weary if my boss would understand it. if (s)he doesn't understand it, (s)he would not like my formulae and ask me to change into something (s)he would.
and then there is the issue of expanding the name. this is just the...
Wow! thanks, SirJB7.
I need to do more reading on Text(). I always thought I could only enter a number between " " in text. I never knew that would work. Thank you very much indeed!
I have 2 formulae one using sumif and the other one using sumproduct. Both get the same correct answer but they look a bit too long to me and i can't find a shorter way to express.
basically i need to find out the sales volumn by names and I have names on columns W, AA and AC. There are...
Hi all,
I have a formula like this: ="Total Count: "&COUNTA(A2:A2000) and the anser is "Total Count: 1234" which is correct.
But how do I make it more pleasing to the eyes to add the "," between 1 and 2 so that it reads "Total Count: 1,234" instead?
Please kindly advise. Thank you very much.
you should not include $40K. In excel, your investment $1 mil is set at time zero. that's Feb 2011. Your first receipt of $40K is assumed to be Feb 2012 and so forth. so the end cash receipt is assumed to be Feb 2021.
But you need to get the timing right. Is your first and subsequent...