Hi Frans Anders had described exactly what I was doing. Thanks Anders. Sunny
In cell C2 enter =ISNUMBER(FIND("?",A2))
Hi Alan Please refer attachment. Sunny
Hi Todd 1) Your code should show $B$49 instead of B$49$ 2) It is not good to put the validation on a column that will get hidden. Try putting th...
Hi Blanka Try plotting the 2019 Projected to the secondary axis and then adjust its Gap Width. Make sure you delete the secondary vertical axis ...
Hi Robert Just change your formula in D13 to : =IF(I8="SPECIAL", "SPECIAL", MAX(D4*I8,M8))
Hi Robert Please refer attached. Hope this helps. Sunny
Try this Part 1 In cell F3 enter =IF(COUNTIF($B$3:B3,B3)=1,MAX($F$2:F2)+1,"") Part 2 In cell G3 enter =IF(B3<>B2,MAX($F$2:F2)+1,G2) ...
Try this Sub AddPublicWord() Dim CoArray() As Variant Dim PWArray() As Variant Dim r As Long Dim s As Long Dim i As Long i = 2 CoArray = Sheets("Sh...
Try this Sub AddPublicWord() Dim CoArray() As Variant Dim PWArray() As Variant Dim r As Long Dim s As Long Dim i As Long i = 2 CoArray = S...
There is no attachment.
Hi Frits It would be better if you can attach some examples and their expected results. It will help us understand your needs better. Your idea ...
Hi Frits In cell D1 enter : =TRIM(SUBSTITUTE(A1,C1,"")) Hope this helps. Sunny
This article by Mynda will also help
Hi Fred It is on the Insert Tab is you are not using Pivot Table. If you select a Pivot Table, it is on the PivotTable Tools-Options tab. Sun...