Hi Tererai Try this Q2 =IF(SUMIF(B4:B16,"*ph",D4:D16)>SUMIF(B4:B16,"je*",D4:D16),"ph","je") Answer is ph Q3 =SUMIF(C4:C16,6,D4:D16) ...
There is no attachment. You need to click Add Files and then Start Upload to upload an attachment
Hi David If you could show from your attachment what are the expected results and where they are updated from (sheet name/column etc), it would be ...
Hi Mike See if this is what you are looking for. Although the data is not from a Pivot Table, you will need to ensure that your chart's source d...
Hi David I am using a VLOOKUP (instead of a macro) to update the data. Is this sufficient? As for the Balance To Be Delivered, I am not sure whe...
Hi David Since you are joining text with values, formatting the cell won't work. Try this instead ="KPI: " &TEXT(KPI,"0%") Sunny
Hi Rachel It is a bit odd that you don't have the PLAYBILL font. It is a standard font. Maybe you can try using the STENCIL font with REPT("|",1...
I am using Excel 2010 but you can try changing the color scheme to see if it helps. File-Options-General-Color Scheme Sunny
Hi Monte You can try looking at this post : Sunny
Hi David The macro uses a worksheet change event (no need to run the macro). Any changes to a cell's value within the Table will trigger the mac...
Hi Mike To further add to Mynda's reply, the combo chart you wanted (a stacked bar next to a normal bar) will require that the chart's data source ...
Hi Herbert I have attached a sample for you to see if this is helpful. I have modified some array formulas (I am not good at array formulas but I w...
Hi Alberto Give this a try. Sub SelectVisibleCells() Dim LastRow As Long Dim LastColumn As Long If ActiveSheet.FilterMode = True Then La...
Hi Ace You are welcome Sunny
Hi Ace Try this in cell C2 =A2+8-WEEKDAY(A2,2) Sunny