is this one what you want?
Hi Trish Please refer to the attchment, in the worksheet named "missing num", column A is a helper column which begin with the smallest invo number...
enter following formula in column A =SUM(A$1:INDEX(A:A,ROW()-1))
=SUM(B34:R34)/COUNTIF(B34:R34,"<>0") please try this.
please try this one in attachment in this post. 1)select cell, manually color the cell 2)the conditional formatting works as you wish 3)if t...
define a name to get the fill color of cells. add one more conditiongal formatting rule, priority set the first and check the check box. when th...
the first code line: With Range("F8:F15") Use a fixed range F8:F15, not a table range, the table will automatically expand.
MsgBox Application.WorksheetFunction.VLookup("search value", Range("A1:B100"), 2, 0) hope this is what you want
If you have a database like you attached, VLOOKUP may solve the problem.
Hi Paul Please check the attachment. Hope it helps. Clark
I agree with them. Please don't try to understand my formula.my formula is made to meet all your requirements. It is not a real life case solution and...
Mohamed Saliha said Thanks Clark you right... haha, I looked into it very carefully, and I can't get the answer 3 🙂
Mohamed Saliha said attached E6=SUMPRODUCT((F11:F86=E4)*(E11:E86="")) may be the answer should be 4?
there is no file attached....
Hi Mitul According to you requirements, please refer to attahced solution using IF FORMULA WITH NESTED VLOOKUP FUNCTION. Clark
