conditional search

  1. J

    Conditional Find > Replace Macro

    I have an excel (generated from a polling app) in this format: Person 1 Person 2 Person 3 Person 4 Option A Yes Yes Option B Yes Option C Yes What I...
  2. G

    Using a conditional vlookup

    Hi all, I've had a little search, but maybe my brain's a little frazzled and I'm not quite understanding how to put this into practice. My table is below. Essentially, I want to find the Session ID. Session IDs are linked to an Event ID. OK, so column C is where I need to input the...
  3. E

    Conditional formatting for cells in Col A based on text on another cell (N1, N2, N3)

    Hi, Col A has 5000 data points, what I want to do is to format a few data points based on the words that I type in another cell(s), in this case N1, N2, N3. Here's an example: Col A: baseball bats unique engagement ring cement and concrete build new business analyze unique ring tones...
  4. D

    Getting different result According to contents of columns

    <colgroup><col width="64" span="4" style="width:48pt"><col width="64" style="width:48pt"></colgroup><tbody></tbody> I am trying to get result in a column based on contents of previous 4 columns. For example as per table below, if there is value 1 in either of first 4 columns of same row, I want...
  5. A

    Using Macro to Find a Value within X Characters of another Value

    I currently have a Macro that will search through source data for any values that are built into an array I have constructed. It will also put an X in the column next to the data when it is found. What I am looking to add to this process is a conditional or tiered search. Ideally, I am...

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