WOULD LIKE TO COUNT WHITE AND YELLOW BLOCKS IN EXCEL 2010 SEPERATELY

Hello,

In relation to my previous post, I was thinking, is there any way I can keep both white and yellow blocks with a border and count at the same time if I need to?  I can see this woudl be useful in the near future.

Then maybe be able to sort it by white or yellow count when I wish.  I think I'm pushing it here but I thought I would ask anyway.

Thank you,

Blueyes727.
blueyes727Asked:
Who is Participating?
 
dlmilleConnect With a Mentor Commented:
I think you need to scope this as a new question.  Please provide sample data and also describe a bit more what you're looking for.  E.g., What is a 30 letter sequence?  Does each letter represent a column?  I don't this this is sorting (at least not traditional ascending/descending) - a combinatorics algorithm would be needed.

Dave
0
 
dlmilleCommented:
Blueeyes727 - I hope this finds you well.

The attached has several ctrl-sequences

ctrl-i = initialize
ctrl-y = yellow dominate sort, with yellow columns boxed
ctrl-w = white dominate sort, with white columns boxed
ctrl-t = you choose which is dominate, both white and yellow are boxed

Please advise if this works for you.  PS - I sustain the 3 row white rows between blocks, if there are > 3 I delete those, if < 3, I leave them alone.

See attached.

Cheers,

Dave
COUNT-2-r7.xlsm
0
 
blueyes727Author Commented:
It works perfectly, it's awesome.  Thank you so much.

I just have one more question for you which I might have to post another question but I wanted to ask if you can do it first.

I have data from "A" to "AD" which I sometimes have to sort.  Is it possible to sort these 30 letter sequences in both blocks of 3, 4 and 5 rows high so that I get every combination possible.  For example, blocks of 3 rows high would give abc, abd, abe...all the way to aad then bcd, bce, bcf
...all the way to bad.  The amount of lines would be astronomical I guess that's why I thought I would ask first.

Thank you,


Blueyes727
0
 
blueyes727Author Commented:
This file works perfectly.

Thanks again for your help.

Blueyes727
0
 
blueyes727Author Commented:
Ok, I'll get an example file together and post it in a few minutes.

Thank you,

Blueyes727
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.