0
The data (all text values) I have is scattered across the sheet (multiple rows and columns with gaps inbetween) and it is all calculated using formulas
now I would like to make sure that I know what the exact list of distinct calculated values are
so here is what I need to do
- copy values only to a new sheet
- organise into a single list (column)
- sort and de-duplicate
Welcome to superuser. Please share what have you tried so far and why that doesn't work. – Máté Juhász – 2015-12-09T15:44:07.010