grouped rows

Hi I Have been trying to sort a grouped rows AB1NumberLetter26B39B45C58A63B72A810C Nonetheless when I do they loose the groups and became mixed up How I can fix it? Cheers

Hi all, This is in some ways a follow-up to an earlier thread. I was able to create a grouped index number to repeat at every N rows (which effectively partitions my groups), but now I am trying to figure out how to create a column where the first entry in the `Location` column of each `Group`...

I'm analyzing Mechanical Turk results. Each assignment was done three times, and I want to find all sets of three assignments that were agreed upon by the majority (2/3 or 3/3) of respondents. Here's the basic setup: <tbody> NAME STATUS Org 1 active Org 1 not.active Org 1 not.active...

Hello All! I have been searching these forums and my friend Google for any indication as to why I am having the issue at hand (user error most likely). I have created a Macro to email a range of cells to a mailing list of my choosing. However when I email said range, which includes grouped...

Folks: How do I "ActiveCell.End(xlUp).Select" without the "End" or ActiveCell.Offset(-1, 0).Select to the next visible cell? I know "ActiveCell.End(xlUp).Select" gets me to the next populated cell or end of contiguous data and ActiveCell.Offset(-1, 0).Select gets me to the cell right above my...