1. ### 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. ### 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. ### 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. ### 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. ### 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. ### 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...