Excel help Please!

Reply #3

winsumloosesum — Thu, 12 Jan 2006 20:04:17 GMT

Mickie,Check out your private message.

Reply #2

Mickie — Thu, 12 Jan 2006 17:59:26 GMT

Thank You!I did find that, it does work but it doesn't work with this in front=IF(OR($A3= Ns ,$A3= Nd ), , of it.I use that to get rid of the #Value! that it brings if the cell is blank. I also tried the isblank formula also. Any other clues that might be helpful. Thank you againMickie

Reply #1

winsumloosesum — Thu, 12 Jan 2006 15:57:34 GMT

Mickie,I posted this a few weeks ago.For those who use Excel.Wanted to share this formula for those interested in converting a Pick 3 and Pick 4 drawn number to its ascending form.Example: Pick 4 4 3 9 0 = 0 3 4 9 Pick 3 6 1 3 = 1 3 6The first thing you will need is to download the FREE Add-in form the folowing link:http://xcell05.free.fr/english/Scroll down the page until you see MOREFUNC.XLLDownload, unzip and install.Open Excel>Tools>AddIns>select Morefunc in the list and... [ More ]

Excel help Please!

Mickie — Thu, 12 Jan 2006 00:05:42 GMT

I am using this formula to make a pick 3 number straight. For example: 413 now becomes 134.=IF(OR($A3= Ns ,$A3= Nd ), ,CONCATENATE((MIN(LEFT(R3),MID(R3,2,1),RIGHT(R3))),(MEDIAN(LEFT(R3),MID(R3,2,1),RIGHT(R3))),(MAX(LEFT(R3),MID(R3,2,1),RIGHT(R3))))) How can I change this to make a Pick 4 number straight? Thank you for your helpMickie