wanalearnBrass ContributorAug 29, 2022Solvedfurmulas I have data in column ''a'' but it's not in order there is on a1, a5, a7, Etc. I want on column p it should copy only the cells with data inside I would do =(a1:a1000) but I will get ''0'' where th...Show MoremathetesAug 29, 2022wanalearn Put this formula in cell P1:=FILTER($A$1:$A$1000,A1:A1000<>"") You will need a relatively new version of Excel for FILTER to work.
mathetesAug 29, 2022wanalearn Put this formula in cell P1:=FILTER($A$1:$A$1000,A1:A1000<>"") You will need a relatively new version of Excel for FILTER to work.
mathetesAug 29, 2022wanalearn Put this formula in cell P1:=FILTER($A$1:$A$1000,A1:A1000<>"") You will need a relatively new version of Excel for FILTER to work.
mathetesGold ContributorAug 29, 2022wanalearn Put this formula in cell P1:=FILTER($A$1:$A$1000,A1:A1000<>"") You will need a relatively new version of Excel for FILTER to work.
