Posted to microsoft.public.excel.misc

Alberto Ast[_2_] Alberto Ast[_2_] is offline

external usenet poster

Posts: 181

Table Range verification

How can I validate there is no overlap of ranges... Col A has date code, Col
B has the start range number and Col C has the ending range number...

In a given date code I want to make sure there is no overlap or ranges... on
below example 2nd date code is equal to 3rd date code but ranges overlap from
40 to 50.. how can I validate it will not happen?

Date Code Start End
00109FMLL 00001 00350
21809FMLL 00001 00050
21809FMLL 00040 00200
01509FMLL 00200 00300

Thanks

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
sorting data from one table/range to another table/range	Danko Jotanovic	Excel Discussion (Misc queries)	1	April 15th 09 01:06 PM
Pop up verification when opening a sheet.	[email protected]	Excel Worksheet Functions	5	October 30th 07 10:15 PM
cell verification	Firkins	Excel Discussion (Misc queries)	2	October 2nd 07 05:40 PM
Date verification	Oldjay	Excel Discussion (Misc queries)	4	October 24th 06 03:52 AM
data verification	Kristen	Excel Discussion (Misc queries)	0	July 14th 06 02:31 PM

All times are GMT +1. The time now is 08:24 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us