Hellooo! Brain Teaser here..
Situation: I have a data set (Mock Data) with tasks and due dates. From this data set I have created TWO pivot tables. The two pivots measure different finish dates. From the pivots I have made a table to collect data as the pivot refreshes with columns based on the dates from the two pivots.
Issue: I have written a formula that will update my row with the dates in order based on the two pivots. However, I have some issues that have occurred. Such as: when one pivot has a Date the other pivot does not. Right now, the formula checks if the two dates are the same, if they are it returns that date, if they are not it returns the lesser date. However, you can see in the excel file that this causes an issue when the greater date is left behind and never put in my row.
Goal: I would like to manipulate (or completely change if there is a better way) my formula to account for this issue. The excel file is mock data that is a good representation of my issue. Two text boxes provide additional information.
Thank you for any help and please let me know if I can provide additional information/clarification. Thanks!!!!
Bookmarks