single value

  1. R

    SREPEAT

    SREPEAT is a simple repeating solution that spills repeats, at the specified number of rows and/or columns, of any single value, including errors or blanks, whether or not enclosed in array brackets SREPEAT takes three parameters, one required and two optional, as follows: A) The first...
  2. 2

    VBA Convert Range to into explizit values

    Hello, apparently I can't find the correct search string to solve my problem (I am completly new to VBA). I got the following spreadsheet and want to convert the ranges to single values without copy/paste hundrets of values. This is how my spreadsheet looks like: Value1 Range from...
  3. D

    Define a variable range, analyze and produce two results

    I'd appreciate some help with this problem, I'm brand new to Macros, but pretty godd with formulas, however this thing has got me flummoxed! Here's a sample my data: <TABLE style="WIDTH: 480pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=640><COLGROUP><COL...
  4. T

    Single value in entire array check

    Hi! I've got an array with a load of dates that might be the same. I need to check if they are all the same, and return a true/false or similar. Is there a single cell command that will let me do this, or will i have to have to use nested IFs? (Editing the dimensions of the array beeing...

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