ChOOSE() or SWITCH() or some other function.

[zoharb]

Respected
say I have a list of 10000 entries of products and has to assign category of each on basis of some criteria(Something like --rotation rate or price).
I assign each product a category(Randomly as placement of the product is not static in list) once in that list (like hard coding) ,
---for the rest it will assign category based on the categories previously(or even afterwards in that list) hardcoded using CHOOSE or SWITCH or some other function
Zohar Batterywala

 

[Peter_SSs]

Reading your post several times I have no idea what your data looks like or what results you would want. What about some small dummy sample data and the expected results with XL2BB

(If you have trouble with XL2BB review the "XL2BB Icons greyed out" link in the 'Known XL2BB issues' section near the top of theXL2BB Instructions page linked above.)