Good day,
Can you please help me with a problem I am having.
Attached is an excel document (office 10)
In this document there are numerous lines of numbers, each in its own cell.
I need to search for duplicate numbers in each line.
Line by line.
Not duplicates in the complete document.
Manually this is straight forward.
Highlight the required line of numbers, use conditional formatting, highlight cell rules and then use the duplicate values function.
What is needed is a way of using this function across the whole document without having to manually apply this method line by line.
When I try to "pull" this function to include more lines it treats the page as a whole document and does not function on a line to line basis, and highlights all the duplicate numbers in all the lines.
Thank you for your time and effort.
Bookmarks