first instance

  1. F

    Display first instance of month

    Hi All I have a dates similar to below: <tbody> July August 02/07/2018 09/07/2018 16/07/2018 23/07/2018 30/07/2018 06/08/2018 13/08/2018 </tbody> I would like to know if there is a formula to display the month names above the first instance of that month occurring. Also the...
  2. A

    Fnd first instance of value in Column A, then add Row to list on another sheet

    Hey everyone! I have a large spreadsheet that has repeated values in Column A but unique Values in Column B, and I would like to find the first instance that one of the repeated values appears in column A and copy the entire row to a new sheet. I would like to create an entire list with each...
  3. S

    Find the first instance of a number and return value

    Hey guys! Ive been trawling the internet to try and find an answer to this question, but I've not come up with anything that's working as yet. I'm currently working on a spreadsheet which has 30,000 rows of data. Below is a simplified version of my column a, what I'm after is a formula that...

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
Back
Top