Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
Eric Gilson  
#1 Posted : Friday, May 3, 2013 6:52:19 PM(UTC)
Eric Gilson
Rank: Member

Reputation:

Groups: Registered
Posts: 24
Man
Location: Edmonton

HI Guys

I have soil data from a mine in which they have taken samples in 5 m ranges.  When we create the chem table with the Depth Range for each sample, the rows in the table appear as such:

 0-5

10-15

15-20....

5-10 (this is out of sequence....)

55-60 etc.

There doesn't appear to be an easy way to sort this in Excel (although not an expert in any means in Excel). Any suggestions on how to work around this issue?

Thanks

Eric

Warwick Wood  
#2 Posted : Tuesday, May 7, 2013 1:56:04 AM(UTC)
Warwick Wood
Rank: Administration

Reputation:

Groups: Registered, Administrators
Posts: 498
Man
Location: Byron Bay

Was thanked: 19 time(s) in 19 post(s)

Hello Eric,

If you include Sample Depth (Avg) in the output, listed before the range, it will sort by that value, which will give you what you need.  You can then remove that data in Excel after export.  We will look into automating this process whenever Sample Depth Range is included.

Regards,

Warwick

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.