BlueSkyJaunte |
10-23-2012 01:52 PM |
LOL, just on a whim I opened up one of my larger sheets that's sitting in my archives and found these:
=CEILING(IF(NOT(ISERROR(SEARCH("SL",Sheet2!S3))),S heet2!M3*(Sheet2!U3/IF(Sheet2!K3="R",25,10))*Sheet2!AB3,Sheet2!M3),1)
=IF(IFERROR(VLOOKUP(LEFT(H70,5),Sheet2!G:K,5,0),VL OOKUP(LEFT(H70,3),Sheet2!A:K,11,0))<AB70,AB70+1,IF ERROR(VLOOKUP(LEFT(H70,5),Sheet2!G:K,5,0),VLOOKUP( LEFT(H70,3),Sheet2!A:K,11,0)))
and
=D78&"&"&"IF("&A79&"2<>0,"&A79&"2&""|"","""")"
But this one takes the cake:
IF(E14<>0,E14&"="&index!E14&";","")&IF(F14<>0,F14& "="&index!F14&";","")&IF(G14<>0,G14&"="&index!G14& ";","")&IF(H14<>0,H14&"="&index!H14&";","")&IF(I14 <>0,I14&"="&index!I14&";","")&IF(J14<>0,J14&"="&in dex!J14&";","")&IF(K14<>0,K14&"="&index!K14&";","" )&IF(L14<>0,L14&"="&index!L14&";","")&IF(M14<>0,M1 4&"="&index!M14&";","")&IF(N14<>0,N14&"="&index!N1 4&";","")&IF(O14<>0,O14&"="&index!O14&";","")&IF(P 14<>0,P14&"="&index!P14&";","")&IF(Q14<>0,Q14&"="& index!Q14&";","")&IF(R14<>0,R14&"="&index!R14&";", "")&IF(S14<>0,S14&"="&index!S14&";","")&IF(T14<>0, T14&"="&index!T14&";","")&IF(U14<>0,U14&"="&index! U14&";","")&IF(V14<>0,V14&"="&index!V14&";","")&IF (W14<>0,W14&"="&index!W14&";","")&IF(X14<>0,X14&"= "&index!X14&";","")&IF(Y14<>0,Y14&"="&index!Y14&"; ","")&IF(Z14<>0,Z14&"="&index!Z14&";","")&IF(AA14< >0,AA14&"="&index!AA14&";","")&IF(AB14<>0,AB14&"=" &index!AB14&";","")&IF(AC14<>0,AC14&"="&index!AC14 &";","")&IF(AD14<>0,AD14&"="&index!AD14&";","")&IF (AE14<>0,AE14&"="&index!AE14&";","")&IF(AF14<>0,AF 14&"="&index!AF14&";","")&IF(AG14<>0,AG14&"="&inde x!AG14&";","")&IF(AH14<>0,AH14&"="&index!AH14&";", "")&IF(AI14<>0,AI14&"="&index!AI14&";","")&IF(AJ14 <>0,AJ14&"="&index!AJ14&";","")&IF(AK14<>0,AK14&"= "&index!AK14&";","")&IF(AL14<>0,AL14&"="&index!AL1 4&";","")&IF(AM14<>0,AM14&"="&index!AM14&";","")&I F(AN14<>0,AN14&"="&index!AN14&";","")&IF(AO14<>0,A O14&"="&index!AO14&";","")&IF(AP14<>0,AP14&"="&ind ex!AP14&";","")&IF(AQ14<>0,AQ14&"="&index!AQ14&";" ,"")&IF(AR14<>0,AR14&"="&index!AR14&";","")&IF(AS1 4<>0,AS14&"="&index!AS14&";","")&IF(AT14<>0,AT14&" ="&index!AT14&";","")&IF(AU14<>0,AU14&"="&index!AU 14&";","")&IF(AV14<>0,AV14&"="&index!AV14&";","")& IF(AW14<>0,AW14&"="&index!AW14&";","")&IF(AX14<>0, AX14&"="&index!AX14&";","")&IF(AY14<>0,AY14&"="&in dex!AY14&";","")&IF(AZ14<>0,AZ14&"="&index!AZ14&"; ","")&IF(BA14<>0,BA14&"="&index!BA14&";","")&IF(BB 14<>0,BB14&"="&index!BB14&";","")&IF(BC14<>0,BC14& "="&index!BC14&";","")&IF(BD14<>0,BD14&"="&index!B D14&";","")&IF(BE14<>0,BE14&"="&index!BE14&";","") &IF(BF14<>0,BF14&"="&index!BF14&";","")&IF(BG14<>0 ,BG14&"="&index!BG14&";","")&IF(BH14<>0,BH14&"="&i ndex!BH14&";","")&IF(BI14<>0,BI14&"="&index!BI14&" ;","")&IF(BJ14<>0,BJ14&"="&index!BJ14&";","")&IF(B K14<>0,BK14&"="&index!BK14&";","")&IF(BL14<>0,BL14 &"="&index!BL14&";","")&IF(BM14<>0,BM14&"="&index! BM14&";","")&IF(BN14<>0,BN14&"="&index!BN14&";","" )&IF(BO14<>0,BO14&"="&index!BO14&";","")&IF(BP14<> 0,BP14&"="&index!BP14&";","")&IF(BQ14<>0,BQ14&"="& index!BQ14&";","")&IF(BR14<>0,BR14&"="&index!BR14& ";","")&IF(BS14<>0,BS14&"="&index!BS14&";","")&IF( BT14<>0,BT14&"="&index!BT14&";","")&IF(BU14<>0,BU1 4&"="&index!BU14&";","")&IF(BV14<>0,BV14&"="&index !BV14&";","")&IF(BW14<>0,BW14&"="&index!BW14&";"," ")&IF(BX14<>0,BX14&"="&index!BX14&";","")&IF(BY14< >0,BY14&"="&index!BY14&";","")&IF(BZ14<>0,BZ14&"=" &index!BZ14&";","")&IF(BW14<>0,BW14&"="&index!BW14 &";","")&IF(BX14<>0,BX14&"="&index!BX14&";","")&IF (BY14<>0,BY14&"="&index!BY14&";","")&IF(BZ14<>0,BZ 14&"="&index!BZ14&";","")
|