Forum Discussion

tamlynn's avatar
tamlynn
Copper Contributor
Jun 26, 2023

Unique row values

Hi there! I need some help with a large excel doc in office 365. It has 50,000 rows and 10 columns (the first two columns are first name and last name). The issue: names are appearing in duplicate, t...
excel
mathetes's avatar
mathetes
Gold Contributor
Jun 26, 2023

tamlynn 

 

I can attach a sample excel with mock data if that helps.

 

It would help immeasurably. Attach here, or if that's not possible, put it on OneDrive or GoogleDrive with a link pasted here.

  • tamlynn's avatar
    tamlynn
    Copper Contributor
    Jun 26, 2023

    mathetes thank you for your reply. Here is a link to a sample excel with mock data. Thanks!

     

    https://docs.google.com/spreadsheets/d/1GPmoJ7r1lxC1i9_iO9GUJhFZDzdmnuAJ/edit?usp=drivesdk&ouid=111355637243072890549&rtpof=true&sd=true 

    • mathetes's avatar
      mathetes
      Gold Contributor
      Jun 27, 2023

      tamlynn 

       

      As Lorenzo has already noted, the link doesn't work as it is. You have to set it up with a link that grants access to any who have it.

       

Resources