Excel Help!!

Reply #11

CARBOB — Mon, 19 Sep 2005 22:48:30 GMT

W17 (0)X17(1),Y17(2),Z17(3) is whatever you want to track, Ex 0,1,2,3 numbers carried. K is col where I have the second formula stored which tells you how many digits carried. A is the date col.You can PM with any questions.Carbob

Reply #10

lottaloot — Mon, 19 Sep 2005 20:33:03 GMT

OK. I am trying to think this one thru. I take it that the number that I am searching for would be in W17. K7 thru K3919 would be the ranges of my search the 0 would be an exact matchso would A7 be the date? Am I correct in my thinking? I have to do this process so that I can change the formula to fit my spreadsheet (as I don't know where your draws start in yours

Reply #9

lottaloot — Mon, 19 Sep 2005 20:25:27 GMT

Thanks Carbob--I like Long (formulas that is

Reply #8

CARBOB — Mon, 19 Sep 2005 20:19:21 GMT

This formula tracks skips. =IF(ISNUMBER(MATCH(W17,$K$7:$K$3919,0)),$A$7-(INDEX($A$7:$A$2051,MATCH(W17,$K$7:$K$3919,0))), ) this formula tracks number of digits that carried. It's rather long.=MIN(COUNTIF(G10:I10,G10),COUNTIF(G11:I11,G10))/COUNTIF(G10:I10,G10)+MIN(COUNTIF(G10:I10,H10),COUNTIF(G11:I11,H10))/COUNTIF(G10:I10,H10)+MIN(COUNTIF(G10:I10,I10),COUNTIF(G11:I11,I10))/COUNTIF(G10:I10,I10)Carbob

Reply #7

lottaloot — Mon, 19 Sep 2005 19:40:04 GMT

Thanks SirMetro I will give it a try let you know if it's what I'm looking for how it works.

Reply #6

SirMetro — Mon, 19 Sep 2005 19:10:39 GMT

Consider this as an idea (one that can be expanded upon and compounded if you pay attention the to parenthesis's that will be required)if the data in Cell A1 = 200-90 = 110, then=((LEN(TEXT(A1, ### )))) <---converts the number to a string and then looks to see how many spaces that string takes up. The ### is telling the computer that the data is in number formatthe above will give you 3 digit long.Perhaps this is what you are looking for?Sir Metro

Reply #5

SirMetro — Mon, 19 Sep 2005 19:04:29 GMT

This is known to occur when one either types in a non-numeric character (a-z, and any of the other symbols). It can also occur when you hit the period by mistake. Because the program is attempting to make a literal translation, a non-whole number (n.0001 thru n.9999, n=any number), it sees a variable ( I forget the exact syntax). Remember, an interger is a whole number with no decimals.Hope this helps.BTW, a workaround I use to avoid that error is to multiply that cell value with a 1 to insure i... [ More ]

Reply #4

lottaloot — Sun, 18 Sep 2005 18:34:50 GMT

I need a formula that will allow me to track 1, 2, or 3 digit returns. Does anyone have such a formula that they are willing to share

Reply #3

LANTERN — Sat, 17 Sep 2005 14:08:13 GMT

While I don't know anything about Excel myself maybe you can try asking here:http://groups.google.com/groups?hl=en lr= sa=X oi=groupst q=is+not+a+valid+integer+value+excelAnd or download this:http://www.thomsonib.com/downloads/troubleshooting_guide.xlsGood luck.

Reply #2

BobP — Sat, 17 Sep 2005 07:47:16 GMT

What's Excel mean when you get an error not a valid interger after typing in your numbers

Reply #1

lottaloot — Fri, 16 Sep 2005 23:19:11 GMT

I would like that formula as well if there is such a formula. For the time being, I simply use a conditional format in order to find what I am looking for in whatever position (or all 3) that I need it for.

Excel Help!!

winsumloosesum — Fri, 16 Sep 2005 21:09:46 GMT

Calling all Excel Guru's!!!Looking for a formula for tracking last 3 skips from a Pick 3 drawing history.For example:Say I have a drawing history and I whant to know when the digit #3 hit the last 3 times in position 1.So my chart would look something like this:Pick 3Position 1 Hit#1 Hit#2 Hit#30 (these would be the drawing number(s) the hits occured123456789Thanks in advance for the help!!!wsls