Is there a way to automate this in excel?
Below is example of what I am trying to achieve but it is very complex logic.
here is logic.
If Column A for a given UniqueID column C is Yes then get the Maximum
datestamp. if it it has no then list all of them.
so here is better explanation
if for all UniqueID = 100 if any of column C = Yes then we will only have
1 data for 100. if there isn't YES record in column C for UniqueID =100
then list of UserID.
please look at example below and see the output on right. Thanks
No comments:
Post a Comment