if empty

  1. R

    NTIMES

    NTIMES returns the values that occur at the specified number of times with full control over data types(s) inclusion/exclusion/replacement (The code is modular (as all my other functions) allowing for easy reusing/swapping/optimizing over time. See all the modules below, after the description)...
    • Rnkhch
    • Thread
    • exclude types if empty include types n times number of times replace with times unique xunique
    • Replies: 6
    • Forum: Excel LAMBDA Functions
  2. R

    PROCESS

    PROCESS resizes any input reference into an array/range of any desired size (could be considered as the reverse of LIN/TOROW/TOCOL) with options for output size/style and full control over data type(s) inclusion/exclusion PROCESS was developed primarily to enable resizing of the input reference...
    • Rnkhch
    • Thread
    • data type data types exclude types if empty include types replace with resize resize array resize range
    • Replies: 11
    • Forum: Excel LAMBDA Functions
  3. R

    INDEX.Nth

    INDEX.Nth returns (every) nth element(s) (starting at the desired position) from a one-dimensional array and provides output options and full control over data type(s) inclusion/exclusion (The code is modular (as all my other functions) allowing for easy swapping/optimizing over time. See all...
    • Rnkhch
    • Thread
    • data type data types every nth element every nth elements exclude types if empty include types index nth element nth element starting at nth elements nth elements starting at replace with
    • Replies: 7
    • Forum: Excel LAMBDA Functions
  4. R

    XUNIQUE

    XUNIQUE is a powerful and straightforward alternative to the built-in UNIQUE with full control over data type(s) inclusion/exclusion (The code is modular (as all my other functions) allowing for easy swapping/optimizing over time. See all the modules below, after the description; and download...
  5. R

    LIN

    LIN is a powerful array/range linearization alternative to the built-in TOROW/TOCOL with several options and full control over data type inclusion/exclusion (The code is modular (as all my other functions) allowing for easy swapping/optimizing over time. See all the modules below, after the...
    • Rnkhch
    • Thread
    • array linearization convert to column convert to row exclude types if empty include types linearization range linearization replace with scan by scan type tocol torow
    • Replies: 4
    • Forum: Excel LAMBDA Functions
  6. R

    FLIP

    FLIP is a powerful range/array flipping solution with full control over data type(s) inclusion/exclusion in the output (The code is modular (as all my other functions) allowing for easy swapping/optimizing over time. See all the modules below, after the description) FLIP takes six parameters...

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