Test for less than
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Test for less than

  1. #1
    MrExcel MVP Rick Rothstein's Avatar
    Join Date
    Apr 2011
    Location
    New Jersey, USA
    Posts
    32,312
    Post Thanks / Like
    Mentioned
    49 Post(s)
    Tagged
    15 Thread(s)

    Default Test for less than

    Code:
    Function WithinSpan(CellsToCheck As Range, DashedSpan As String) As String
      Dim V As Variant, SpanLimits As Variant
      For Each V In Split(DashedSpan, ",")
        SpanLimits = Split(V & "-" & V, "-")
        WithinSpan = WithinSpan & "< a>" & Replace(Application.Trim(Join(Application.Transpose(Evaluate(Replace("IF((0+@>=" & SpanLimits(0) & ")*(0+@<=" & SpanLimits(1) & "),@,"""")", "@", CellsToCheck.Address(0, 0)))))), " ", "< a>") & ""
      Next
    End Function
    Last edited by Rick Rothstein; Jun 12th, 2018 at 11:19 PM.
    Rick's "mini" blog... http://www.excelfox.com/forum/f22/
    .
    Want to post a small screen shot? See Part B here.

  2. #2
    Board Regular Worf's Avatar
    Join Date
    Oct 2011
    Location
    Rio, Brazil
    Posts
    3,293
    Post Thanks / Like
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Test for less than

    XML test:

    Code:
    
    
    OK
    
    street_address
    1600 Pennsylvania Ave NW, Washington, DC 20500, USA
    
    1600
    1600
    street_number
    
    
    Pennsylvania Avenue Northwest
    Pennsylvania Ave NW
    route
    
    
    Northwest Washington
    Northwest Washington
    neighborhood
    political
    
    
    Excel 2013 / Windows 8.1 (home)
    Excel 2013 / windows 7 (work)


User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

DMCA.com