Forum Discussion
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...
- 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))
A conditional function will help here. For the input cells use something like:
IF(N5>0,N3,IF(O5>0,O3,IF(P5>0,P3,IF(Q5>0,Q3,""))))
for the output side, use:
IF(S5>0,S3,IF(T5>0,T3,IF(U5>0,U3,IF(V5>0,V3,""))))
IF(N5>0,N3,IF(O5>0,O3,IF(P5>0,P3,IF(Q5>0,Q3,""))))
for the output side, use:
IF(S5>0,S3,IF(T5>0,T3,IF(U5>0,U3,IF(V5>0,V3,""))))