[CQ-Contest] Re: Using Excel to count band changes

[Healy, Rus]

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 at gw.bsu.edu]
>Sent: 	Friday, March 27, 1998 11:18 AM
>To: 	RHealy at 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 at contesting.com