Generic selectors
Exact matches only
Search in title
Search in content
Post Type Selectors

Regarding Excel

Tagged: 

Viewing 8 posts - 1 through 8 (of 8 total)
  • Author
    Posts
  • #64785
    Sarada Prasanna
    Guest

    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 1002

    I want 1001 1051
    1002 1051

    Like the above I want.

    Please reply ASAP..

    Thanks in advance.

    Please

    #64786
    Sarada Prasanna
    Guest

    Please tell me the formula and way to use.

    I have tried a lot but failed to do so.

    #64787
    Rex
    Guest

    Hi,
    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.

    #64788
    Sarada Prasanna
    Guest

    Dear 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

    #64789
    Rex
    Guest

    Hi 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,
    Rex

    #64790
    Rex
    Guest

    I forgot to mention that in MS Access is much easier and faster.
    Regards,
    Rex

    #64791
    Belinga
    Guest

    Rex 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 pie-chart

    BCCH1 BSIC1 RxLev1
    BCCH2 BSIC2 RxLev2
    BCCH3 BSIC3 RxLev3
    BCCH4 BSIC4 RxLev4
    BCCH5 BSIC5 RxLev5
    BCCH6 BSIC6 RxLev6

    Data for BCCH1 BSIC1 RxLev1 looks like this:

    BCCH1 BSIC1 RxLev1
    717 14 -67

    I 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

    #64792
    Sarada Prasanna
    Guest

    Dear 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.

Viewing 8 posts - 1 through 8 (of 8 total)
  • The forum ‘Excel Boardroom’ is closed to new topics and replies.