Forum Discussion
Solved
Excel lookup help
Hi, I am trying to work out the formula in excel to look at a column (C12:C23) and if there is the same text more than once only return it once (A15). Then repeat this in A16 but disregard the valu...
You can achieve this using a dynamic array formula with the combination of the functions UNIQUE and FILTER.
=UNIQUE(FILTER(C12:C23,C12:C23<>""))This will automatically spill down the results and display all unique descriptions from the range C12:C23, starting from cell A15.
If this resolves your query don't forget Mark as Solution.
You can achieve this using a dynamic array formula with the combination of the functions UNIQUE and FILTER.
=UNIQUE(FILTER(C12:C23,C12:C23<>""))This will automatically spill down the results and display all unique descriptions from the range C12:C23, starting from cell A15.
If this resolves your query don't forget Mark as Solution.