Tagged: Excel
 This topic has 7 replies, 1 voice, and was last updated 10 years ago by Sarada Prasanna.

AuthorPosts

Sarada PrasannaGuest
Dear All,
I need some help regarding Excel.
Suppose I am having a sheet with cellids defined in both way.
I want to extract one way from that sheet.
Exp:Source Dest
—– —
1001 1051
1002 1051
1051 1001
1051 1002I want 1001 1051
1002 1051Like the above I want.
Please reply ASAP..
Thanks in advance.
Please
Sarada PrasannaGuestPlease tell me the formula and way to use.
I have tried a lot but failed to do so.
RexGuestHi,
select the column with source and dest together, click Data>Text to coulumns, delimited choose space and will divide into two columns, first one name it Source and second one name it Dest. Here you have two coulumns.
Regards,
Rex.Sarada PrasannaGuestDear Rex,
I think you have not got what I want to ask.
I am having a neighbor data sheet with Source ID in one column and Dest Id in another column.
The neighbors are defined in both way. I want to get the list of neighbors as one way.
Thanks in advance
RexGuestHi Sarada Prasanna,
sorry for missunderstanding.
Ok, try this way and you’ll find oneway HO:
In Excel put in column B Source Cell and in column C Target Cell. Assuming the first row is used for column names (sourcetarget, source, target, targetsource, OneWay). In column A (name it SourceTarget) use function CONCATENATE(B2,C2), so you merge source and target cell in column A. Take care that cell names in B and C have no spaces (use TRIM before, just in case). After that in column D (name it TargetSource) use again function CONCATENATE(C2,B2) and you’ll merge this time target and source (oposite than in column A). Of course you’ll do the same for row 3, 4 and so on till the last HO. Now, in column E use formula =VLOOKUP(D2,A:C,1,FALSE) (name it OneWay) and copy the formula down to the last row. That row which show the result #N/A is OneWay Handover.
I hope I helped you, tell us about results.
Regards,
RexRexGuestI forgot to mention that in MS Access is much easier and faster.
Regards,
RexBelingaGuestRex you know good info. I need some help with excel but need to know how drive test data in excel columns (L – AC) with headings (below)can be turned into piechart
BCCH1 BSIC1 RxLev1
BCCH2 BSIC2 RxLev2
BCCH3 BSIC3 RxLev3
BCCH4 BSIC4 RxLev4
BCCH5 BSIC5 RxLev5
BCCH6 BSIC6 RxLev6Data for BCCH1 BSIC1 RxLev1 looks like this:
BCCH1 BSIC1 RxLev1
717 14 67I want pie chart show eg BCCH 717 is common in an area not matter it be position BCCH1 or any other position up to BCCH6.
Do I need to format columns/cells for this?
Please if you can help, thanks in advance
Sarada PrasannaGuestDear Rex,
Thank you for your reply.
I think I couldn’t explain you my query. Sorry for that.
You have explained me how to find find One way neighbors from the Neighbor Lists.
But my question is–suppose I am having a list of neighbors defined in both way.
Suppose list of 5o both way.I just want to extract 25 one way out of those 50 (using Formula).
Please reply. .
Thanks in advance.

AuthorPosts