| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to be noticed/to avoid equal values in a colum
Hi! I am working on a excel sheet that has a long colum with string values. I don't want the colum to contain any equal values. When I write new string values to the colum sometimes I am allerted if the value already excist (as I start writing the complete string appear with what is left marked in black). This is good because then I know if the value already excist in the colum and I don't retype it. However, I am not always allerted and then I end up writing the same value several times. Does anyone know how I can deal with this problem as I dont want the colun to contain any equal values? Thank you for all help. Irene  -- Irene ------------------------------------------------------------------------ Irene's Profile: http://www.excelforum.com/member.php...o&userid=34269 View this thread: http://www.excelforum.com/showthread...hreadid=540287 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| list values equal in 2 worksheets? | Excel Worksheet Functions | |||
| Second serie doesn't use X-as values | Charts and Charting in Excel | |||
| colum B=average of last 10 values in A | Excel Worksheet Functions | |||
| SUM(IF( Array to avoid #NUM! values | Excel Worksheet Functions | |||
| lookup in colum a and compare values in colum b | Excel Worksheet Functions | |||
Threaded Mode
