A cross domain solution is a system which is designed to allow two network domains (a single domain being servers with a common login) to securely exchange data. A CDS will include a content filter to prevent data from being moved which another domain does not have authorization to use.

Domains with different levels of access to secure information need a means to both manually and automatically transfer data. A CDS will offer:

1. Access solutions - the ability to view information from domains with differing security levels.

2. Transfer solutions - the ability to move information between domains with differing security levels.

3. Multi-level solutions - the storage of all data in a single domain.

The SANS Institute has prepared a diagram that shows how cross domain solutions work:

See the SANS Institute guide, Shedding Light on Cross Domain Solutions, posted here.

You can use this array formula:

=IF(COUNTIF($C$2:$H$2000, $A4)=0, "", INDEX($C$2:$C$2000, MAX(IF(A4=$C$2:$H$2000, ROW($C$2:$H$2000)-1))))

. . . to search a range of cells (in this example C2:H2000) in Excel for one value (given in A4) , and return the value from a given column in that range (in this example column C.).

We look up the names of starting pitchers listed in column A, searching to see if they were in the rotation of top starters for different years listed on each row. The value of the year in column C will be returned for the last reference to the pitcher's name in the range.

As always with an array formula, remember to enter it with CTRL + SHIFT + ENTER.

Thanks to Jerry Beaucaire for the idea posted here.

Sean O'Shea has more than 15 years of experience in the litigation support field with major law firms in New York and San Francisco.   He is an ACEDS Certified eDiscovery Specialist and a Relativity Certified Administrator.

The views expressed in this blog are those of the owner and do not reflect the views or opinions of the owner’s employer.


All content provided on this blog is for informational purposes only. The owner of this blog makes no representations as to the accuracy or completeness of any information on this site or found by following any link on this site. The owner will not be liable for any errors or omissions in this information nor for the availability of this information. The owner will not be liable for any losses, injuries, or damages from the display or use of this information.


This policy is subject to change at any time.


Contact Me With Your Litigation Support Questions:


  • Twitter Long Shadow

© 2015 by Sean O'Shea . Proudly created with Wix.com