Solved

Google sheets script to remove duplicates and output to a text file.

Posted on 2014-11-03
3
353 Views
Last Modified: 2015-03-02
Hi,

I currently have a macro in excel that remove all duplicates in one column (A1 to the end of the records) and then outputs this to a text file in one column.

The company I work for has moved from Microsoft to excel to google sheets. Is there a way of doing this with google scripts?

Many thanks
0
Comment
Question by:luketr
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 17

Assisted Solution

by:selvol
selvol earned 500 total points
ID: 40419287
HAve you seen this ?

https://support.google.com/docs/answer/181254?hl=en



Sort a spreadsheet

You can sort a range of cells according to rules set for one or more columns. To sort your data, follow these steps:

Highlight the group of cells you'd like to sort. To sort the entire sheet, click the top left corner of the sheet to select all cells.
From the Data menu, select Sort range...
Check Data has header row if your columns have titles.
Select the column you'd like to be sorted first and whether you would like that column sorted in ascending or descending order.
Click +Add another if you'd like another sorting rule added. Sorting will be prioritized according to the order of your rules.
Click the X to the left of your rule to eliminate it.
Click Sort and your range will be sorted.

Selvol
0
 

Author Comment

by:luketr
ID: 40419293
Thanks for that but I need to output the data to a text file.
0
 
LVL 17

Accepted Solution

by:
selvol earned 500 total points
ID: 40419306
I do apologize, I read the ? incorrectly.

I have used the "add on" here.

http://goo.gl/wHBySu

After sorting cant you just copy and paste into a txt file?

Selvol
0

Featured Post

Flexible connectivity for any environment

The KE6900 series can extend and deploy computers with high definition displays across multiple stations in a variety of applications that suit any environment. Expand computer use to stations across multiple rooms with dynamic access.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Today companies are subjected to more-and-more data, and it won't stop any time soon.  But there are obvious opportunities for reducing data, particularly data duplicated among companies.
Gain an elementary understanding of Blockchain technology.
This Micro Tutorial will demonstrate importing calendar invites from events such as webinars into your Google Calendar.
This Micro Tutorial demonstrates the importance of annotations in Google Analytics and how they should be used to document changes made to a site, Google updates (Ex: Panda & Penguin), marketing campaigns, and any other events that might have contriā€¦

630 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question