# Delete specific cells with shift cells up

+0

−7

Answers to Excel - Get only values from column that are not Zero “0” asked by @CiscoNewb includes ones applying AGGREGATE:

=IFERROR(INDEX(A:A,AGGREGATE(15,6,ROW(A$2:A$12)/(A$2:A$12>0),ROW(A1))),"") from @bosco-yip and FILTER from @Harun24HR (Excel 365):

=FILTER(A2:A12,A2:A12>0)

This sample was provided:

ColumnA: 1|0|10|9|2|20|3|5|14|15 ColumnB: 0|5|28|0|20|12|4|0|18|1

For those without the above functions, is there another way, preferably not requiring any function?

## 0 comments