non-adjacent

  1. M

    Average non-adjacent cells (with criteria)

    Hi, I am stuck on creating a formula for the below and would be really grateful for some assistance: The table has 4 columns. Column A is text e.g. Apples, Bananas etc. Columns B,C,D are currency. More than one row in column A will contain Apples. I want to find all rows which state Apple...
  2. T

    UNIQUE and CHOOSE for non-adjacent columns

    Hi Everyone, I have an issue with a formula and I have been told we have all the experts in the world to answer to this question. I am trying to get a list of unique values for 2 non-adjacent columns. I have tried the formula below but it doesn't work. It only spills the result for one single...
    • Tarek78
    • Thread
    • dynamic array non-adjacent unique unique columns
    • Replies: 3
    • Forum: Excel Questions
  3. Z

    VBA Macro to copy non-adjacent cells to a different workbook

    I am currently working on an integrated set of workbooks, where I need to transfer data values between workbooks. In order to do so I need a VBA Macro that can copy non-adjacent cells (ex. the locations of the cells are J4, J8, J12, J16....etc) and insert it in the other workbook with a...
  4. B

    Rank (Spearman) Correlation of Non-Adjacent Values in Excel in Single Formula

    Rank (Spearman) Correlation of Non-Adjacent Values in Excel in Single Formula 1. In a single formula, I am trying to get the Rank (Spearman) correlation between two arrays. One of the arrays contains non-adjacent values. I can get the Pearson correlation with this formula...
    • BuckChuker
    • Thread
    • arrays correlation non-adjacent rank rank correlation spearman
    • Replies: 8
    • Forum: Excel Questions
  5. M

    INDEX and MATCH for MAX value of non-adjacent range in seperate sheet

    Hi I'm having some problems and was hoping I might get some help here having come up with nothing from searching the forum I want to return the text string in a the Cell to the left of the highest value cell in a non-adjacent range from another worksheet to the one where I'm entering the...
  6. L

    Unique value list from 5 different non-adjacent columns

    hi good people, I amsearching but appear to only find help with text in different columns...I have numbers in 5 non-adjacent columns and need a unique list..please can someone assist with a formula, or maybe an easier route which would be VBA?..columns are: E, H, L, P and S..thank you all very...
    • Legacy 287389
    • Thread
    • columns easier list non-adjacent unique
    • Replies: 3
    • Forum: Excel Questions
  7. I

    Sumifs for non-adjacent arrays of data

    Hi I'm a long time spectator, first time poster. My question has perhaps been answered elsewhere. But I've struggled to find its solution online, so any help would be much appreciated. I'm searching for a function that operates like sumifs() for non-adjacent arrays of data that are separated...

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