Posts by rajesh06

I just received and wore my first Ledbury shirt. (Just bought one to try it out) No tie today. I thought the construction was very good. There is some magic in the collars that keeps them standing - this fixes a problem that I often I...

I think the answer lies with the OFFSET function.

=subtotal(9, [range]) use the same formula for the grand total - it will ignore the intermediate subtotals

Quote: Originally Posted by Biggskip This mostly works except that the end result is still 12:02:15 A.M. Agree - though with the custom format it would just display as 2:15,

Quote: Originally Posted by Kajak Is it possible to make excel think that 2:15 is 2 minutes and 15 seconds, as opposed to 12:02:15 AM or 2:15 AM? I don't think so via direct entry. You could convert to...

Quote: Originally Posted by gomestar i have a list, say a thousand names. And one column specifies their city, another their birth month and another their mortgage payments. How can I calculate the 25th and 75th...

Quote: Originally Posted by Connemara I have a very long worksheet that I'm trying to sort in a specific way. Basically, each row is a company's name plus some other data. Each data point is repeated individually, with...

Quote: Originally Posted by Kajak Ok, so I don't know if this makes sense/is possible but: I have about a dozen sheets with different test results for various subjects, formatted like A - name B - Year of Birth C...

Basile Reason: Construction / Value

Quote: Originally Posted by Huntsman Is there a way to reference a cell within a formula in a truly relative fashion? By this I mean say you had SUM(B1:B7), but what you really wanted to do is not call cell B1 as the...