Does anyone know how to do triple OR statements in excel?
Or maybe have a dozens spreadsheet I can use.
I want to have the dozens from numbers listed in one column like something like this,
1
3
2
1
2
3
2
2
you can use VLOOKUP or COUNTIF function.
Quote from: starkygold on Mar 24, 11:49 AM 2013
you can use VLOOKUP or COUNTIF function.
Thanks I figured it out. Back to testing
Or a brute force way would be something along these lines. Still fast enough to update a few hundred thousand decisions with no problems.
=OR(B5=1,B5=4, B5=7,B5=10,B5=13,B5=16,B5=19,B5=22,B5=25,B5=28,B5=31,B5=34)
Something like that will pick all of the "first column" numbers from a result at (B5). Obviously just copy/paste it all the way down the sheet for an unlimited amount of random or previously copied numbers.
I've actually built and used a nice sheet that tracks every number at every position with this basic calculation!
Every column, dozen, EC and pretty much any sector or combination of numbers you could want and it's all done with the "=OR" function.
AD