Mar 30 2020 01:27 AM
Mar 30 2020 01:51 AM
@Riaan1055 You haven't attached any sheet :)
Are the licenses values in cells or just formatting? Because formatting alone isn't visible to formulas.
Mar 30 2020 02:21 AM
Mar 30 2020 02:27 AM
@Riaan1055 Your question doesn't line up with what I'm seeing on this sheet - there are no green dots. Can you explain a bit more what you need?
Mar 30 2020 02:30 AM
Mar 30 2020 02:35 AM
Mar 30 2020 02:46 AM
@Riaan1055 Perfect - the numbers make it much easier! I still need you to explain what you actually want to see and in which cell.
Mar 30 2020 02:55 AM
Mar 30 2020 03:49 AM
@Riaan1055 I think I follow. I presume you care about today's figures? I have made a formula in the attached.
Mar 30 2020 04:00 AM