hi, if i were to use your = A2<"" in columnA in order to force users to fill
in columnB first, then i cant use =COUNTIF(A:A,A1)=1 inside my columnA
already.
"Earl Kiosterud" wrote:

kyoshirou,

You didn't read that I meant for you to use Data - Validation (from the menu
bar). Follow these steps carefully, and I think it will do what you want:

Select the cells in column B (or all of the column if you wish). Note which
cell is the active (white) cell.

From the menu bar: Data - Validation.

Set the "Allow" box to: Custom.

In the Formula box, type: = A2<""

This is for the case where the active cell is B2. Change it accordingly.

Click OK.

Now if you attempt to enter something into a column B cell, Data Validation
will give you what we affectionately call the "Raspberry" (an ugly message)
if the corresponding cell in column A is empty. You can change that to a
nicer message in the Data Validation dialog box.

--
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"kyoshirou" wrote in message
...
i know columnA cannot have 2 forumula.
You mean use =B2<"" inside columnB,
then coulmnA use back =COUNTIF(A:A,A1)=1?
It cant works.
please advice.

Thanks!


"Earl Kiosterud" wrote:

kyoshirou,

If you put a formula in column A, then it will be over-written when
people
enter stuff into column A. Instead, use Data - Validation in column B.
Set
it to "Custom." This formula is for where B2 is the active (white) cell
of
your selection.

=A2<""

Be sure that "Ignore blank" is not checked.
--
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"kyoshirou" wrote in message
...
hi all,
i have a simple questions to ask:
I have column A & column B.
In order to make it for users to fill in column B first, I need this
forumla, =ISTEXT(B1) in column A right? So that users cannot enter data
in
columnA first. However, I have another forumla in columnA,
=COUNTIF(A:A,A1)=1
to help me check for repeated data.

Therefore, =ISTEXT(B1) cannot be placed inside columnA.
So, I would like to ask, if there others way? (I dont wish to create
another
column for it).
Also, =COUNTIF(A:A,A1)=1 and =ISTEXT(B1) cannot be combined togther as
one?

thanks.