non adjacent cell

  1. J

    Swap Array for Non-Contigous range in MIN(IF formula

    Hi All, I have the following formula which works, but the ranges that I am using are now broken up. Is there a way to put in a non-contiguous range in their place? =MINIFS(B5:B16,C5:C16,">"&0) Basically what I am trying to do is pull through the min date where there is a result next to...
  2. A

    Copying VLOOKUP formula with non-contiguous entries across multiple workbooks

    I'll try to explain this as concisely as possible. I have been given the task of cross-referencing several workbooks and creating a new, more easily-understandable excel document to be distributed internally within the company. It occurred to me that it would go much faster if I could apply a...
  3. C

    quartile calculation relative to a multiple, non-contiguous cell range

    Goodmorning , I have to calculate the first quartile (25 percentile) and the third quartile (75 percentile) of a multiple, non-contiguous cell range. While calculating the minimum and maximum of the same non contiguous cell range, the min and max functions also work on multiple cell ranges, the...
  4. A

    VBA to extract data from block info in a long row,and copy on another sheet non adjacent column

    Hi all, I know a lil bit excel, and i just started to learn VBA, need some help on creating this report. In a worksheet "Hist" i have a 36 block of data located in a single row, each block use 12 column of data block 1 = F4:Q4, (3 blanc column) then Block 2 = U4:AF4, then (3 blanc column) and...
  5. A

    creating an array from non-adjacent cells

    I need to use the ttest function. The format of the ttest command is: ttest (array1, array2, tails, type). However, my data are not in adjacent cells, which is the way I'm used to using array data (e.g. A2:A10 would be array 1). Is there a way to select several non-adjacent cells as an...
  6. A

    Sum Column below until...

    I am trying to use a forumula that can sum a column until a certain point, which is when a non adjacent column's information is filled in. And then I want it to repeat. For example: Cells A1: has text, Cells E1-1000 has numbers Cells A2-8: has blanks Cells A9: has text And perhaps Cells...

Watch MrExcel Video

This Week's Hot Topics

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
Top