I am preparing a spreadsheet in which I have to input names from A2:A200. Each name must be different. I would like to know if there is a function that automatically prevent me to duplicate a name in that column range. Thank you for your support.
www.cpearson.com/excel/NoDupEntry.htm
- Jan 24 Wed 2007 20:35
No duplicate names in a range (A2:A200)
- Jan 24 Wed 2007 20:35
concatinate data
I have several columns of numbers - some numbers have leading zeros. When I
concatinate the data the leading zero drops off even if I customize the cell
- Jan 24 Wed 2007 20:35
Sum function
- Jan 24 Wed 2007 20:35
date formula for extracting unique dates
- Jan 24 Wed 2007 20:35
Rounding up numbers up or down.
RThis is for a price sheet for a new business
- Jan 24 Wed 2007 20:35
searching for repeating text
Howdy~
I am using excel to complete weekly employee reviews. The employee rating
- Jan 24 Wed 2007 20:35
Remove the paste function in a worksheet
How can I remove the paste function in a worksheet? I need users to enter
date but when they cut from another worksheet and paste into mine, the
- Jan 24 Wed 2007 20:35
dynamic range name
I'm looking for a HINT. I want to figure this out myself, but I'm stuck.
- Jan 24 Wed 2007 20:35
excel formula formatting result
I have a worksheet that uses a formula that subtracts tha amount from one
column from another. If nothing is entered in the first column a zero is