tag:blogger.com,1999:blog-8837688.post4658903216546049574..comments2023-10-25T06:36:49.686-07:00Comments on Nerdy Tales: A Good Nerdy Excel WeekAnonymoushttp://www.blogger.com/profile/10341061356170336823noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-8837688.post-68229299271400751172007-10-12T14:56:00.000-07:002007-10-12T14:56:00.000-07:00ooo i like that concatenatehere's my 'best not hav...ooo i like that concatenate<BR/><BR/>here's my 'best not have to edit it because it is a bit of a mess' cell<BR/><BR/>=INDIRECT(ADDRESS(4,IF($AD5=$AB5,<BR/>SMALL(IF(($AF5:$AZ5)=SMALL<BR/>($AF5:$AZ5,2),COLUMN($AF5:$AZ5)),2),<BR/>MIN(IF(($AF5:$AZ5)=SMALL<BR/>($AF5:$AZ5,2),COLUMN($AF5:$AZ5)))),2))Anonymoushttps://www.blogger.com/profile/10341061356170336823noreply@blogger.comtag:blogger.com,1999:blog-8837688.post-51578334475983366262007-10-12T12:38:00.000-07:002007-10-12T12:38:00.000-07:00heres a few functions i've used that i'm not sure ...heres a few functions i've used that i'm not sure i can edit them cause they only make sense when i write them<BR/><BR/>=CONCATENATE(IF(ISTEXT(E58),CONCATENATE("(",E58," ",F58,(IF(ISTEXT(G58),", ","")),G58,") in "),""),D58)<BR/><BR/>=IF(S58,"Done",(IF(AND((K58<=$V$1),NOT(ISBLANK(K58))),"Expired",(IF(AND((R58<=$V$1),NOT(ISBLANK(R58))),"Stock","Scheduled")))))<BR/><BR/>even some super crappy 2 line VB<BR/>Private Sub CheckBox3_Click()<BR/>If TextBox3.BackStyle = fmBackStyleOpaque Then TextBox3.BackStyle = fmBackStyleTransparent Else TextBox3.BackStyle = fmBackStyleOpaque<BR/>End Sub<BR/><BR/>Private Sub CommandButton1_Click()<BR/>Range("D4").Value = Range("D4").Value + 1<BR/>End Subk2hhttps://www.blogger.com/profile/16171968118329398960noreply@blogger.com