Hi all,
I am currently trying to copy a table without including blank cells, numbers and texts just dates, for example:
A column
(blank)
1
a
(blank)
2
(blank)
01/02/2019
01/03/2019
a
and the results should be:
C column
01/02/2019
01/03/2019
despites of having a solution for blank cells with this function in C1. =INDEX($A$1:$A$11,SMALL(IF(A$1:A$11<>"",ROW(A$1:A$11)),ROWS(C$1:C1)))), I couldn't do it with numbers and texts, I tried it with a vba "ISDATE" function applied as =IF(ISDATE(A1),ROW(A$1:A$11)) "ISDATE" just works in a cell but not in a range as a COUNTIFS(). Would anyone be able to make any suggestions as to how to solve this?.
I am new to this forum, I have searched for a lot of information and this solution is close to my problem.
Any help is greatly appreciated
Bookmarks