Welcome
Welcome to <strong>SpreadCE / Spread32</strong>.

You are currently viewing our boards as a guest, which gives you limited access to view most discussions and access our other features. By joining our free community, you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content, and access many other special features. Registration is fast, simple, and absolutely free, so please, <a href="/profile.php?mode=register">join our community today</a>!

new macro for sort rows...

Post your comments, questions, bug reports and feature requests here.

new macro for sort rows...

Postby harley64ve on Wed Oct 07, 2009 4:53 pm

How do I create a macro to sort rows based on column data f?
Someone can help me?
harley64ve
 
Posts: 9
Joined: Thu Apr 24, 2008 8:24 am

Re: new macro for sort rows...

Postby harley64ve on Wed Oct 07, 2009 9:10 pm

I try this but in Italian don't work...

=SELECT(!A2:G100)
=SORT(1,!B1,1,!A1,1)
=RETURN()

The parameters to SORT are:
- 1 - sort rows
- Sheet1!B1 - first key is column B
- 1 - ascending
- Sheet1!A1 - second key is column A
- 1 - ascending
harley64ve
 
Posts: 9
Joined: Thu Apr 24, 2008 8:24 am

Re: new macro for sort rows...

Postby stephenbye on Wed Oct 07, 2009 9:40 pm

In Italian that would be

=SELEZIONA(!A2:G100)
=DATI.ORDINA(1,!B1,1,!A1,1)
=RITORNO()

I will send you an example file.
stephenbye
Site Admin
 
Posts: 157
Joined: Sun Aug 12, 2007 11:56 pm


Return to General

Who is online

Users browsing this forum: No registered users and 0 guests

cron