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 value that was already returned already in A15 so it doesn't keep repeating.
I have a list of descriptions that can be selected via a drop down list (image below C12:C23) and I need to bring them over to another sheet but not double them up if the description has been used more than once. It just keep doubling up. How can I do this?
Thanks for any help with this.
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.
Hello,
This worked perfectly.
Thank you.
note if you just want every value returned 1x then as noted by ExcelExciting below you can use the UNIQUE function. You can pair that with the FILTER function to remove the blanks if you care or just use the UNIQUE function and it will give an extra blank line:
=UNIQUE(C12:C23)BUT if you want only cases where the text appears MORE than 1x then try this:
=UNIQUE(FILTER(C12:C23, COUNTIF(C12:C23,C12:C23)>1))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.
