Hey Solaris,Yes, I am looking for values equal and above a absolute number of 5 , only Q or R need this value , it is not needed for both column cells to contain absolute 5 or above to remain and not be deleted. In simpler terms, if Q contain 5 and R contain 2 then this row will remain.are you looking for absolute values above five, or above or equal to five?
yes, that is exactly it ^^ So lets say there is a full range of numbers but all part of 'group' 123 in O column , and this entire range of data has only one single number exceeding or equal to absolute 5 in column R or Q then the entire 'group' will remain and not be deleted.the rows will come in groups with the same value in column O? And if a single Q- or R-cell has a number above absolute five then no rows in the same group should be deleted?
You hit the nail right on the head , that is what I meant to illustrate.For example, in Sheet1 of your attachment all rows between 17 and 32 have the value 173 in the O-column, but only Q21 has a value above absolute five. Are all of the said rows meant to be kept in this case?
You are from Sweden? ^^ I am actually learning Norwegian currently and going to Sweden in August, my life obsession about Scandinavia :P
Thanks for asking those perfect questions, now someone else reading might also understand better![]()
Bookmarks