trying to keep column e to say yes or no if i delete columns DX to EB.
trying to keep column e to say yes or no if i delete columns DX to EB.
do you just mean if it would error then say yes?
Please Login or Register to view this content.
If you want something done right... find a forum and ask an online expert.
Time flies like an arrow. Fruit flies like a banana.
if i delete the columns dx5:eb5 it will return a #REF
.
i'm trying to have column e look at those cells and if those cells contain 3 or more # then return yes. but once the week passes i will delete those columns. when i delete is when i get the ref error
Use INDIRECT function:
=IF(COUNTIF(INDIRECT("DX"&ROW()&":EB"&ROW()),"*#")>=3,"YES","NO")
You could also use the OFFSET function. Paste this in E5 and copy down:
=IF(COUNTIF(OFFSET(E5,0,123,1,5),"*#")>=3,"YES","NO")
Please click the Add Reputation star below any helpful posts, and if you have your answer, mark your thread as SOLVED (Thread Tools up top). Thanks!-Lee
Last edited by leelnich; 05-05-2017 at 01:31 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks