Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 6
Default Excel spreadsheets

How do you start or stop a cell in Excel from repeating information that
appeared in a previous cell in the same column?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,572
Default Excel spreadsheets

You can maybe start he

From the menu bar:

<Tools <Options <Edit tab,
And check or uncheck -

"Extend List Formats And Formulas"
AND
"Enable AutoComplete For Cell Values".
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Inge" wrote in message
...
How do you start or stop a cell in Excel from repeating information that
appeared in a previous cell in the same column?



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,856
Default Excel spreadsheets

How does the cell get its information? From a formula or by typing it
in?

If it is by a formula then you could use the COUNTIF function to
determine if the value already exists in previous rows and return a
blank if it does. If it is by typing it in, then you would need to set
up data validation on each cell and set up a similar formula to
disallow repeat entries.

I realise the answer is a bit vague, but you have not given many
details in your post.

Hope this helps.

Pete

On Dec 6, 7:38 pm, Inge wrote:
How do you start or stop a cell in Excel from repeating information that
appeared in a previous cell in the same column?


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 spreadsheets confused Excel Worksheet Functions 3 November 12th 07 02:06 PM
excel spreadsheets jsand07 Excel Discussion (Misc queries) 2 May 3rd 07 04:04 PM
excel spreadsheets buggsy Excel Discussion (Misc queries) 3 October 25th 06 01:41 PM
Can Excel Spreadsheets be saved as Microsoft Works spreadsheets? EXCEL WORKS CONFUSED Excel Discussion (Misc queries) 4 August 18th 06 11:21 PM
Excel Spreadsheets wolfmanjack81 Excel Discussion (Misc queries) 2 September 18th 05 04:05 PM


All times are GMT +1. The time now is 09:12 PM.

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

About Us

"It's about Microsoft Excel"