• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Recent content by IKHAN

  1. I

    Extract ip address row from a ip range and subnet mask

    Report @rlv01... Thanks for assisting. Have uploaded both Before and After files. Have added sample 5 rows data in column A. Have approx. 4000 rows of ip address in my original file.
  2. I

    Extract ip address row from a ip range and subnet mask

    Thanks. Works only for first row in sheet1,Doesn't check on other rows in sheet1
  3. I

    Extract ip address row from a ip range and subnet mask

    I found this online and tweaked a bit,,Getting run time error 13 and stops at 'ipArray = Split(ip, ".") ' >>> use code - tags <<< Sub CheckIPAddress2() Dim ws1 As Worksheet, ws2 As Worksheet Dim ip As String, startIP As String, subnetMask As String Dim ipRange As Range, cell As...
  4. I

    Extract ip address row from a ip range and subnet mask

    Hello .. I am trying to find a vba script for column A in sheet1 that will check an IP address in sheet2 column C (start of IP address) and column F (Subnetmask) and find if it falls into a range (or between). If IP available in range, I want to copy complete row into sheet1 column B. If IP not...
  5. I

    Data cleanup from row to column

    Thank you @p45cal ...Macro works as expected.
  6. I

    Data cleanup from row to column

    Thanks P45cal....Was looking for a vba macro to connect with other code
  7. I

    Data cleanup from row to column

    Hi Need assistance with copied router data into excel for cleanup. Data is more than 1000 rows a. Convert row data to separate columns b. Delete row\data with certain text "Network Next Hop Metric LocPrf Weight Path" c. Have highlighted scouple examples - delete row\text...
  8. I

    Ip address match and extract from subnet range

    Hello Need help with a macro to extract ip address from sheet2,sheet3... matching with the range in subnets in sheet1. In this sample file attached, have 2 sheets(sheet1,sheet2) Sheet1 has ip address with subnet (/xx) Sheet2 has ip address and other data In some cases, i have ip address in...
  9. I

    Index and Match for wrapped number

    When formula dragged down n across , if takes previous entries even thou column A(input sheet) is blank and it doesn't do the exact match. Attached test file with formula provided
  10. I

    Index and Match for wrapped number

    Hello, Having issues with index and Match for wrapped number in cell. Using below formula and works fine for single ip in both input sheet and Data sheet. =IF(ISNA(INDEX(Data!$B$2:$B$10,MATCH(input!$A2,Data!$A$2:$A$10,0))),"",INDEX(Data!$B$2:$B$10,MATCH(input!$A2,Data!$A$2:$A$10,0))) If...
  11. I

    Excel formula

    thanks
  12. I

    Excel formula

    Hello, Need assistance with formula When formula typed into cell =(O8-M8)/O8 gives =DIV/0! error when empty. Require cell to be blank. Thanks
  13. I

    vlookup for wrapped text contents in cell

    @Nebu .. Require exact match to be extracted instead of closest match
  14. I

    vlookup for wrapped text contents in cell

    Awesome..Thanks So much..
  15. I

    vlookup for wrapped text contents in cell

    Hello , Looking for assistance to extract row from matched data from sheet 2 Issue is - unable to lookup data if entry is wrap text or used ALT /ENTERin sheet 2 Using below formula =VLOOKUP($A2,Sheet2!$A1:$H8,3,FALSE) Attached sample file Thank you
Back
Top