+ Reply to Thread
Results 1 to 12 of 12

How do I make wild card functions within excel?

  1. #1
    Registered User
    Join Date
    10-08-2013
    Location
    Phoenix, Az
    MS-Off Ver
    Excel 2007
    Posts
    6

    How do I make wild card functions within excel?

    Hello, Does anyone happen to know how to make wild card functions within excel? For example, I need to set up a function that would compare all data in a specific column to all other data in the same column (or perhaps another one). For example, I'd want to have each date in the column compared to every other date in the column, and only return results if the dates are within a certain threshold of each other (+/- 3 days, 5 days, etc).

    If I can figure out how to do this, I'll then have to have the informaiton compared against an additional column to return a result.
    Perhaps there is a better way to accomplish this outside of functions? In any case, I'd greatly appreciate it if you could point me in the right direction.

  2. #2
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: How do I make wild card functions within excel?

    the wild card feature in excel is not used in this manner
    generally wildcard in excel refers to wildcard characters which can be used in functions themselves
    http://office.microsoft.com/en-au/ex...005203612.aspx

    it sounds like you require date between two dates
    see link example
    http://www.extendoffice.com/document...two-dates.html

    if you require specific help please post sample spreadsheet with input and expected results
    Last edited by humdingaling; 10-21-2013 at 06:59 PM.
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Registered User
    Join Date
    10-08-2013
    Location
    Phoenix, Az
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: How do I make wild card functions within excel?

    Thank you for looking at this humdingaling. The difference would be that the dates, wouldn't just be within a specified range, they would need to be compared to all the other dates in the column to see if any of the dates are within a range of any of the other dates. In effect it would be a moving goal post where it's comparing all dates against any other date to see if they are within a range of eachother. I can post a sample sheet if that would be helpful.

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,938

    Re: How do I make wild card functions within excel?

    Hi and welcome to the forum

    sample workbooks help to eliminate confusion (normally) between what you say (type) and what I hear (read)

    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

  5. #5
    Registered User
    Join Date
    10-08-2013
    Location
    Phoenix, Az
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: How do I make wild card functions within excel?

    Thanks, I went ahead and attached a sample of the types of dates I'd be working with. Please feel free to let me know if you need any additional info.
    Attached Files Attached Files

  6. #6
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,938

    Re: How do I make wild card functions within excel?

    A few comments/observations...
    1. why do you have merged cells in the sample? Merged cells cause more problems than anything else
    2. you have a list of dates, with nothing associated with them? It would help if you provided a before/after so we can see what you want
    3. Your dates include time. This could be problematic when comparing a date to a range of dates - time is a decimal of 1(day), so 7/1/2013 is less than 7/1/2013 00:00:01 AM

  7. #7
    Registered User
    Join Date
    10-08-2013
    Location
    Phoenix, Az
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: How do I make wild card functions within excel?

    Thanks for looking at it. I may need more help than I realized.

    1)How do I eliminate the merged cells from the entire sheet?
    2)I can provide the additional fields but really just want to start with having the dates compared to each other so I can take it one step at a time.
    3) Thanks for the info on the time. I did not consider this aspect. Is there an easy way to remove the time from the cell?

    Sorry for the confusion.

    A few comments/observations...
    1. why do you have merged cells in the sample? Merged cells cause more problems than anything else
    2. you have a list of dates, with nothing associated with them? It would help if you provided a before/after so we can see what you want
    3. Your dates include time. This could be problematic when comparing a date to a range of dates - time is a decimal of 1(day), so 7/1/2013 is less than 7/1/2013 00:00:01 AM

  8. #8
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: How do I make wild card functions within excel?

    Where are the dates you want to compare with?
    i only see list of dates in column A?

    unmerging cells leaves blanks behind...is that going to be an issue?
    ie A100 unmerged leaves A100 as 1/07/2013 10:38:58 AM and A101,A102,A103 as blank

  9. #9
    Registered User
    Join Date
    10-08-2013
    Location
    Phoenix, Az
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: How do I make wild card functions within excel?

    Exactly. This is why it seems confusing to me. The dates I'm wanting to compare to are also the dates within column A. I'm wanting to compare any date in column A to any other date in column A and the cell return a value only if the dates are within a certain time frame from each other (i.e. 1,2,3 days etc.). Another way to say this would be, I am wanting to compare all column A dates against all other column A dates by a specific criteria, such as "within 24hrs of any other date". Perhaps I am going about this the wrong way?

    The blank cells left by unmerging would be problematic but not as much as the merged cell lol.

    Thanks again for your input.

  10. #10
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,938

    Re: How do I make wild card functions within excel?

    lets take this in stages.

    To remove the merging, highlight column A, right-click into it, select Format/Alignment uncheck Merge - you may need to click it twice to make sure it is clear

    to remove time, use this in a helper column, copied down (I used B)...
    =IF(A2="",0,INT(A2))

    Now, apply filters...select Home tab/Editing/Sort and Filter
    click on the small down-triangle (either column), uncheck 2013. You will be left with a bunch of empty cells in A and 1/0/1900 in B
    delete all the remaining rows, click on the filter, select 2013 and you will be left with a list of clean dates

    You have only 1 date in your list so its a little hard to do the next step (comparing within a range)

  11. #11
    Registered User
    Join Date
    10-08-2013
    Location
    Phoenix, Az
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: How do I make wild card functions within excel?

    Excellent FDibbins! That's just what I needed. Appreciate the tip!

    Do you think there is a better way to go about comparing data within a range? Do you think creating a function is the best option for this kind of sorting?

  12. #12
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,938

    Re: How do I make wild card functions within excel?

    Sure thing

    OK can you provide a sample of what you would be working with (multiple dates), along with a few examples of what your expected outcome wouyld look like?

+ 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. [SOLVED] Cant get wild card ...*... to work in Excel VBA .
    By orozvik in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-13-2013, 12:10 PM
  2. wild card
    By jamrock in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-05-2013, 05:47 PM
  3. Wild Card Character search using Excel VBA
    By s.anurag1786 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-21-2013, 11:18 PM
  4. [SOLVED] Excel Replace Function with wild card: Possible?
    By alfykunable in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-27-2011, 12:59 AM
  5. Wild card in Excel SQL
    By tkuia in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-10-2010, 06:36 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