Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel spreadsheets | Excel Worksheet Functions | |||
excel spreadsheets | Excel Discussion (Misc queries) | |||
excel spreadsheets | Excel Discussion (Misc queries) | |||
Can Excel Spreadsheets be saved as Microsoft Works spreadsheets? | Excel Discussion (Misc queries) | |||
Excel Spreadsheets | Excel Discussion (Misc queries) |