How can I setup a cell to include a number which appears only for the first row in a table for a particular stock?
Hello, I currently maintain a sheet at work in an Excel format which cannot be changed. I trade in stocks and the commission received is applicable for each one of the different stock the client trades during the day. This means that even if we trade 25 instances of AAA company stocks, the commission can be levied once and if we trade 1 instance of BBB stocks, the commission is also levied once. What formula can I use to ensure that the commission doesn't repeat for a single type of stock. The example is shown in the screenshot and 'Commission' column has to be filled by that formula. I'd manually write these, but I have to do this for lots of stocks daily. Thanks!
Posted Aug 26, 2024, 3:25 PM UTC
39