Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula in Col B to detect if an entry in a list in Col A is uniqueor not
I have a two column spreadsheet. It has thousands of rows. Col A contains a text entry in each row from row 2 onwards (row 1 being the header). I want Col B to contain a formulae which examines the text entry in the adjacent cell in Col A and to return "Yes" or "No" to the following question: Is the text entry in Col A unique having regard to all of the entries above it within Col A.
In other words, taking Cell A1568 as an example, the formula in B1568 would ask the question IF any of the text entries in Cells A2 to A1567 is the same as the text entry in A1568, then return "Yes". If the text entry is not the same as any of the text entries in cell A2 to A1567 then return "No". (Note: "No" means it is not duplicated, Col B header is "Duplicate"). Thanks in advance (I know I could pivot table it, but I want a real time "yes"/"no" responsive formulae in Col B) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula in Col B to detect if an entry in a list in Col A is unique or not
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
LIST ENTRY ENABLE DROP DOWN LIST TO ACCEPT MORE THAN 1 ENTRY | Excel Discussion (Misc queries) | |||
How do I set up entry box to auto-alphabatize each entry in list? | Excel Discussion (Misc queries) | |||
detect validation list | Excel Programming | |||
How Do I Detect An Entry In A Range Of Cells | Excel Programming | |||
Data Entry in a cell still in progress - how to detect and correct | Excel Programming |