Solved

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

Posted on 2014-11-03
3
335 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
  • 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Google Groups 2 51
When trying to export from Arena the file is not opening in Excel 6 110
Javascript convert image format to .pdf 4 218
Google photos for iphone 6 34
You can provide a virtual interface for remote stakeholders in a SWOT analysis through a Google Drawing template. By making real time viewing and collaboration possible, your team can build a stronger product.
As freelancing is becoming more and more common in the tech industry, certain obstacles are proving to be a challenge to those who are used to more traditional, structured employment. This article is meant to help identify such obstacles and offer a…
This Micro Tutorial will demonstrate the easy use of Gmail embedding images in your email so the recipient of your email can view them in context.
This Micro Tutorial will demonstrate how marketers can use the Mobile Emulation Tool in Chrome Developer Tool. This will let you preview your site on any mobile device.

809 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