Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 14th 04, 05:35 PM
Nicki Nixon
 
Posts: n/a
Default Excel Key Field option?

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




  #2   Report Post  
Old November 14th 04, 05:38 PM
Frank Kabel
 
Posts: n/a
Default

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

  #3   Report Post  
Old November 14th 04, 06:56 PM
JE McGimpsey
 
Posts: n/a
Default

Note that for this to work as a key field, entries have to be made in
sequential row order (which means that you might as well use

A1: =IF(B1<"",ROW(),"")

and copy down.

One essential element of key fields is that the key stays identified
with a record. Using the formula below will renumber the records if data
is entered out of order and then filled in, or if a row is inserted or
deleted.

For a true key field, I think you'd need to use an event macro to insert
a sequential number.



In article ,
"Frank Kabel" wrote:

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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
excel save as csv - force text qualifier on every text field Newbie-Don Excel Discussion (Misc queries) 5 October 22nd 08 05:45 AM
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 1 January 5th 05 08:36 AM
Word field codes in Excel data file Includetext mranz Excel Discussion (Misc queries) 1 December 7th 04 11:19 PM
how do you set up a mandatory field in Excel? Lisa Excel Discussion (Misc queries) 2 November 30th 04 11:20 PM
sort option is greyed out in excel mom Excel Worksheet Functions 1 November 3rd 04 03:22 PM


All times are GMT +1. The time now is 01:41 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017