Last seen: Aug 30, 2025
Hello, Some barcode scanners, for example Zebra, do support change of settings to send a TAB code when scanning. What brand do you have on your sca...
Hello, Based on the provided example I would use DGET for this. You need to change the layout of your ”input form” to get it to work. Example: I...
Hello, First I want to share a link to a page that describes how column width is determined in Excel. Now some questions. 1) What file format...
Hello, Ask the user who worked with it last to restart his or her computer. This often happens when the Excel.exe process is still active even t...
Hello, My apologies for not giving you a complete formula in my previous answer. As I do not know how you want this to work, for example where you ...
Hello, You can use MROUND function to round up or down to nearest half hour. Example: The entered time of 7:12 in cell C3 will with below formu...
Hello and welcome to this forum, If you can, please upload a file containing some sample data. In general it should not be a problem using less ...
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...