Forum

Hello, Assuming that you want this check per row, try with this. =IF(OR(AND($A2=”Routine”,$B2>=5),AND($A2=”Urgent”,$B2>=2)),”Pass”,”Fail”)

Hello Jimmy, Great that it works fine for you now.

Hello, The problem you have is due to not locking the lookup range. In cell K3 you have this formula: =INDEX('GLP Retailers'!B4:B100,MATCH(J3,'G...

Hello, in the bottom section of this blog you find an explanation of this issue. ”Sometimes the totals will be wonky - Totals aren’t actually to...

Hello Jay, I’m glad I could help. Good luck with your work, as a geneaologoist myself it looked like you have dugged up a lot of hard found data.

Hello Kevin, The linked explanation is in my view clear enough, it is all about mathemathics. As you want to know the next occurence of a certai...

Hello Jay, Not sure if this is what you want, it is how I understood it anyway. Please see attached sample. I created a helper column to count each...

Hello, I used Office for Mac some years ago and then there were differencies between Excel for Mac and Excel for Windows. How it is now with O365 I...

Hello Justin, Have you checked out this blog article about date formatting?

Hello Mel, Great that you got it working.

Hello Melissa, If you are able to provide a sample file it would be a lot easier for me and others to give some help. Based on the formula you h...

Hello, There is a good explanation here on how this formula works.

Hello Humayun, Please share a sample file showing your data structure. Have you checked this info?

Hello, Not sure what you have tried with, if you can upload a sample file with some data it will be easier to give a correct and relevant answer. I...

Hi Paul, Thanks for the update!