discontinuous

MC allows for conveniently selecting multiple discontinuous cells as a single parameter within the syntax of formulas MC stands for "multiple cells". Many functions allow for selecting one cell or a continuous range of cells, and attempting to select multiple discontinuous cells through commas...

I'm trying to sum monthly production totals for a number of runs in my production facility and am having some issues summing the series with the ranges being discontinuous. I've found some work arounds but am having struggling applying them to my situation. More or less, what I am trying to...

I hope someone can help me with this, it might not be that complicated. I have a code that looks for a value in a cell and then finds that value in a range, once the value is located it will place a value in another cell offset by 3 columns. Sub Mark() Sheets("Sheet1").Select Dim LR As...

Hello. I'm working with a spreadsheet where my data has some formatting constraints. Because of this, I'm trying to work with some ranges that are discontinuous. Now functions like FREQUENCY and SMALL don't mind if I feed them a defined name like RANGE_01=A1:B2,A4:B5. SMALL(RANGE_01,1) works...

Hi, I have a series of data which looks something like this Week 1 2 3 4 5 6 ....... A 10 N/A 3 3 4 5 B 5 10 n/a n/a n/a 8 C n/a n/a 3 3 n/a 8 When trying to graph this it produces a zero...