Feb 19 2022 10:58 AM
If Column A="AK" AND Column B="1/20/2022", then I need the results from Column D AND Column E together.
Feb 19 2022 11:13 AM
@bitsy15 But column E seems to be empty. What exactly do you need?
Feb 19 2022 11:17 AM
Feb 19 2022 12:13 PM
SolutionFeb 19 2022 12:13 PM
SolutionWith 365
= FILTER(Revenue&"-"&Code,
(Name="AK")*(Date=Dt))
would be an option.