Please take a look at the formula in column g, I have something wrong with it the ones in red should be increasing the # of customers shared by 1 in each for each occurrences that a new customer ID is added despite the customers all coming on line at the same point test.xlsx
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.
test (4).xlsx