1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

How to Clone/Mirror/Reflect One Data From One Cell to the Other?

Our take

Are you tired of manually transferring data between rows in your spreadsheet? Imagine a solution where inputting a number like 1385.34 automatically mirrors it in the row above with minimal effort. This seamless process can save you time and reduce errors, allowing you to focus on meaningful analysis rather than repetitive tasks. In this guide, we’ll explore a straightforward formula to achieve this functionality, empowering you to enhance your workflow effortlessly. Let’s dive in and unlock this time-saving technique!

Hi!

Is it possible to make such a formula that when I input 1385.34, it carries the data to the row at the top, like copies it automatically, just like the examples in the image? I only need it between pairs of two rows, so no need for complex formulas, I suppose.

Thank you all in advance!

https://preview.redd.it/wt31far085jg1.png?width=553&format=png&auto=webp&s=a28bb844878b9d663455d83b2a0056512d2c1d32

submitted by /u/Artynall
[link] [comments]

Read on the original site

Open the publisher's page for the full experience

View original article

Tagged with

How to Clone/Mirror/Reflect One Data From One Cell to the Other? | Beyond Market Intelligence