Search results

Thanks, all!

Here is a question: $AMT PAYEE1 PAYEE2 PAYEE3 PAYEE4 438 A B 409 C A B D 171 B A D 248 C 117 B A C...

Thanks, all!! :)

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

Never mind. I found my own solution. Thanks for the inspiration. LEN(SUBSTITUTE(A1," ",""))

hi Luke, What if I want to remove all the spaces not just excessive space? Trim would only remove double spaces or more down to single space. Fred

Thanks all. I thought when I use SUM() there has to be a ":" on the range. I didn't know you don't have to have one.

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

Congrats, Luke!

Good eyes, SirJB7! I need a new pair of glasses.

btw, I have updated my link to make it available for all to download. https://docs.google.com/open?id=0B1Yt3Yl95LuPUnY5R1VMNWQ1eDg

are you sure your range of Q3:Q6766 are all numbers but not partially "Text" or something else?

Would you like to try saving the file as "Excel 97-2003 workbook" in Excel 2010?

Hi mnuttall87, if C1 and D1 is forced to become 0.00389 and E1 remains -0.00389, is the result still an "OK", or a "Check"?

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 and I LOVE all the great input. What a group of great minds!

Thanks Hui!

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

Tried that before but didn't work.

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