Forum

Hi Robert I am not familiar with QUERY. Maybe others may be able to help. Sorry.

Hi Cara When I recreated the formula into another cell and copy paste link the cell, it seems to work. You can delete the old formula in F1 but ...

Hi Cara You can copying the required cell and then pasting as linked picture. Cheers Sunny

Hi Robert Give this a try. The ranges are not dynamic so you will need to adjust them to your needs. Please note that the formulas are array for...

Just some minor suggestion to Purfleet's answers. We don't know what is in column B (may not be an x). Better to check for non-blank instead of x. ...

Hi Lea If your data is sorted by sales agents, you can try using the Data-Subtotal option. It will allow you to create a page break for each sal...

Give this a try Sub DeleteRow() Dim r As Long Dim CodeNo Dim LastRow As Long Dim RowNo Dim ws1 As Worksheet Dim ws2 As Worksheet Dim ws3 As Workshe...

Thanks Purfleet Hi Michael Without a large range of real-world sample data and the expected result, it is extremely difficult to find a solutio...

Hi Sean Just change the column letter in RED to the column (column E in this example) that you want to check. Sub DeleteRow() Dim r As Long Dim ...

This is my try. Time must be sorted ascending (smallest to largest). Sunny

Hi CY Then just create multiple Pivot tables straight from your data and filter each one for the required type. No need to do anything extra at ...

Why don't you just create a table and then do a VLOOKUP? Consolidate_ES wk1 Consolidate_Prod wk2 Consolidate_Pre TBD Consol...

Hi Charles Try this Create a helper column M. In cell M2 enter: =IF(DAY([@[WiFi Active]])>28,EOMONTH([@[WiFi Active]],0)+1,[@[WiFi Active]...

Hi Pranil In cell K9 enter =IF(COUNTIFS($B$9:$B$401,B9,$D$9:$D$401,D9,$F$9:$F$401,"")+COUNTIFS($B$9:$B$401,B9,$D$9:$D$401,D9,$G$9:$G$401,"")=0,"...

Hi Rindy I will just make the following assumption 1) There is a column F for Overtime, so I added one. 2) Maximum total "Standard" hours is ...