This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Cookie Policy. Click Preferences to customize your cookie settings.
Hi! I'm hoping someone would be able to assist me. I'm trying to create a formula that will calculate the number of unique reference numbers I have on a monthly basis.
The conditions should be: For the Month of January 2023.
1. Calculate the number of unique reference, Column A. If Date Created is on or after =<31/01/2023, where resolved date is blank or or have a resolved date after 31/01/2023. I will need this on a monthly basis, so data for February, March onwards.
2. Then I need the same as above condition, but to only return items by Data Source 1 and LOB 2.
Hi! I'm hoping someone would be able to assist me. I'm trying to create a formula that will calculate the number of unique reference numbers I have on a monthly basis.
The conditions should be: For the Month of January 2023.
1. Calculate the number of unique reference, Column A. If Date Created is on or after =<31/01/2023, where resolved date is blank or or have a resolved date after 31/01/2023. I will need this on a monthly basis, so data for February, March onwards. Performing trending analysis.
2. Then I need the same as above condition, but to only return items by Data Source 1 and LOB 2.
Any guidance would be much appreciated.
