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

Nov 19

Sorting in excel ROW to COLUMN?

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?


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

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
May 14

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.


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…


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

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?


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


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

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.



Here is an auto Sort free video lesson…
And this one…

And this one one how to delete rows…


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

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;
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

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 ! (:


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


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

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?


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