restricted

In Table 1, I have an area number and a date. In Table 2, I have an area number and a range of dates for which that area is restricted. My issue is that in Table 2, the area can be restricted in multiple, non-consecutive ranges. For example: Table 1: <tbody> Area Dates 330 10/5/2019 330...

Hello I have the following formula: (array) =INDEX($B$4:$AF$4;MATCH(0;IF(""<>$B$6:$AF$6;COUNTIF($A$17:$A17;$B$4:$AF$4);"");0)) I all works fine but, I would like to add a row criteria as well this would mean that is will not be restricted to row 6. Any ideas ? Thank you.

Hi, I have an excel file containing a number of sheets, I will name them sheet 1,2,3,4 and 5. The issue I have have is this. Sheet 1 and 2 need to be restricted access. Only certain people can view / edit as they contain sensitive data. Sheets 3,4 and 5 are open access and can be viewed by...

Hi, I've created a drop down list in an invoice. The invoice is page one. It populates from from page two with item and price. I have 57 items in my product list. I've created the data validation and have the list going to row 300. This allows me to enter new items with more ease and not...