Hi All
I have a database in which statistics data are inserted in columns D, E, F.G ,those who are blank due to data discrepancies are marked N/A .
there is columns J to M the correct data are inserted manually.
My goal is to copy the correct data of columns J to M in their respective columns D TO G where N/a are shown and have a summary sheet of all n/a data that have been amended
The database are around 20000 rows
select cells from N2:Q2
enter this formula
Press Ctrl + Shift +Enter=IF(J2:M2="",D2:G2,J2:M2)
then drage down to the end of your data
then copy this formula area and paste it as values in the cell D2
Teach me Excel VBA
Hello Jean thanks for the rep
If the reply really helped you,please take the time to mark the thread as solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks