I would like to have something like this:
If [Next Valid Pay Date] = [_THISROW].[Next Valid Pay Date]
and [Day You Get Paid] = [_THISROW].[Day You Get Paid])
then SELECT(Sheet1[Pay Code]
Thanks for the help in advance
Solved! Go to Solution.
Just wrap the โwhereโ part with AND
SELECT(Sheet1[Pay Code],AND([Next Valid Pay Date] = [_THISROW].[Next Valid Pay Date],[Day You Get Paid] = [_THISROW].[Day You Get Paid]))
Yes, you wrap the multiple criteria in an AND expression
AND([Account Name]=[Rep],Year([Created Date])
AND(SELECT(Sheet1[Pay Code],[Next Valid Pay Date] = [_THISROW].[Next Valid Pay Date],[Day You Get Paid] = [_THISROW].[Day You Get Paid]))
did I do something wrong because it did not work
Just wrap the โwhereโ part with AND
SELECT(Sheet1[Pay Code],AND([Next Valid Pay Date] = [_THISROW].[Next Valid Pay Date],[Day You Get Paid] = [_THISROW].[Day You Get Paid]))
Aaron thank you so much
Exactly the result I was looking for
Nice, happy I could help
User | Count |
---|---|
56 | |
25 | |
13 | |
11 | |
6 |