ANmarS - Search results

Excel/VBA expert since Sep 1997 (21 years 2 months)

We are moving ...

We are moving to another location, better, faster and more resources .... check it out ANmar.Systems

6 Q & A posts tagged with sort

Sat
Nov 19
2011

Sorting in excel ROW to COLUMN?

Hi,
I have some data in a column in which i want to sort as first row in first column, second row in second column third row in first column forth row in second column fifth row in first column sixth row in second column, and so on.

How can I do this?

Can anybody help?


Answer

I think I see what you are looking for
There is an Excel file called "2Cols to ColRow" that will convert your table

Check it out here
http://www.anmars.com/Work/?P=596630201

Note that this uses formulas

If this didn't help, please let me know, I can sure do if you send me more details

Saturday 11/19/2011 7:32:54 AM
Fri
May 14
2010

How would I automatically sort the selected cell in excel 2007.?

First in aphabetical order by office location and then by asscending order. What are the steps that this can be done.


Answer

There is a file that sort any table automatically using formulas
Once you have it, you can customize the sort easily

where is it? where is it?

Ah, here it is
http://www.vbaxlman.com/Files/?ID=HlCOfq…


VBAXLMan

Friday 5/14/2010 2:02:29 AM
Sun
May 2
2010

Trouble with sorting numbers on excel?

I'm trying to sort grade numbers on an excel worksheet, it was working for some columns and now I'm trying it again and it's not working. I'm highlighting all the numbers in the column and going up to Date, then sort. Any help?


Answer

Try not to select the cells
Instead click on one of the cells, and not all of them, then do sort

What is Excel telling you when you click on "Sort"?

Excel should suggest the sorting options based on your selection

Again, clicking one cell when you do Sort, can remove a lot of pain

VBAXLMan

Sunday 5/2/2010 12:25:22 AM
Thu
Apr 16
2009

It there a way(possibly write a macro) to automatically sort and delete data in Excel?

I am handling data which is a mix of numbers and letters, I need to sort by some value, delete, then re-sort and delete and so on, about 4-5 times.

Thanks,
Sharad


Answer

Here is an auto Sort free video lesson
http://file1.net/lesson.asp?id=XJTFWqI1c…
And this one
http://file1.net/lesson.asp?id=a17h833WW…

And this one one how to delete rows
http://file1.net/lesson.asp?id=b2wia4l8X…

VBAXLMan

Thursday 4/16/2009 3:28:55 PM
Tue
Jan 20
2009

Can someone help me with excel?

I know i should figure these questions out on my own, but i would like some help.
my questions are;
true/false
1. if you sort a last name column in ascending order, adams would come before williams
2. to fill in a series, a pattern must be established in the initial selection of cells

questions
1.What feature enables you to quickly fill in the days of the week or the months in a year
2. What menu is the sort command in
3. Does autoformat include borders, shading & data formatting
4. What must you indicate to sort data in excel

fill in the blank
1. to sort a worksheet by multiple criteria you must open the ______ dialog box
2. the ______ that indicate the boundaries of each cell in a spreadsheet do not appear on the printed worksheet
3. A(n) ______ is text that prints in the top margin of every worksheet page
4. The ________ tab in the format cells dialog box allows you to format numeric data with commas separating thousands
5. To give a worksheet a new name, you can right click the _____ and then select rename from the shortcut menu.



thankyouuuuu ! (:
17


Answer

Part one:
1- true
2- false

Part Two:
1- Edit > Fill > Series
2- Data
3- Yes
4- Sort by column

Part Three:
1- Sort
2- Grid lines
3- Header
4- Number
5- Sheet tab

VBAXLMan

Tuesday 1/20/2009 1:48:52 PM
Fri
Jan 16
2009

How can I sort a ROW alphabetically in Excel 2000?

I know very well how to sort a COLUMN in Excel 2000, but I have a ROW of names at the top of a spreadsheet that I'd like to sort alphabetically. How can I do this?


Answer

In Data > Sort
Select Options
And choose the option that says, Sort Left to Right

That is after you made the proper selection


VBAXLMan is back

Friday 1/16/2009 7:25:29 PM

Tags

History