Hello, Excel gurus!
I have a problem:
I have a long list of data (about 150 rows in one column, ultimate strenght values for test specimens, so all cells contain numbers) and I need to select specific range of cells: I need ONLY the cells that contain the values between 10 and 40% of the values. To clarify: if the cell with the lowest value is 0% and the highest is 100%, I need to select and show only the cells that contain values that are from 10% to 40%. Any ideas on how to do that?
Tried searching multiple forums and found nothing, I hope I am stating the problem clear enough (not a native english speaker) for you, guys to understand. Murpy's law states that I've probably missed the answer, so if the answer is obvious I am sorry for taking your time.
Thanks and take care!
Bookmarks