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.
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.