advertisement
Forums

The Forum is sponsored by 
 

AAPL stock: Click Here

You are currently viewing the Tips and Deals forum
Hey, Excel Users — now THAT'S a formula!
Posted by: Furiously Stylish
Date: February 16, 2006 02:49PM
=IF($D13="#",IF(YEAR(DATEVALUE(J13))&TEXT(MONTH(DATEVALUE(J13)),"00")>YEAR(DATEVALUE(I13))&TEXT(MONTH(DATEVALUE(I13)),"00"),IF(NOT(ISNA(MATCH(F13,'Orders'!$A:$A,0))),IF(VLOOKUP(F13,'Orders'!$A:$AH,MATCH(J13,'Orders'!$A$7:$AH$7,0),0)=K13,TEXT($B13,"000000000")&TEXT(DATEVALUE($J13),"mmm"),""),""),""),"")

Options:  Reply • Quote
Re: Hey, Excel Users — now THAT'S a formula!
Posted by: incognegro
Date: February 16, 2006 02:58PM
is that Classic Coke's formula?



Options:  Reply • Quote
Re: Hey, Excel Users — now THAT'S a formula!
Posted by: Furiously Stylish
Date: February 16, 2006 03:03PM
incognegro Wrote:
-------------------------------------------------------
> is that Classic Coke's formula?
>
>


I would tell you but they would be here fifteen seconds after I transmitted to silence me.
Options:  Reply • Quote
Re: Hey, Excel Users — now THAT'S a formula!
Posted by: cbelt3
Date: February 16, 2006 03:34PM
Buzz beat ya
<[forums.dealmac.com];
Options:  Reply • Quote
Sorry, only registered users may post in this forum.

Click here to login

Online Users

Guests: 126
Record Number of Users: 186 on February 20, 2020
Record Number of Guests: 5122 on October 03, 2020