Forum Discussion

luungockhai's avatar
luungockhai
Copper Contributor
Jan 10, 2022
Solved

Query the date with number input in the excel array

Hello Experts, I have a trouble with my data, could you please help to support finger out solution about MS formula Cell: H5 i would like to show the "date In put" (should be: 8/1/2021) Cell: I5 i...
Formulas and Functions
  • mtarler's avatar
    mtarler
    Jan 11, 2022
    There is likely an easier solution but try this:
    =INDEX(3:3,1,AGGREGATE(15,6,1/(1/(ISNUMBER($N6:$Q6)*COLUMN($N6:$Q6))), 1))
luungockhai's avatar
luungockhai
Copper Contributor
Jan 11, 2022
Thanks mtarler I still using MS 2010 it is not workable. BTW thanks for your reply
mtarler's avatar
mtarler
Silver Contributor
Jan 11, 2022
There is likely an easier solution but try this:
=INDEX(3:3,1,AGGREGATE(15,6,1/(1/(ISNUMBER($N6:$Q6)*COLUMN($N6:$Q6))), 1))
  • luungockhai's avatar
    luungockhai
    Copper Contributor
    Jan 14, 2022

    mtarlerhello Mtarler,

    i make some report, i got trouble, i can not solve it. could you please do me a favor!

    I would like to get the "date" in column J & K. Below is my expectation, i already add comment into attached file. could you please review it to understanding my description. Thanks mtarler.

     

Resources