Need help : Excel

[edinburgh]

Hi,
I need your advice on how to use excel for the following purpose:

sector siteID site name
3 0001 siteA
1 0001 siteA
2 0001 siteA
2 0002 siteB
2 0003 siteC
1 0003 siteC

How can I sort out to see sector 1, 2, 3 in order in excel?

I wan to see like this:

sector siteID site name

1 0001 siteA
2 0001 siteA
3 0001 siteA
2 0002 siteB
1 0003 siteC
2 0003 siteC

Thanks.
BR,
Edin

[Artyom]

Hi!
This is simple task. Just add another one column right to the table with “=SiteA0001_3” (via =C2&B2&"_"&A2), you will get the following:



3
0001
siteA
siteA0001_3


1
0001
siteA
siteA0001_1


2
0001
siteA
siteA0001_2


2
0002
siteB
siteB0002_2


2
0003
siteC
siteC0003_2


1
0003
siteC
siteC0003_1




Than sort this table by right (new) column and you will get the following:



1
0001
siteA
siteA0001_1


2
0001
siteA
siteA0001_2


3
0001
siteA
siteA0001_3


2
0002
siteB
siteB0002_2


1
0003
siteC
siteC0003_1


2
0003
siteC
siteC0003_2




And at the end, delete the last column.:p

[seedweb]

Hi edinburgh,
Can't order by site name then by sector?
BR,
Seedweb

[sedicla]

Hi edinburg.
To me the best solution is install the ASAP utilities http://www.asap-utilities.com/download-asap-utilities-free.php?file=1
this is a very good add in for excel you then can find a tab in excel ASAP open it and find Range/Advanced Sorting
next step you will see it easy.
Sort column A by value column C by value and column D by value.
It´s donne don't forget to select all data that ypu want to sort.
Best Reguards.

[tomsg]

Hi,
I need your advice on how to use excel for the following purpose:

sector siteID site name
3 0001 siteA
1 0001 siteA
2 0001 siteA
2 0002 siteB
2 0003 siteC
1 0003 siteC

How can I sort out to see sector 1, 2, 3 in order in excel?

I wan to see like this:

sector siteID site name

1 0001 siteA
2 0001 siteA
3 0001 siteA
2 0002 siteB
1 0003 siteC
2 0003 siteC

Thanks.
BR,
Edin

Hope this help. If you want to sort by more than 3 conditions you need Excel 2007 or use combiner as Artyom.

[colle13]

Hi edinburgh,

You should use advanced sort. Look at the snapshot for how it's done in Excel 2010.

27672

[KidAngel]

27673

sort site name first then sector

[edinburgh]

Thanks everyone.

If I want to get site name, site ID with site address, which way is the best?

I want this in another sheet. I don't want to see cell and sector ID.

It may be too easy for you. But I want to know different ways from member.
Thanks.
BR,
Edin

[tomsg]

It is up to what database you have then you can use VLOOKUP function (sometimes I use INDEX) to get it all. the one you use (SiteId or sitename) will use will be included in both sheets and that one (Site ID or site name) will be unique.

For example, if you have a excel sheet contains sector data like SiteID, Site Name, Sector, Azimuth,... and another one contains SiteID,Address, Lon, Lat,... SiteID is included in both sheets you can use SiteID for vlookup.

Hope this help.

Thanks everyone.

If I want to get site name, site ID with site address, which way is the best?

I want this in another sheet. I don't want to see cell and sector ID.

It may be too easy for you. But I want to know different ways from member.
Thanks.
BR,
Edin

[sedicla]

My advice is vlookup the best funtion ever.

Br