not exact

  1. Z

    i need to filter data that contain what the user's input, not only begins with user's input or exact

    hi i was wondering if anyone can edit my code. the code here only filter if the data only if it begins with what the user input Example: Data: dean winchester sam winchester john winchester mary winchester Now - input: winchester result: no data want: input: winchester result: dean...
  2. G

    Looking for a smarter reference function

    I use a function close to the following to return valuesfrom sheet 2 where the Name and Price on sheet 2 match sheet 1. <o:p></o:p> <o:p></o:p> Index(Sheet2A:A,Match(1,(Sheet1B2=Sheet2B:B)*(Sheet1C2=Sheet2C:C),0)) <o:p></o:p> If it tries to return a value from Sheet 2 that matchesSheet 1...
  3. L

    vLookup For Cells w/ Date & Time, but Give or Take X Seconds

    Hi All, I've got a list of times in Column A on Sheet 1 and a list of times in Column A on Sheet 2. These times are in MM/DD/YYYY HH:MM:SS format I want to use vLookup for the times on Sheet 2 to look at the list on Sheet 1 and return the Sheet 1 value if a match is found HOWEVER The issue...
  4. srizki

    Find not exact amount

    I am trying to find an amount closed to $1,174 + - $50, or any amount close to this amount.

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top