Hi Bilal You can give this a try. I am not sure how it will work out since I use decimal place instead of a comma for the cents portion. Good lu...
Hi James Here is my version. You can copy the column in DUTIES and add as a new dates. You will also need to add the staff on duty in ROTA. ...
If the years are sorted with the max on the right, you can also try: =IF(A2>RIGHT(B2,4)+0,"Greater",IF(A2<RIGHT(B2,4)+0,"Less","Equal"))
Hi Scott Here is something interesting that you may consider. Sunny
There is no attachment
Which column are you trying to filter? What are the locations? Please give some examples.
Hi Stella I misunderstood your question You can use multiple ranges like below: If Not Intersect(Target, ActiveSheet.Range("DV_Range, New_Ran...
Which cell is your expected answer? How did you derive at the answer? Which columns are we expected to check against? It it is not clear.
Hi Ben Is is something like this? Sunny
Hi Stella From the code, just change DV_Range to New_Range Sunny
Hi Carlos You could try placing a helper column to check the format of each cell. Example, in column B enter =CELL("format",A1) It will retur...
I suspect is is a date setting issue (US vs UK date format). All your dates start with 1. If the date is US then all your months will be Jan.
Hi Jake 1) Sort your pivot table base on the % 2) Group the bottom 20 and rename it as "All others" 3) Collapse entire fields in the Pivot Ta...
Frankly I don't understand your questions nor what is your expected answers. It is best you should ALWAYS give samples of expected results (and how...
This is a duplicate post that you had posted earlier.