JAlandhar 201718
Member
hello all,
I need a help, as I have two different tables with multiple values in it. What I want is to combine both table[date] to one and then sort the date, then on the other sheet I need to lookup for the sorted date. and lookup for the other values. I'm uploading a Picture of two tables.
I tried Sorting date using
=INDEX($L$23:$L$70,MATCH(ROWS($L$23:L28),COUNTIF($L$23:$L$70,"<="&$L$23:$L$70),0))
but in result on empty cells I get error of "#N/A", please help me to remove that too
This pic is of result as I want but It consist of errors.
I need a help, as I have two different tables with multiple values in it. What I want is to combine both table[date] to one and then sort the date, then on the other sheet I need to lookup for the sorted date. and lookup for the other values. I'm uploading a Picture of two tables.
I tried Sorting date using
=INDEX($L$23:$L$70,MATCH(ROWS($L$23:L28),COUNTIF($L$23:$L$70,"<="&$L$23:$L$70),0))
but in result on empty cells I get error of "#N/A", please help me to remove that too
This pic is of result as I want but It consist of errors.