03-07-2019 11:33 AM
03-07-2019 12:05 PM
03-07-2019 02:02 PM
I loaded the dynamic array version of Excel and already I am dreading having to revert to deliver client workbooks. I made the list of companies into a table so that the named range 'list' (of companies) becomes dynamic. I then move to my formula cell and named it 'distinct'.
The formula I inserted into the cell is
which spills to provide a list of the distinct company names from 'list', sorted alphabetically. Moving across again, I name a new formula cell 'occurrences' and then insert the formula
= COUNTIFS(list, distinct#)
to get a count corresponding to each distinct company.
The number of distinct companies 'countDistinct' is given by
and, just as a check, the values
So few formulas, so many results!
03-07-2019 05:20 PM
03-08-2019 06:19 AM
by Aztrix on June 02, 2020
by cuong on May 27, 2020
by Ingeborg Hawighorst on May 13, 2020
by Brian Jones (OFFICE) on May 06, 2020