ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   limit column entries (https://www.excelbanter.com/excel-discussion-misc-queries/25236-limit-column-entries.html)

Boenerge

limit column entries
 
Is it possible to block enteries in a column if a certain amount of text
entries has been reached e.g. if you only want 3xE & 2xL entries?


Franz

"Boenerge" ha scritto nel messaggio


Is it possible to block enteries in a column if a certain amount of
text entries has been reached e.g. if you only want 3xE & 2xL entries?


I think tou could use Data Validation (from menu Data).
--
Hoping to be helpful...

Regards

Franz

----------------------------------------------------------------------------------------
To reply translate from italian InVento (no capital letters)
----------------------------------------------------------------------------------------



Biff

See reply in .Functions

Biff

"Boenerge" wrote in message
...
Is it possible to block enteries in a column if a certain amount of text
entries has been reached e.g. if you only want 3xE & 2xL entries?





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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com