This message from N9RV makes the solution so simple that it's silly. I
was trying to do this in a much more complex way. KISS!
Thanks to the others for the feedback, too.
--73, Rus, NJ2L
>----------
>From: Patrick Barkey[SMTP:pbarkey@gw.bsu.edu]
>Sent: Friday, March 27, 1998 11:18 AM
>To: RHealy@mdsroc.com
>Subject: [CQ-Contest] Using Excel to count band changes -Reply
>
>Rus,
>
>You have the entire file in Excel already? Then why not something
>like
>this:
>
>
> A B C D E
>
>1 Band
>2 20
>3 20 =if(A3=A2,0,1) <-- formula to return 1 if band
>changed
>4 40
>5 40
>6 20
>7 20
>
>Copy the formula to the entire column, then add the column. That will
>give you the number of band changes.
>
> -- Pat
> N9RV
>
--
CQ-Contest on WWW: http://www.contesting.com/_cq-contest/
Administrative requests: cq-contest-REQUEST@contesting.com
|