Hi
in A1 enter
=IF(B1<"",1,"")
in A2 enter
=IF(B2<"",MAX($A$1:OFFSET(A2,-1,0))+1,"")
and copy this formula down for as many rows as required. Now everytime
someone enters data in column B column A shows a ID value
--
Regards
Frank Kabel
Frankfurt, Germany
Nicki Nixon wrote:
so... how do you do it manually? I am searching for the same thing.
Nicki
"Frank Kabel" wrote:
Hi
if you mean a unique identifier. No there isn't. You can do this
manually but it is not the same as in Access
--
Regards
Frank Kabel
Frankfurt, Germany
"sprice" schrieb im Newsbeitrag
...
Is there a key field option in Excel like there is one in Access
|