In this post, we will see how to resolve Excel qty IN/qty OUT formula Question: I need help with a formula calculating qty in and out based on need date where oldest date pulls first if the PN matches an ...
In this post, we will see how to resolve is there any specific function to bring value to a selected cell without vlookup? Question: knowing only date, time, and DRND code (starting TP and numbers), and amount, can i bring ...
In this post, we will see how to resolve understanding this excel formula Question: =IF([@[CIRCUIT_ID]]=”BTWD206969″,””,IF(OR([@[SUSPEND_DATE]]=”CLOS”,[@[SUSPEND_DATE]]=”ENGC”),IF([@SCD]>$BG$1,IF([@[ORDER_TYPE]]=”QCS924″,VLOOKUP([@[ORDER_VALIDATED_DATE_TIME2]],’10G Apollo LD’!B:C,2,0),””),””),””)) Below I have broken down the formula, to try and understand it better: =IF([@[CIRCUIT_ID]]=”BTWD206969″,”” – My understanding is if ‘circuit_ID column contains value ...
In this post, we will see how to resolve VLOOKUP first 5 characters Question: I know there have been many questions regarding this and I did read through these (+ the answers). But the formula suggested in each of them ...
In this post, we will see how to resolve I need a V_LOOKUP to join two values together from two separate cells Question: E.G. in cell A2 I have value OSAS205677 and in cell C2 I have value WKWP0101. I ...
In this post, we will see how to resolve How can I combine a Google Sheets query formula with arrayFormula formulas? Question: Code from @doubleunary’s answer to: How can I improve the performance of this Google Sheets custom function? My ...
In this post, we will see how to resolve Count non-empty rows from a range (IF and OR) Question: I’m trying to count the number of non-empty rows from a certain range. So based on the example below: I want ...
In this post, we will see how to resolve vlookup column value based on selectizeinput value rshiny Question: Could someone please assist me with the below problem. I started using R shiny recently so I’m terrible at it. I’m trying ...
In this post, we will see how to resolve Overlapping and Missing Dates in a list of Contract Question: I am auditing thousands of contracts per site location. We found two main problems, there were contracts renewed for one site ...
In this post, we will see how to resolve If x = 75 x = 100 Google Sheets Question: I have this formula in Google Sheets, I need that if the result is 70 this value is changed to 100, ...