multiple data validation criteria
I have to restrict the number of characters in a cell that already has a data
validation criteria of selecting from a named range. How do I apply the second criteria of saying that this selection now must be equal to 30 characters (I need to export to a text file that requires specific character lengths for each data element gathered). |
multiple data validation criteria
Since you're using data|validation and a list, couldn't you just make sure that
each entry in that list is exactly 30 characters. I'm not sure how you would reconcile that the string has to match something on the list--and at the same time be 30 characters long--if those entries on the list aren't 30 characters long. Greyling wrote: I have to restrict the number of characters in a cell that already has a data validation criteria of selecting from a named range. How do I apply the second criteria of saying that this selection now must be equal to 30 characters (I need to export to a text file that requires specific character lengths for each data element gathered). -- Dave Peterson |
multiple data validation criteria
The selections are from a very specific list - so the response choices are
limited. But I guess a space counts, though? So if I had a yes or no drop down and it had to be three characters long, I would just have no with a space? Is that what you mean? "Dave Peterson" wrote: Since you're using data|validation and a list, couldn't you just make sure that each entry in that list is exactly 30 characters. I'm not sure how you would reconcile that the string has to match something on the list--and at the same time be 30 characters long--if those entries on the list aren't 30 characters long. Greyling wrote: I have to restrict the number of characters in a cell that already has a data validation criteria of selecting from a named range. How do I apply the second criteria of saying that this selection now must be equal to 30 characters (I need to export to a text file that requires specific character lengths for each data element gathered). -- Dave Peterson |
multiple data validation criteria
That's exactly what I mean.
Greyling wrote: The selections are from a very specific list - so the response choices are limited. But I guess a space counts, though? So if I had a yes or no drop down and it had to be three characters long, I would just have no with a space? Is that what you mean? "Dave Peterson" wrote: Since you're using data|validation and a list, couldn't you just make sure that each entry in that list is exactly 30 characters. I'm not sure how you would reconcile that the string has to match something on the list--and at the same time be 30 characters long--if those entries on the list aren't 30 characters long. Greyling wrote: I have to restrict the number of characters in a cell that already has a data validation criteria of selecting from a named range. How do I apply the second criteria of saying that this selection now must be equal to 30 characters (I need to export to a text file that requires specific character lengths for each data element gathered). -- Dave Peterson -- Dave Peterson |
All times are GMT +1. The time now is 02:15 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com