FiLTER only hilighted scripts

[Techtrend]

Need to filter only the buy short scripts separately in the same sheet,
details are mentioned in the attached document

 

[narunfca]

You may use Advanced filter option for the same.

Insert a column and type heading BUY/SHORT,
Type Filter criteria BUY and SHORT in following rows.

Type the Headings required in output at M1 and N1.

Select any cell in the Data Range.

Choose Data->Advanced Filter and
choose the Action - Copy to another Location

List Range is $A$1:$I$14
Criteria Range is $K$1:$K$3
Result Range (Copy to) - Select the Headings only $M$1:$N$1.

Now the result will be pasted in Column M and N.

Example file enclosed.

with best regards

Arun N

 

[Techtrend]

we need to have it has a formula ,
As it is live sheet the BUY ,short keeps changing during the day,

can you please help me with a formula where A-G Gets updated in M-N if there is BUY/short mentioned.

 

[Chihiro]

See attached.

 

[Techtrend]

Thanks works fine.

thanks
narendra

 

[Techtrend]

Hello Chihiro

i have used the formula to my live sheet with the same references ,
IT only works on the CM and CN 2 only and below that there are formulas but doesn't pick up data,unable to understand the issue also,

can you please help me on the same.

the data of bX and CJ has to be filtered and shown in CM and CN.

Thanks for your time and help
narendra

 

[Chihiro]

It's because of #N/A. Where do those come from?

 

[Techtrend]

thats bcas we have some space in between and for some if one of the value is 0 in the formula it shows #N/A.

can we adjust in the formula return only if there is a value

 

[Chihiro]

Sure you can. Though it'd be easier to trap error on "BUY/SHORT" column...

Just nest the two logical condition in IFERROR(logical condition,0)

Ex. IFERROR(($CJ$2:$CJ$100="BUY"),0)