markster
Well-known Member
- Joined
- May 23, 2002
- Messages
- 579
- Office Version
- 365
- Platform
- Windows
- MacOS
Hello
I have a 40k line spreadsheet of data.
I need help with a formula to put in AF3 to AF40,000 so for the first line it will look at columns AC3,AD3,AE3,AF3 and if the term "Out of Scope" is present in one or more of the cells, it returns "Out of Scope" and if not "In Scope".
Thanks
Mark
I have a 40k line spreadsheet of data.
I need help with a formula to put in AF3 to AF40,000 so for the first line it will look at columns AC3,AD3,AE3,AF3 and if the term "Out of Scope" is present in one or more of the cells, it returns "Out of Scope" and if not "In Scope".
Thanks
Mark