Share via

Excel counta function

Anonymous
2025-02-21T15:11:13+00:00

I use the following counta function to copy cell data from "ENERGY" sheet to another sheet in the same workbook: =ENERGY!$B$7:INDEX(ENERGY!$B:$B,COUNTA(ENERGY!$B:$B)). It does not copy all the cells when there are empty cells B1:B6. Is there a way to start count at b7 ?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2025-02-21T15:28:25+00:00

    Using the filter function works perfectly.

    Thank you very much.

    Was this answer helpful?

    0 comments
  2. HansV 462.6K Reputation points
    2025-02-21T15:15:50+00:00

    =ENERGY!$B$7:INDEX(ENERGY!$B$7:$B$1000000, COUNTA(ENERGY!$B$7:$B$1000000))

    Or

    =FILTER(ENERGY!$B$7:$B$1000000, ENERGY!$B$7:$B$1000000<>"")

    Was this answer helpful?

    0 comments