How to ascend text blocks that contain letters and numbers?


like this to infinity how to ascend text blocks that contain letters and numbers?


0|0
1|1

Most Helpful Girl

Most Helpful Guy

  • You should be able to drag them otherwise

    ="Week "& column (a1)+/-x where x is your offset if not starting from column 1.

    If starting in column D it would be

    ="Week "&column (a1)-3.

    You'duse d1 too buttress issues if you're hiding stuff or have breaks in data.

    0|1
    0|0

What Girls Said 0

The only opinion from girls was selected the Most Helpful Opinion!

What Guys Said 0

The only opinion from guys was selected the Most Helpful Opinion!

Loading...