condition to select cells

  1. F

    Reference to cells that meet a condition

    Hi, I have the A column with 215 rows and each row can contain no value ("") or 1. I should select all rows with 1 and copy the 5 cells on the right on a different column. So, for example, if the value 1 is in A5, A34, A55 and A89, I should copy B5:F5 in C1 (C1:G1), B34:F34 in C2 (C2:G2)...
  2. M

    Interesting, maybe unanswerable CountIf Question?

    I have two columns: The first is the volume for a stock and the second is that stocks price at that volume when it touched a support or resistance level. Volume Turning Point Price 9795000 520.03 9826700 0 12596300 0 22707400 0 19658600 0 12064000 0 13741600 531.91 11204400 0 19073700 0...
  3. J

    Creating List of Distinct Values with 1 condition for very large data set

    Hello, I've used this site and forum extensivly to solve issues for a dashboard I'm building, but can't find a good solution to the following: Creating a list of distinct values (removing all duplicates) when a condition is met. I know there are ways to do this with Index formulas, but my data...
    • Jayy2121
    • Thread
    • condition to select cells distinct values formula calculation
    • Replies: 15
    • Forum: Excel Questions
  4. T

    write to txt despite blanks & how to choose certain data

    Hey all, I am a new member here and this is my first post. I am trying to read an excel sheet and write it to txt file. I had 2 questions. 1. How to make the macro read all my rows despite encountering blanks in between data and write to txt. 2. While reading the values,if I get...

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