News for hackers. Stuff that matters.

kvna

Re:Benzene detected in many sunscreen products on Wednesday May 26, 2021 @01:47PM (#27293730)
It’s presumably not the talc but the asbestos found in the talc deposits that makes its way into the baby powder
Re:XLOOKUP for Excel on Saturday August 31, 2019 @12:04PM (#20847112)
If you add your table to the data model you can do count distinct with a pivot table
Re:Robinhood raises $323M at a $7.6B valuation on Monday July 22, 2019 @04:12PM (#20501862)
The only issue I have had with Robinhood is regarding tax planning, because they only support FIFO sell orders. There have been several instances where I would have preferred to sell shares purchased more recently, so that my older shares can pass the one year threshold for long term capital gains. The ability to specify lots when selling shares would be worth money to me.
The best way to create reusable formulas in your workbooks is to add your table to the data model (which creates an in-memory tabular cube) and write measures using the DAX formula language. This has the added benefit that a single formula can be written to aggregate data at different levels, for example, a sum can be calculated over days, months, or years. This will only allow you to share formulas in a single workbook. The data model in Excel is powerful and under utilized.