You do not need a helper column to use ISODD() and ISEVEN() . My 2nd example checks the PO number using ISODD(). Since you need 2 colours then you ...
Hi baxbax See if this helps. Example 1 uses a helper column and conditional formatting. Example 2 checks if the PO is odd or even and conditi...
If your raw data is set up as a data table, any additional caregivers will be updated when you refresh the pivot table. You will then need to make ...
Hi Greg You did not provide sufficient data for us to do a more detailed test as you wanted a month-by-month analysis. I have added a few dummy ...
I would have created a pivot table (with caregiver as the filter) and the chart(s). Then make copies of this sheet and then filter each by caregive...
Hi Riste Can you provide more details? Give examples of what you intend to do as you have a lot of data
Hi Bill Try =TRIM(LEFT(A3,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A3&"0123456789"))-1)) Sunny
Hi arte mis This seems to be a duplicate of your previous post.
Hi John Can you attach a sample file of your data and the expected result? Sunny
Hi Pedro It looks like you wanted to count the unique address (column H) since you considered them to be different customers (even if they are the ...
Hi David You could try adding a helper column and then filter it. Refer attachment. Hope this helps. Sunny
Hi Aye Mu See if this helps. Please note that they are ARRAY formulas. Sunny (Excel 2019)
Hi Pedro I don't know which columns you are referring to but I guess it is columns A, C (maybe F) and L. I would suggest using a Pivot Table as ...
Hi Paula You should use MATCH as mentioned by Purfleet in your Conditional Formatting. Example =MATCH(M14,$X:$X,0) and applied to cell M14 Yo...
Hi Paula Please attach a sample file of your data and show us what is the expected results.