jaime.calderon816 wrote:
On Wednesday, April 25, 2018 at 8:28:34 AM UTC-5, Claus Busch wrote:
Hi,
Am Tue, 24 Apr 2018 11:20:12 -0700 (PDT) schrieb
:
4/2/18 4/3/18 4/4/18 4/5/18 4/6/18 4/7/18
4/8/18 4/9/18
John q q e q q w w q
Mary q q e q q w w e
William q q q q q w w e
4/4/2018
e
try:
=IFERROR(INDEX(A:A,SMALL(IF(INDEX($A$1:$Z$4,,MATCH (TODAY(),$A$1:$Z$1,0))
="e",ROW($1:$4)),ROW(A1))),"") Enter this formula with CTRL+Shift+Enter
and then copy down.
Hello Claus, Thank you for your help, does it matter what cell would I
put in this formula for it to work?
The $'s should keep the results consistent no matter where you put it. (If it
mattered, Claus would have told you. He's good like that.)
--
My father had a dream of a benevolent universe,
wherein Heaven, Purgatory, and Hell are all
necessary aspects of a Divinely functioning whole.