odd

i swear ive been having odd excel issues.. when i USE screenupdating = true....it prevented the macros from crashing, but when I used FALSE...it crashes at the end of the macro odd, i thought not showing screenupdating would NOT cause it crash

Need help! I am trying to figure out how to have odd numbers in column A on sheet1 move onto sheet2 column A and even numbers in column A on sheet1 move onto sheet3 column A. Thanks in advance for all help. <tbody> T029C T041D T043B T043C </tbody>

I have a large series of numbers that I need separated by even and odd numbers. Here is what the numbers look like. I have made the odd numbers red on the list below and the even numbers are black <colgroup><col width="64" style="width:48pt"> </colgroup><tbody> 19-11-1 19-11-2...

Please, can someone help me with this one: I have a cell containing a 11 digit number. I would like to give another cell a conditional formatting based upon the 3rd digit from the right in this 11 digit number, or 9th from the left if you like. The formatting should be one for odd number, and...

Is this possible?

All formations of suits of each two groups digit Are even / odd 0.2,4,6,8 1,3,5,7,9

Hi I have alot of data, that i need to convert. <tbody> value in system new value (the formula that i need) 8726,36 9000 8971,84 9000 56724,62 57000 7000,1 9000 846618,09 847000 </tbody> what i got so fare is =ROUNDUP(ODD((ROUNDUP(R3;-3)));-3) but it doesnt work i need the...

Hello , i have 5 columns of data. A1 = "other" B1 = "other" C1 = "other" D1 = "taxi" E1 = "other" A2 = "other" B2 = "other" C2 = "other" D2 = "other" E2 = "car" A3 = "other" B3 = "other" C3 = "other" D3 = "other" E3 = "other" I am trying to work out a formula in F1, F2, F3 whereby if row...

There are some rules: 1. Any variable/input can only be used one time. For example, if cell "A1" is input, then cell "A1" in the formula can only appear one time. (The formula like this "=if(A1=???,A1,0)" is not allowed) 2. Can't use other cells to do calculation. 3. No Name and No VBA are...

Hi All, Is there a way to VBA ScrollArea all of the EVEN sheet numbers to AND ScrollArea all of the ODD sheet numbers to ?? Thank you! Pinaceous

Hi, I have a macro that imports a text file, cleans it up, and transfers the information to a printable data sheet for processing. It works great for %99.9 of my users. I have one guy who just transferred from excel '14 to '07 (which is the format my software is formatted for). When he runs...

Hello I have a row that consists of numbers. I want to count how many numbers in that row are odd, more than 20 and less than 40 in one and single formula! I would appreciate a respond Thanks in advance

Hello guys/gals: I am having a really, reaaallyyyy strange behaviour in some cells. I had a formula there adding 2 to another cell which had a date. eg: =A1+2, where A1 had a value of 01/01/2009. When I open the book again (this book is stored in the server, so it is shared and 3 people work on...

Hi :huh::huh: this is urgent(part of a assignment) I need an Excel formula which will take the month/day from one column plus the year from another column and combine these to make a date in a third column. Then the formula will need to check if the new date in the third column is an odd...