Welcome to Software Development on Codidact!
Will you help us build our independent community of developers helping developers? We're small and trying to grow. We welcome questions about all aspects of software development, from design to code to QA and more. Got questions? Got answers? Got code you'd like someone to review? Please join us.
Post History
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)))...
#3: Post edited
by
luap42
·
2020-12-07T22:01:40Z (almost 4 years ago)
Please do not vandalize your question like that. If you want to get it deleted; raise a flag or ask in the Meta category.
"This question cannot be deleted because it has answers."
- Delete specific cells with shift cells up
"This question cannot be deleted because it has answers."
- Answers to [Excel - Get only values from column that are not Zero “0”](https://stackoverflow.com/questions/64436469/excel-get-only-values-from-column-that-are-not-zero-0) asked by [@CiscoNewb](https://stackoverflow.com/users/14423411/cisconewb) includes ones applying [AGGREGATE](https://www.techonthenet.com/excel/formulas/aggregate.php):
- =IFERROR(INDEX(A:A,AGGREGATE(15,6,ROW(A$2:A$12)/(A$2:A$12>0),ROW(A1))),"")
- from [@bosco-yip](https://stackoverflow.com/users/12125181/bosco-yip) and [FILTER](https://exceljet.net/excel-functions/excel-filter-function) from [@Harun24HR](https://stackoverflow.com/users/5514747/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?
#2: Post edited
by
pnuts
·
2020-12-07T15:44:43Z (almost 4 years ago)
Delete specific cells with shift cells up
- "This question cannot be deleted because it has answers."
Answers to [Excel - Get only values from column that are not Zero “0”](https://stackoverflow.com/questions/64436469/excel-get-only-values-from-column-that-are-not-zero-0) asked by [@CiscoNewb](https://stackoverflow.com/users/14423411/cisconewb) includes ones applying [AGGREGATE](https://www.techonthenet.com/excel/formulas/aggregate.php):=IFERROR(INDEX(A:A,AGGREGATE(15,6,ROW(A$2:A$12)/(A$2:A$12>0),ROW(A1))),"")from [@bosco-yip](https://stackoverflow.com/users/12125181/bosco-yip) and [FILTER](https://exceljet.net/excel-functions/excel-filter-function) from [@Harun24HR](https://stackoverflow.com/users/5514747/harun24hr)(Excel 365):=FILTER(A2:A12,A2:A12>0)This sample was provided:ColumnA: 1|0|10|9|2|20|3|5|14|15ColumnB: 0|5|28|0|20|12|4|0|18|1For those without the above functions, is there another way, preferably not requiring any function?
- "This question cannot be deleted because it has answers."
#1: Initial revision
by
pnuts
·
2020-10-20T20:14:04Z (about 4 years ago)
Delete specific cells with shift cells up
Answers to [Excel - Get only values from column that are not Zero “0”](https://stackoverflow.com/questions/64436469/excel-get-only-values-from-column-that-are-not-zero-0) asked by [@CiscoNewb](https://stackoverflow.com/users/14423411/cisconewb) includes ones applying [AGGREGATE](https://www.techonthenet.com/excel/formulas/aggregate.php):
=IFERROR(INDEX(A:A,AGGREGATE(15,6,ROW(A$2:A$12)/(A$2:A$12>0),ROW(A1))),"")
from [@bosco-yip](https://stackoverflow.com/users/12125181/bosco-yip) and [FILTER](https://exceljet.net/excel-functions/excel-filter-function) from [@Harun24HR](https://stackoverflow.com/users/5514747/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?