Need Help_Data Sorting

[Ashhu]

Sorry to bother you all duting festive season, if you could help me please do so.
I have datasheet in table formats with the %details in F column, (InputSheet)
I need to pick only the values which are having less than 30% in oputput sheet.

I have uploaded file here, please see.

thanks in advance
Ashwin

 

[Mike H..]

Sorry to bother you all duting festive season, if you could help me please do so.
I have datasheet in table formats with the %details in F column, (InputSheet)
I need to pick only the values which are having less than 30% in oputput sheet.

I have uploaded file here, please see.

thanks in advance
Ashwin

Hi,

Check out your workbook. Note the formula I used is an ARRAY formula, here's how to enter an array formula.

This is an array formula which must be entered by pressing CTRL+Shift+Enter
and not just Enter. If you do it correctly then Excel will put curly brackets
around the formula {}. You can't type these yourself. If you edit the formula
you must enter it again with CTRL+Shift+Enter.

EDIT...See second workbook with better formula.

 

[Ashhu]

Many many Thanks Mike, have great holidays ahead

 

[Asheesh]

Hi Ashu - since I had worked on it using a different method i.e. Pivot..so posting it here...

 

[Ashhu]

Many Thanks Asheesh , I will check it. Thanks for your time

 

[siva97237]

=IFERROR(INDEX($A$1:$F$11,SMALL(INDEX(($F$6:$F$11>=30)*10^10+ROW($F$6:$F$11),0),ROWS($J6:$J$6)),COLUMNS($J$6:J$6)),"")
Try this in J6 and copy across