Gathering data which are in between two points

[elvalo]

Hi all,

I would like to filter all the data which lie between some start and end points in a extra column. I already have the start and end points which are gathered in an extra column but I also need all the data in between.

Maybe it is possible to already use the functions which lie behind the gathering process for the start end end point.

Usually the List is longer, thats why I don't do it manually.


Thanks!!!

[dosydos]

For your example where start is 3 and end is 29 use tis filter function:

Please Login or Register  to view this content.

[6StringJazzer]

It's not clear what you want your result to look like. You have two different sets of start/end points (K16, M16) and (K17, M17).

Do you want to filter the existing data (A:G) in place or create new lists of that data? If new lists, where do you want them?

[elvalo]

basically I have a list with a lot of start and end points. Those data (including the data of the start and end) I would all like
stand under another. If they stand in a seperate column just next to the existing list that would be nice, but if it is easier to just filter
them thats also alright.

The data which lie between the end and the start point I would like to eliminate.

[elvalo]

Unfortunately it tells me there is a problem in the function...

Thanks anyways so far

[6StringJazzer]

dosydos's function works perfectly for me--for one start/end pair. You need one formula for each pair of start/end, which is why I asked what result you want. See attached.

What error are you getting? Your profile says you are using Windows 365, and you must use Excel 365 or 2021 for the FILTER function to work.

[MrShorty]

Assuming this is one step along the to integrating each peak as we talked about in an earlier thread, I don't know if I would worry about filtering/extracting the data for each peak. I would tend to process in place. Something like:

1) First, get the step start and step end columns to combine into a single column where each "x" marks start or end of peak. Rather than re-write the formulas in column E and F, I inserted a new column G, and just placed a simple =E11&F11 into the new G11 and copied down.
2) With "x" to mark start and end of peak in the same column, the formula in column H (that was in G before I inserted the column there), can be adapted to refer to the new column G. Now, column H will contain integers counting up each time it encounters an "x" in the new column G, which means "peaks" are marked by odd numbers and "not peaks" are marked by even numbers in column H.
3) Still assuming that this is working towards integrating each peak, I could then add a column (or more, depending on exactly how you want to calculate areas) that calculates the area of each slice/segment of the peak.
4) Then, when I want to final integrated area of each peak, my summary table can be a SUMIFS() function (or pivot table) that sums the area column for each odd number in column H. =SUMIFS(I:I,H:H,1) for the first peak, for example.

I don't know if that helps, but, assuming that the end goal here is "integrating the area of each peak," it provides a way to do the integration in place without needing to extract the data for each peak into another location of the spreadsheet.