Hello Mike, A great solution especially using MATCH if there are a lot of criteria to check. With just a few criteria we could use COUNTIFS: =COUNTIFS($F4,"
Thank you, especially since I learned much what I know from you and Mr Excel...And technically if we wanted to exclude anything containing "Introduction" we should but the wildcard "*" in front of "Introduction" also.
Hello Mr .Mike, I found an issue in 5:00 the "SEARCH" equation haven't calculated the word "INTRODUCTION" in "D14" , but calculated the word "INTERMEDIATE" in "D13"... Is that because the place of the calculation in "H16" is [10R*6C] while the table in "A3" is [11R*6C]?
Hey Mike you have became more respectable due to your "Broad Minded" and "Open heart" behavior by referring the better solution of Dean Bailiff. I have seen other more interesting comments like "Bill Szysz". It is like a pottery, different pot makers makes different pots with the same clay. :)
I have data in row column ,and my some number is like this 7098, 7099,7091,7010 my number started from 70 in row , I want that formula if any one start number other than 70 , so I can see there na, like if some one start number 90,or 80 , in that which formula Should I use, if there is 70 then ok other wise na
Hello Ganesh, I'm not sure if there is more to your situation but if I understand what you are asking you can use something like =IF(LEFT(A1,2)="70","OK","N/A") - change "A1" to where your numbers are stored and copy down the column. If you are doing conditional formatting then you would just use =LEFT($A1,2)="70" to highlight rows with numbers starting with "70" and anything else would not be formatted.
Hello, It is hard for me to help with the limited information and detail you have here. You will get a better response if you can post your question with some sample data and your expected results to a forum like MrExcel or similar.
Great step by step approach! Love how you break it down. Thank you for the Friday CF fun!
Yes, great to have two Conditional Formatting tricks on this Friday!
Hello Mike, A great solution especially using MATCH if there are a lot of criteria to check. With just a few criteria we could use COUNTIFS: =COUNTIFS($F4,"
Brilliant, and my guess is that it would be much faster calculating too!
Thank you, especially since I learned much what I know from you and Mr Excel...And technically if we wanted to exclude anything containing "Introduction" we should but the wildcard "*" in front of "Introduction" also.
Brilliant. If I lived near Seattle I would take your class. :) Great job as usual Mike.
This is brilliant: =COUNTIFS($F4,"
Hello Mr .Mike,
I found an issue in 5:00 the "SEARCH" equation haven't calculated the word "INTRODUCTION" in "D14" , but calculated the word "INTERMEDIATE" in "D13"...
Is that because the place of the calculation in "H16" is [10R*6C]
while the table in "A3" is [11R*6C]?
"Funtastic". You are really master of formula base tricks of Excel. 👌
It is funtastic. Check out Dean Bailiff's solution too : )
Hey Mike you have became more respectable due to your "Broad Minded" and "Open heart" behavior by referring the better solution of Dean Bailiff. I have seen other more interesting comments like "Bill Szysz". It is like a pottery, different pot makers makes different pots with the same clay. :)
Go Team!!! Yes, our awesome Online Excel Team is like a Team of Potters making many cool pots with the same class!!
You are awesome dude!!! I like the way you breakdown the formulas for explanation. Cheers! Keep up the good work.
Glad you like the video! Thanks for the support : )
Great step by step explanation as always!
: )
Grande tutorial Mike, obrigado.
You are welcome!
Great informative video!
Great job Mike
Glad you like it! If there is not a big string of NOT Departments to check against, check out Dean Bailiff's solution!
Yes, it works perfectlyyy
I have data in row column ,and my some number is like this 7098,
7099,7091,7010 my number started from 70 in row , I want that formula if any one start number other than 70 , so I can see there na, like if some one start number 90,or 80 , in that which formula Should I use, if there is 70 then ok other wise na
Hello Ganesh, I'm not sure if there is more to your situation but if I understand what you are asking you can use something like =IF(LEFT(A1,2)="70","OK","N/A") - change "A1" to where your numbers are stored and copy down the column. If you are doing conditional formatting then you would just use =LEFT($A1,2)="70" to highlight rows with numbers starting with "70" and anything else would not be formatted.
Dean Bailiff thnks but there is show ok, but I have big data in that time How can I find which is na
Hello, It is hard for me to help with the limited information and detail you have here. You will get a better response if you can post your question with some sample data and your expected results to a forum like MrExcel or similar.