"EXCEL" formula help

[optionwriter]

Dear TJ Senior members and EXCEL experts,

i have a small query about "countif" function result

i attached snapshot

above R Column 2 more times or multi times the same Strike prices appear i need to filter it in "s" column with result as per above snapshot.
so i tried "= countif(R3:R15,R3) " FORMULA AND RESULT shows how many count same strike appear ,then used "if condition " to filer it but not able to get result as per above "s " column

please someone know help..

Happy trading.

 

[Romeo1998]

Dear TJ Senior members and EXCEL experts,

i have a small query about "countif" function result

i attached snapshot View attachment 45184

above R Column 2 more times or multi times the same Strike prices appear i need to filter it in "s" column with result as per above snapshot.
so i tried "= countif(R3:R15,R3) " FORMULA AND RESULT shows how many count same strike appear ,then used "if condition " to filer it but not able to get result as per above "s " column

please someone know help..

Happy trading.

we can use a helper column for this to simplify things
data is in column A starting from cell a1
in cell b1 type this n drag down
=COUNTIF($A$1:A1,A1)
in cell c1 type this n drag down
=IF(B1=1,A1,"")
good luck

 

[optionwriter]

S, ITS WORKING WITH HELPER COLUMN.
warmest Thanks to timely (quick) help to ...

Happy Trading.

 

[optionwriter]

i tried to tweak the same code with your formula like this "=if(COUNTIF($A$1:A1,A1) =1,A1,"")
it is directly find the result without "helper column"

Thanks for kind..

Happy trading.

 

[Romeo1998]

i tried to tweak the same code with your formula like this "=if(COUNTIF($A$1:A1,A1) =1,A1,"")
it is directly find the result without "helper column"

Thanks for kind..

Happy trading.

Yes, that will also give the correct result....
if u r new to excel n need help in learning, have a look at this forum
https://www.mrexcel.com/board/forums/excel-questions.10/
all ur queries will be answered within minutes
when i was learning excel, i had also joined mrexcel forum...
good luck