[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 329
  • Last Modified:

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.
0
blueyes727
Asked:
blueyes727
  • 3
  • 2
1 Solution
 
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
 
dlmilleCommented:
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
 
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

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now