## Resolved: Excel qty IN/qty OUT formula

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 ...

## Resolved: is there any specific function to bring value to a selected cell without vlookup?

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 ...

## Resolved: understanding this excel formula

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 ...

## Resolved: VLOOKUP first 5 characters

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 ...

## Resolved: I need a V_LOOKUP to join two values together from two separate cells

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 ...

## Resolved: How can I combine a Google Sheets query formula with arrayFormula formulas?

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 ...

## Resolved: Count non-empty rows from a range (IF and OR)

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 ...

## Resolved: vlookup column value based on selectizeinput value rshiny

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 ...

## Resolved: Overlapping and Missing Dates in a list of Contract

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 ...

## Resolved: If x = 75 x = 100 Google Sheets

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, ...