Forum Discussion
Help with Data Validation of Min and Max with Overlap Yes/No
Hello, I understand, I was only unable to upload the spreadsheet and share because it has proprietary information in it. Unfornately, I am not sure if a formula to copy for each row would work. This spreadsheet has over 10,000 rows and I would need a format tool instead for it to be time fast and efficient instead of time consuming. Unless you know how to copy the formula from top to bottom of the spreadsheet in a quick manner that'd be appreciated!
I was looking at the "Data Validation" to see what information I could put in to have it spit out Yes/No. Again, I am not sure.
Thank you!
Data Validation is something altogether different. You're looking in this case for a formula to check on the content of two other cells. You've been given, by Riny_van_Eekelen and me, two different (equally functional) formulas.
Data Validation could be used, if this were applicable, though I don't think it is, if you were entering the frequencies for a given station and only wanted to accept entries that met certain criteria. Or it can be used to make sure a name of say a department is on the approved list, thus not only validating that it's on the list but also that it gets entered with the correct spelling, etc. Anyway, different purposes than what you were wanting to do here.
mathetes I understand! Thank you for the clarification!