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? |
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? |
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? |
All times are GMT +1. The time now is 10:46 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com