View Full Version : Need help : Excel
edinburgh
2012-05-30, 04:25 PM
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
2012-05-30, 04:50 PM
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
2012-05-30, 05:18 PM
Hi edinburgh,
Can't order by site name then by sector?
BR,
Seedweb
sedicla
2012-05-30, 06:05 PM
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
2012-05-30, 06:09 PM
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
2012-05-30, 06:10 PM
Hi edinburgh,
You should use advanced sort. Look at the snapshot for how it's done in Excel 2010.
27672
KidAngel
2012-05-30, 06:35 PM
27673
sort site name first then sector
edinburgh
2012-06-01, 10:26 AM
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
2012-06-01, 11:21 AM
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
2012-06-04, 05:50 PM
My advice is vlookup the best funtion ever.
Br
vBulletin® v4.2.5, Copyright ©2000-2024, Jelsoft Enterprises Ltd.