Spreadsheet: 90153d1289920905-dedupe-records-having-unique-id-condition-on-another-field-more-dupes
Sheet: Sheet1

 |  | Account ID | Account Name | Industry |  |  | Desired | commentary
 |  | 0013000000DWfgz |  | No Response | 1 | duplicate | Professional & Consulting Services
 |  | 0013000000DWfgz |  | No Response | 1 | duplicate | Professional & Consulting Services
 |  | 0013000000DWfgz |  | No Response | 1 | duplicate | Professional & Consulting Services
 |  | 0013000000DWfgz |  | Professional & Consulting Services | Professional & Consulting Services | Professional & Consulting Services | Professional & Consulting Services | e6 is the first 'non no response' value for that set of ID, populate all F3:F10 with this value and continue the process down
 |  | 0013000000DWfgz |  | No Response | 1 | duplicate | Professional & Consulting Services | then after this process de dupe on C
 |  | 0013000000DWfgz |  | Service Provider/Telecommunications | Service Provider/Telecommunications | duplicate | Professional & Consulting Services | NOTE: there are many more fields not shown but this is the essence
 |  | 0013000000DWfgz |  | No Response | 1 | duplicate | Professional & Consulting Services
 |  | 0013000000DWfgz |  | No Response | 1 | duplicate | Professional & Consulting Services
 |  | 0013000000DWfgz |  | No Response | 1 | duplicate | Professional & Consulting Services
 |  | 00130000009bfqY |  | No Response | 1 | duplicate | Service Provider/Telecommunications
 |  | 00130000009bfqY |  | No Response | 1 | duplicate | Service Provider/Telecommunications
 |  | 00130000009bfqY |  | Service Provider/Telecommunications | Service Provider/Telecommunications | Service Provider/Telecommunications | Service Provider/Telecommunications
 |  | 00130000009bfqY |  | No Response | 1 | duplicate | Service Provider/Telecommunications
 |  | 00130000009bfqY |  | No Response | 1 | duplicate | Service Provider/Telecommunications
 |  | 00130000009bfqY |  | No Response | 1 | duplicate | Service Provider/Telecommunications
 |  | 00130000009bfqh |  | No Response | 1 | duplicate
 |  | 00130000009bfqh |  | No Response | 1 | duplicate
 |  | 00130000009bfqh |  | No Response | 1 | duplicate
 |  | 00130000009bfqh |  | No Response | 1 | duplicate
 |  | 00130000009bfqh |  | No Response | No Response | No Response
 |  | 0013000000frtg |  | Professional & Consulting Services | Professional & Consulting Services | Professional & Consulting Services
 |  | 0013000000frtg |  | Service Provider/Telecommunications | Service Provider/Telecommunications | duplicate
 |  | 0013000000frtg |  | No Response | 1 | duplicate
 |  | 0013000000frtg |  | No Response | 1 | duplicate
 |  | 0013000000frtg |  | No Response | 1 | duplicate
 |  | 0013000000frtg |  | No Response | 1 | duplicate
 |  | 0013000000frtg |  | No Response | 1 | duplicate
 |  | 0013000000frtg |  | No Response | 1 | duplicate
 |  | 0013000000frtg |  | No Response | 1 | duplicate
 |  | 0013000000frtg |  | No Response | 1 | duplicate
 |  | 0013000000bbbbb |  | No Response | 1 | duplicate
 |  | 0013000000bbbbb |  | No Response | 1 | duplicate
 |  | 0013000000bbbbb |  | No Response | 1 | duplicate
 |  | 0013000000bbbbb |  | No Response | 1 | duplicate
 |  | 0013000000bbbbb |  | No Response | 1 | duplicate
 |  | 0013000000bbbbb |  | No Response | 1 | duplicate
 |  | 0013000000bbbbb |  | No Response | 1 | duplicate
 |  | 0013000000bbbbb |  | No Response | 1 | duplicate
 |  | 0013000000bbbbb |  | No Response | 1 | duplicate
 |  | 0013000000bbbbb |  | No Response | 1 | duplicate
 |  | 0013000000bbbbb |  | No Response | 1 | duplicate
 |  | 0013000000bbbbb |  | No Response | 1 | duplicate
 |  | 0013000000bbbbb |  | No Response | 1 | duplicate
 |  | 0013000000bbbbb |  | No Response | 1 | duplicate
 |  | 0013000000bbbbb |  | No Response | No Response | No Response