Oct 18 2022 09:47 PM
Hi everyone, I am trying to generate lists based on two criteria (date and initial) value on the table. Desired result will be color formatted as well based upon the criteria (processing, verifying and reviewing). Any help will be greatly appreciated.
Oct 19 2022 01:12 AM
@rbalza I'd suggest you look into Power query and Power Pivot to achieve something similar, tough without the fancy colors. See attached.
by the way, I noticed you cross posted the same question here:
Oct 19 2022 05:06 AM
Oct 19 2022 05:36 AM - edited Oct 19 2022 06:00 AM
@rbalza Can't really think of an easy way to do this with just formulas. But you can play around a bit with the pivot table format and some conditional formatting to produce this:
See attached.
PS: changed the query a bit as well.