find across row

  1. B

    VBA: Search for a value down a column, then across entire row, and then offset. Then copy and paste found values onto different sheet

    Hi, I have a reference sheet called 'Hosts List' which has one row per host. It contains lots of term dates which are grouped by academic year. There are six columns of term dates per academic year which go across the sheet, with multiple academic years. At the start of each group of date...
  2. C

    how to use goal seek for multiple columns that match search criteria

    I am trying to use a goal seek for every column that contains “2700” in row 38. If a column has “2700” in row 38, I’d like row 130 to equal 5 by adjusting row 50. Please note, in the row 38 contents it can be 2700 or a number of 2700 and letter combinations, which is why I have to do a search...
  3. D

    Find Values in One Cell Then Delete Entire Row

    Hello, I'm using Excel 2013. I'm looking for a VB macro solution. I want to find Hello in any cell. Then I want to delete (clear contents) that cell & every cell along the same row moving to the right until the end of the worksheet. I want to loop through the entire used range of the worksheet...
  4. K

    Find and Replace - Adjacent Columns

    Hello. In excel, after I search and click "find all", I want to see the matching adjacent column values in the results list (so I can compare the results). Is there a way for me to archive something like this? Or perhaps a software that does this? Thanks!
  5. D

    Find Values in 2 Cells on the Same Row & Clear Contents

    Hello, I'm using Excel 2013. I'm looking for a VB macro solution. I want to find <b>Hello</b> in any cell and find <b>Good morning</b> in any other cell along the same row. Then I want to delete (clear contents) all values in all the cells in between <b>Hello</b> & <b>Good morning</b>. I want...
  6. J

    Arrange cells by ignoring blanks

    I have a row of data that is organised the following way: Example A, Blank Cell, Blank Cell, Example B, Blank Cell, Blank Cell, Example C......etc The number of blank cells between values varies. I want to copy cells into a new sheet in the format: Example A, Example B, Example C I can use...
  7. A

    Find text string Across Multiple Cells in a Row

    Hi, I want to see if a text string is contained in any the text in any cell in a row i tried : =FIND("gift",A3:U3,1) Did not work. I tried defining a name for the range and putting it where there range is in the formula, also did not work. Any ideas for doing this in a formula ? I feel like...

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