I have a bunch of columns that have either random IDs or #N/A. I’m trying to find the rows that have no solutions or have #N/A in all the cells in a range.
If all of the cells in a range have #N/A there is a problem
If at least one of the cells in a range have something other than #N/A, then its good!
In the picture, the red are the columns I am trying to compare and the yellow is the column I’m looking for.
How do I approach this?
Learn how to build a chatbot and train it on your own data with the OpenAI API, and how to turn it […]
So I got a potential job offer to be a backend-end php developer. I have been coding with JavaScript/python for the last […]
Ok, I share my laptop with my brother, And we both use different scale settings. I use 125 and he uses 100. […]
two days ago my PC started to really lose lots of its speed expecially on the startup. At first i was able […]
