|
Distinct list formula
Does anyone know of a formula I could use to compile a distinct list of entries from another column. I know this could be done with the advanced filter, and I know it could be done with VBA, but I need to do it with a formula. Likewise, I can't use a pivot table because then the data could be changed. I have to pull a distinct list and their correponding values from some static data so it can be graphed.
Thanks
|