non adjacent cell

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...

Some videos you may like

This Week's Hot Topics

Top