"EXCEL" formula help

#1
Dear TJ Senior members and EXCEL experts,

i have a small query about "countif" function result

i attached snapshot
EXCEL HELP.jpg


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

Well-Known Member
#2
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 :)
1609667453459.png
 
#4
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

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

Similar threads

Zerodha – Open Paperless Account

Open online account with Zerodha. Free delivery trading and Max Rs 20 for Intraday, F&O, Currency and Commodity Trading. Intraday High leverage with MIS, CO and BO.

Name:Phone:
Email:City:
State:
Are you a day trader?