+ Reply to Thread
Results 1 to 2 of 2

sorting difficulty in a text file

  1. #1
    Registered User
    Join Date
    05-11-2016
    Location
    london
    MS-Off Ver
    2013
    Posts
    1

    sorting difficulty in a text file

    Radius as a function of phase at a certain 1.072GHz

    i have a txt file in which i have the following structure many subtables in which every subtable is characterized by a certain radius

    i need to collect only one row from each subtabe (at a certain 1.027GHz)\
    and to make a table with a structure of which consists of to columns'so for this particular example i need a result
    i need to go to each subtable and collect the phase for that frequency and say what radius gives me this phase in that frequency

    for example for these to big subtables i need to get one subtable as follows


    R argument
    1 53
    1.36 36


    Frequency / GHz argument (R=1)
    1 58.126722
    1.009 57.482842

    1.054 54.306128
    1.063 53.678961
    1.072 53
    1.081 52.432413
    1.09 51.812946
    1.099 51.195945
    1.108 50.581382
    1.117 49.969205
    1.126 49.359379
    1.135 48.751861

    Frequency / GHz argument (R=1.36)
    1 74.192104
    1.009 73.736473
    1.018 73.285743
    1.027 72.839935
    1.036 72.399079
    1.045 71.963186
    1.054 71.532284
    1.063 71.106413
    1.072 36
    1.081 70.269919
    1.09 69.859394
    Last edited by robert23; 05-11-2016 at 10:38 PM.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    51,288

    Re: sorting difficulty in a text file

    Hi, welcome to the forum

    To best describe or illustrate your problem you would be better off attaching a dummy workbook. The workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

    To attach a file to your post,
    click advanced (next to quick post),
    scroll down until you see "manage file",
    click that and select "add files" (top right corner).
    click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

    Once the upload is completed the file name will appear below the input boxes in this window.
    You can then close the window to return to the new post screen.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Difficulty with CountIFS using text string
    By Groovicles in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-05-2015, 08:21 PM
  2. VBA 64 bit Excel, difficulty opening a file
    By londonwelsh in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-30-2014, 12:51 PM
  3. [SOLVED] Difficulty getting monetry value in 2DP within a text string
    By Deventus in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-20-2013, 08:36 AM
  4. [SOLVED] Difficulty in copying fomula from one file to other file
    By brandedadnan in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-16-2013, 02:48 AM
  5. [SOLVED] Having difficulty with the top rows in my spreadsheet being frozen and not sorting
    By Rob Scott in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-13-2012, 05:42 PM
  6. sorting a text file
    By hvalhund in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-05-2011, 05:44 AM
  7. difficulty writing code for changing font color if cell contains specific text
    By curbster in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 08-13-2009, 03:23 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1