Consulting

Results 1 to 19 of 19

Thread: Formula help please

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Moderator VBAX Master austenr's Avatar
    Joined
    Sep 2004
    Location
    Maine
    Posts
    2,033
    Location

    Formula help please

    Im trying to create a searchable combo box on a worksheet. There is a #Value error in cell F7

    =$D$2:INDEX($D$2:$D$12,COUNTIF($D$2:$D$12,"?*"))
    Does anyone see the error? The issue seems to be the wildcard "?*" Workbook is attached. Thanks.

    If I can get this to work is there a way to do this in a userform?
    Attached Files Attached Files
    Peace of mind is found in some of the strangest places.

Posting Permissions

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