find next value formula

  1. L

    Always increment to the next largest number in a series - even after sorting

    This answer may exist and I just don't know the right combo of Google search terms to find it because I've tried everything! I have a "to do" list and I want to add a unique index number for each new entry BUT I'm going to be sorting the list for due dates and priorities. How can I...
  2. Default300

    ?Error 91 on: Loop While Not Range Is Nothing And Range.Address <> String

    Full Code can be posted if required. It is derived from an apparently functional Find / Find Next Do / Loop While routine that I found online. This is the close of the Loop. The Loop should be exited if either there are no more cells matching search criteria (first condition); or if the...
  3. K

    Formula to find next value

    Is there a formula that will find the next matching text in a column and return the text from the column to the right of it? Like a vlookup but I need it to continue on and find every one of them and return each thing that matches that row that the next one shows up in. Thanks in advance...

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