Posted to microsoft.public.excel.worksheet.functions

[email protected] sparikh95@gmail.com is offline

external usenet poster

Posts: 2

Data Validation - Custom question (multiple conditions)

Hi,

I have similar issue but different conditions.

1) serial number contains minimum 14 characters and maximum 15 characters
2) the first character may or may not be "S"

I can't seem to figure this out. Please help. Thanks.

SP

--

lukin

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
custom data validation on cells with data validation values	AKrobbins	Excel Worksheet Functions	2	June 21st 11 04:20 PM
3 Conditions for Data Validation for a List	Anders	Excel Programming	7	July 7th 09 12:26 AM
Data Validation, Custom	leimst	Excel Worksheet Functions	1	June 13th 08 12:24 AM
Data Validation, Custom	leimst	Excel Worksheet Functions	1	June 13th 08 12:23 AM
Combining conditions for data entry validation	Richard H Knoff	Excel Worksheet Functions	10	November 14th 04 01:49 PM

All times are GMT +1. The time now is 10:26 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us