non-contiguous range

Hi all, I am trying to fill in a non-contiguous named range in an active workbook (destination) with projections from another workbook (source), such source workbook defined by the user. The named range has contiguous columns, but non-contiguous rows. The rows of the 2 files will always be...

Hello All, I am currently trying to copy non-contiguous cells in excel which I know you cannot do directly, and then I need to copy these non-contiguous cells into another program, so I cannot just copy and paste in fragments. An example of what my data looks like now is below. So now I...

I've tried to research the combination of variables I think could be causing the problem, but I'm stumped. I have a time tracking spreadsheet (a modified time card) that I'm using to record hours worked on projects, both paid and unpaid. I have a calculation for each period of time worked, then...

Hi, I'm new to the forum, usually I've been able to search and find solutions but this time I'm at a loss. I'm trying to select to the last cell with a value in a non-contiguous column without using a direct column reference. I'm using a downloaded report and sometimes upper management adds or...

Hi Team, Here's my objective: I have a range of student scores on assessments. I need the average score of the bottom 25% of performers (So if there are 20 students, I need the average of the lowest 5 scores). I have a formula to make this work, but I have a filter running, and I need the...

Hello, First-time poster with a rather time-sensitive question. Some coding familiarity, but not specifically with VBA, so I keep tripping on syntax. Been banging my head against this for hours, so any pointers are greatly appreciated! So I'm trying to export a large table from excel to...

Dear Good People in MrExcel, I want to plot a graphic with a non contiguous data, so I figured I should move the data to another place and make them contiguous. The problem is I have around 9000 data in one column. How can I move just row 1,4,7,10, etc (every 3rd row) to another column? Is...

Hello Everyone, Im pretty desperate. I've got a column with around 9000 rows of data and I need to average non-contiguous rows. So I need to average row 1,4,7,10 (every 3rd row or so), and I have no idea how to do it. I just found out that we can use VBA to do this, but I havent figured out a...

Hi all. I can't begin to express how magnificently helpful this site has been to me over the years. Until now I have always been able to find solutions to my problems through experimentation and diligent searching. At long last, though, it has come to this: a direct plea for help. I am...

Hi I have as the two logical operators for an IF function the following COUNTA calculation which checks how many blanks are in the range GrdMtx7 and subtracts this from the value in E5 and adds the suffix "Module(s)". (E5-COUNTA(GrdMtx7)-1)&" Module(s)",(E5-COUNTA(GrdMtx7)&" Module(s)")))...

I am trying to create a simple formula using the SUM function combined with OFFSET and named ranges as follows =SUM(OFFSET([named range],,2) This appears to work fine as long as my named ranges are contiguous, i.e. (B3:B5) for example; however, as soon as a named range contains non-contiguous...