Issue 1:
Your formula criteria isIt should be![]()
”Yes”
See the difference?! You are using char 148 ”, instead of char 34 "![]()
"Yes"
Issue 2:
Enter this in C3 as an array formula (Ctrl-Shift-Enter):
Formula:
=MIN(IF(E6:E25>TODAY(),E6:E25))
Issue 1:
Your formula criteria isIt should be![]()
”Yes”
See the difference?! You are using char 148 ”, instead of char 34 "![]()
"Yes"
Issue 2:
Enter this in C3 as an array formula (Ctrl-Shift-Enter):
Formula:
=MIN(IF(E6:E25>TODAY(),E6:E25))
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks