Forum Discussion
Help with Data Validation of Min and Max with Overlap Yes/No
Since you've already gone to the trouble of creating the spreadsheet, unless it has proprietary information in it, it would be a LOT easier to help you if you attached the spreadsheet itself. I'm going to suggest a formula that should work, but with the actual, we could test it.
IF(AND(N8>$N$4,O8<$O$4),"Yes","No")
Copy that down to succeeding rows. You can surround it with other conditions for blank rows....
For future reference, though, when you ask for help, you help us help you by posting the sheet itself, not just an image.
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!
It's very easy to copy something from the top to the bottom of a column. The commands vary between Mac and PC. Put an x or any other character in the bottom cell. Then from the top, Ctrl+C to copy, Shift+Ctrl+down arrow to highlight all the rows to that bottom, then Ctrl+V to paste. With the Mac, substitute the Command key for the Ctrl key.
mathetes This formula worked! Thank you! One last issue, Is there a way I could remove the random "Yes" or have the cell say "No" to the cells which are blank and do not have frequency values in Columns N and O. I have attached a snapshot to walk through.
For example, the blanks cells N10, N11, etc., and O10, O11, etc. do not have values. So it does not make sense for the blank cells to say Yes. What could I put in the formula to have the blank cells in columns N and O to say "No" instead of Yes or keep those cells also blank.
Thank you
