Advanced Sorting

[Guest]

Hello
I have posted a question about sorting
I am wondering is it possible to sort a data with the following format (in excel)
Date..Time..Color..Freq
.2.....3......B.....C
..............A.....D
..............C.....P
Date..Time..Color..Freq
.3.....4......D.....A
..............D.....Q
..............O.....R

...means blank cells

so I can sort Date or Time and move the corrisponding data all together without changing the original format

Thanks in advance

 

[Mark W.]

A precondition for my recommended approach is that you remove all repeating titles (i.e., Date..Time..Color..Freq). If you're unwilling to do that then perhaps someone can write a custom VBA for you.

 

[Guest]

I need to figure out how to sort the spects for a company
There are thousands of records(thousands of headers) in a spect.
So is writing VBA the only way to do the sorting with headers?
Do you know how to write this kind of VBA by any chance?

 

[Mark W.]

I'm sorry I only dabble in VBA.

 

[Guest]

I also tried to sort without the header but I still can't do the sorting.
For example
Before sorting:
Date Time Color
22....33...44
...........22
...........33
11....22...44
...........55
...........66
After sorting:
Date Time Color
11....22...22
22....33...33
...........44
...........44
...........55
...........66
I need to get a sorting like
Date Time Color
11....22...44
...........55
...........66
22....33...44
...........22
...........33
1. Select cells A1:B7 and choose the Edit | Go To... | Special... Blanks menu command.

2. Without altering the selection Control+Enter the formula, =A2, into cell A3.

2.5 Select columns A:B and perform Copy/Paste Special... Values.

3. Select columns A:B and press [ Tab ] until cell A2 is the active cell.

4. Choose the Format | Conditional Formatting ... menu command.

5. Setup a "Formula Is" condition using the formula, =A1=A2, and format the Font color to match the cell background color (white, in my case).

What does step 5 do? I can't see any changes after I finish that step.
And What should I do after I finish those 5 steps?
Should I select all the data and press sort button or should I just select the data under first 2 columns?

 

[Mark W.]

These results suggest that steps 1 thru 2.5 weren't performed properly. Step 5 preserves the appearance of your original data.

 

[Guest]

So what should I do after those 5 steps?
Those 5 steps are just prepare me for soring right

 

[Mark W.]

On 2002-03-01 12:20, Anonymous wrote:
So what should I do after those 5 steps?
Those 5 steps are just prepare me for soring right

>So what should I do after those 5 steps?

Do your sort on columns A and/or B.

>Those 5 steps are just prepare me for soring right

Yes.

 

[Guest]

I did those 5 steps over and over again and I still couldn't get my data to sort properly
Anyways, thank you so much for helping Mark