Recent content by fred

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