Every other formula?

[MCosca]

I am writing an IF formula and though I searched here I couldnt find one. I am in need of a method to assign a value to every other resource.

for example I have a list of 1000 potential assignments. Each assignment has certain other criteria assigned to it based on values like "State" and "division". Certain criteria is in early piece of the assignment leaving a total of about 600 remaining of which I want to divi between two resources (call them A&B).

Is there a way to alternate every other? Or perhaps 1/3 & 2/3?

I hope this makes sense to you as it does to me

 

[Scott Huish]

Can you post some sample data and expected results?

 

[MCosca]

Hmmm...thanks Scott, I'll do my best here.

so the process is to assign work to vendor based largely on location, but the end of the string is where i'm struggling. I would like to assign 1 unit to vendor A and 2 to vendor B straight down the list (of perhaps 500 items)...does the below help??

IF(W2="","",IF(W2="Close Even","U/W Process",IF(AND(F2=1,(LEFT(E2,7))=LEFT(E1,7)),X1,IF(OR(T2="GC - Practice",T2="General and Job-Specific Contracting"),"SML",IF(AND(P2>9999,T2="Media - DICE",J2="CA"),"Vendor C",IF(AND(W2="Physical",J2="CA"),IFERROR(VLOOKUP(K2,Sheet1!$C$2:$F$366,4,FALSE),IF(AND(W2="Physical",J2="CA",),"Vendor A","Vendor B")),"Vendor B"))))))