# "EXCEL" formula help

#### optionwriter

##### Active Member
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

#### Romeo1998

##### Well-Known Member
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

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

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

#### optionwriter

##### Active Member
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..

#### Romeo1998

##### Well-Known Member
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..

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