Hi everyone!!
I am trying to use COUNTIFS to mark rows with specific data that I need to filter out! I have attached a spreadsheet excel help-v.1a.xlsx.
I will really appreciate your help! If you think COUNTIFS is not relevant or impossible to use, please let me know if you have a better idea.
Regards,
TK
In I4 copied down
=IF(COUNTIFS($K$4:$K$6,G4, $L$4:$L$6, "<="&F4, $M$4:$M$6, ">="&F4)>0, "Y", "N")
Does that work for you?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
See the attached file.
Please add the english formula for other forummembers.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
YES! Thank you much!
A.K.
I'm interested which formula you used.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks