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

software 發表在 痞客邦 留言(0) 人氣()

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

software 發表在 痞客邦 留言(0) 人氣()


Hi,

software 發表在 痞客邦 留言(0) 人氣()


I need to take a column that is in this format:

software 發表在 痞客邦 留言(0) 人氣()

RThis is for a price sheet for a new business

software 發表在 痞客邦 留言(0) 人氣()

Howdy~
I am using excel to complete weekly employee reviews. The employee rating

software 發表在 痞客邦 留言(0) 人氣()

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

software 發表在 痞客邦 留言(0) 人氣()

I'm looking for a HINT. I want to figure this out myself, but I'm stuck.

software 發表在 痞客邦 留言(0) 人氣()

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

software 發表在 痞客邦 留言(0) 人氣()


i have a list of properties serviced throughout the year. date in sheet

software 發表在 痞客邦 留言(0) 人氣()