safe

Hi folks Every year I have to generate a list of 4 digit safe codes, for 60 sites, that change monthly. The safe codes cannot have repeating characters. So I have 60 rows, 12 columns. Each cell must have a code between 0123 and 9876. They need to be randomly generated. It doesn't have to be...

I have 2 columns. Date and # of Safe Days The Date is starts on November 1 and is sequential through 2020. The Safe Days column represents a 1 or 0 0 = Not a Safe Day 1 = Safe Day I'm trying to figure out a calculation that will automatically give me the number of days since our last safety...

I have 2 columns. Date and # of Safe Days The Date is starts on November 1 and is sequential through 2020. The Safe Days column represents a 1 or 0 0 = Not a Safe Day 1 = Safe Day I'm trying to figure out a calculation that will automatically give me the number of days since our last safety...

Hello, I am developing an add in, and noticed that for some odd reason it causes some user's Excel to crash whenever they try to right click -> format cell. I've seen a few posts on how to solve this problem, most involve starting excel in safe mode then disabling the add in, but does anyone...

Hello everyone, I have a very specific excel question in regards to calculating the daily cash drop for a restaurant. Every day at my restaurant we start with $300 in the cash drawer across all amounts of change and bills. At the end of the day, the person closing counts the total amount of...

Hi, i have two formulas =INDEX(Raw!A:A,COUNTA(Raw!A:A)+ROW(Raw!A:A)-ROW(),1) and =filter(Raw!B:B,Raw!$B:$B<>"Completed (Repairs completed, Available and safe to use)") is there a way that i can combine both formulas in one? thanks Sam

Hi All, Ive got a google sheet which automatically updates once my drivers log a fault with their vehicle. The action status of the vehicle changes from available to unavailable when the repairer places the vehicle in-progress meaning they are working on it. i then use vlookups to match the...

Hi All, the below is my formula and it works =If(and(O84="Unavailable (Tagged Out)",E84=""),"Unavailable",If(and(O84="Unavailable (Tagged Out)",E84="Completed (Repairs completed, <b>Available</b> and safe to use)"),"Available", If(and(O84="Unavailable (Tagged Out)",E84="In-Progress...