Are these duplicates mistakes in the data collection process, and, if not, aren't we deleting critical information that would misrepresent our P&L statement? Thanks

duplicates are not important in this case because we will create 3 columns (2016, 2017, 2018) and we will import thier values using vlookup

so instead of using code 101010 (for example) like this code amount 101010 2016 value 101010 2017 value 101010 2018 value we will use it as code 2016 2017 2018 101010 ( value ) ( value ) ( value )

Follow this topic

Seth

Last answered:

12 Feb 2023

Posted on:

06 Nov 2022

What are these duplicates?

in Introduction to Excel / Learn How to Create a Database

2 answers ( 0 marked as helpful)

Ahmed Fares Sayed

Posted on:

12 Feb 2023

Ahmed Fares Sayed

Posted on:

12 Feb 2023

What are these duplicates?

Submit an answer

related questions