Extracting Data Based on Values, using <= or >=

**Raabi** · 12-03-2014, 01:35 AM

Hi geeks!

I need to extract data (records) based on Values in a particular Column. I have attached a sample file for the reference.

Please help.

Regards

**:) Sixthsense :)** · 12-03-2014, 01:49 AM

In A20 Cell - Array Formula - Requires CTRL+SHIFT+ENTER

=IFERROR(INDEX($B$2:$B$16,SMALL(IF($C$2:$C$16<6,ROW($C$2:$C$16)-ROW($C$2)+1),ROWS($1:1))),"")

In B20 Cell - Array Formula - Requires CTRL+SHIFT+ENTER

=IFERROR(INDEX($C$2:$C$16,SMALL(IF($C$2:$C$16<6,ROW($C$2:$C$16)-ROW($C$2)+1),ROWS($1:1))),"")

Apply the above formula's for D20 & E20 by changing the < to >

Array formulas need to be entered using the key combination of CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT key then hit ENTER.

**samba_ravi** · 12-03-2014, 01:54 AM

see the attached file

**Raabi** · 12-03-2014, 02:49 AM

Thank you very much, Sixthsense, for your attention.
The prescribed formula is beyond my comprehension, and therefore, I just blindly pasted the formula and pressed Ctrl-Enter.
But, I am facing an issue - after entering the formula and pressing Ctrl-Enter, the target cell remains blank; whereas; the formula is showing in the bar.
Any suggestion? Will I need to attend a training course in order to understand such formulas

Please take me a few steps further.