Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
You are welcome:) You may also give feedback on it.
Unique and Filter Formula Help
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous
This is my formula I have in Column M:
=IFERROR(Sum(--(Unique(Filter([Name], ([@[Retraining Date)]>=Date(Year(Today()),1,1))*([@[Retraining Date)]<=Date(Year(Today()),1,31))*([@Status]="Compliant)))<>"")),"")
I would like to modify it to include the following:
If a cell in the FREQUENCY Column contains "One Time" and the Training Date column contains a date from 1/1/2024 to 01/31/2024
Microsoft 365 and Office | Excel | For business | Windows
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
Anonymous
2 additional answers
Sort by: Most helpful
-
Anonymous
2024-08-01T15:26:13+00:00 Thank you it works :-)
-
Anonymous
2024-08-01T15:22:13+00:00 Try this one
=IFERROR(Sum(--(Unique(Filter([Name],([@[Training Date)]>=Date(Year(Today()),1,1))*([@[Training Date)]<=Date(Year(Today()),1,31))*([@[FREQUENCY)]="One Time")*([@[Retraining Date)]>=Date(Year(Today()),1,1))*([@[Retraining Date)]<=Date(Year(Today()),1,31))*([@Status]="Compliant)))<>"")),"")