using the mod function to alternate rows

**withy** · 03-23-2009, 04:50 AM

new problem:

imagine your data set:

1
2
3
4
5
6

i want to have

-1
2
-3
4
-5
6

i'm using the mod function but am unsure how to put it into the for each loop.

i'm guessing its something like

Please Login or Register  to view this content.

i know thats probably not the correct code at all, but i'm jsut trying to learn all the excel operators. i've only used VB.

**DonkeyOte** · 03-23-2009, 05:03 AM

I'm not really clear what you're trying to do ... perhaps something along the lines of:

Please Login or Register  to view this content.

**withy** · 03-23-2009, 01:18 PM

well, that worked perfectly. ignore the coding, that was jsut my little experiment to try and get it to work before i asked for help.

let me know though..... would it have worked using the for each loop and a counter?

**withy** · 03-23-2009, 01:32 PM

EDIT: ok, the code worked great but only for sequential values. the spreadsheet is organizing the numbers then multipying by -1. i apologize but i should have been more clear. the numbers are random.

546
654
871
1235
12
5
54

and i need:
-546
654
-871
1235
-12
5
-54

make sense? and the code that i provided was my attempt at getting the mod function to work. see i'm pretty new at this and was jsut trying to get the mod function to work before i asked for help

**DonkeyOte** · 03-23-2009, 01:40 PM

Perhaps:

Please Login or Register  to view this content.

A "negative" row is deemed as one that equates to the Odd/Even status of the first row in the range being processed... ie if first row is 2 then Even rows should be set to opposite sign, if first row is 1 then Odd rows should be set to opposite sign.