none
Rearranging the Data based on condition RRS feed

  • Question

  • Hi All,

    I have raw data in below format around 20K to 30K rows and I need to rearrange the rows based on below mentioned condition :-

    1)  I need to filter on Ring name for example I filter Ring A05.

    2) Then I filter 1 by 1 to ATN loop back column for example : I filter 10.35.201.1.

    3) Then I need to arrange interface description(colum G) containing "GigabitEthernet0/2/16" orGigabitEthernet0/2/0 always in starting(top) of the data of that particularATN loop back filter .

    4) Then I need to arrange interface description(colum G) containing "GigabitEthernet0/2/17" orGigabitEthernet0/2/1 always in Last of the data of that particularATN loop back filter .

    5) Then I need to conditional format the rows in two colors.

        i) if its starting row and End of any different Ring then that row needs to be filled with dark grey color.

        ii) if its starting and end of any different ATN ring then that row needs to be filled with light grey color.  

    6) If any of the condition not satisfied mentioned in point 3 & 4 then no sorting required, Just I need to marked those ATN IP in Red color.

    I also attached the sample file and output result sample in below given link.

    http://1drv.ms/1KLXmmj

    Can anybody suggest me any Advance sorting or Macro based solution for the same. currently its taking almost 2 days to arrange the data in this format.

    Thanks in advance for your valuable suggestions.

    Regards,

    Rajender

    Friday, October 2, 2015 11:13 AM

Answers

  • Hi All,

    I found the solution for my query in below given link.

    if anyone have similer kind of query or issue, then please refer the below given link.

    link

    Regards,

    Rajender

    • Marked as answer by AskQuery1984 Tuesday, December 19, 2017 12:40 PM
    Tuesday, October 6, 2015 3:23 PM

All replies

  • If it was me I would use SQL to do what your asking.  You treat the data as a table and make a query based on your criteria and output the query to another sheet.  The sql can be very complex.  Here is a useful link:

    Excel & SQL

    Friday, October 2, 2015 2:02 PM
  • Dear,

    Thanks a lot for your valuable suggestion :-)

    Regards,

    Rajender

    Tuesday, October 6, 2015 3:22 PM
  • Hi All,

    I found the solution for my query in below given link.

    if anyone have similer kind of query or issue, then please refer the below given link.

    link

    Regards,

    Rajender

    • Marked as answer by AskQuery1984 Tuesday, December 19, 2017 12:40 PM
    Tuesday, October 6, 2015 3:23 PM