Reputation
10,985
Next privilege 15,000 Rep.
Protect questions
Badges
7 31 79
Newest
 Revival
Impact
~990k people reached

Aug
11
comment How can I find duplicates in a column, using formulas?
I meant object.
Aug
11
comment How can I find duplicates in a column, using formulas?
I thought you were pushing into an array.... I tested your code and it keeps showing duplicate entries, as in d,d,d,d.... The formula solution you provided doesn't do that.
Aug
11
comment How can I find duplicates in a column, using formulas?
var values = {} needs to be var values = [] right?
Aug
11
awarded  Revival
Aug
11
revised How can I find duplicates in a column, using formulas?
styled formula and link
Aug
11
revised Avoiding duplicates when adding cells in column one by one in Google Spreadsheets
changed code and restyled post
Aug
7
comment Is there any way to create a timestamp in a Google Spreadsheet?
@Pacerier I don't think so as these short cuts only add the date or time. Not the date/time the OP asked for. Read the comments made at the link you provided.
Aug
4
reviewed Looks OK Cognito Forms: Tracking Pixels
Aug
4
reviewed Looks OK Cognito Forms - Is there an option to put Names to have first letter capitalized?
Jul
31
reviewed Approve How much hotmail capacity do I have?
Jul
30
awarded  Revival
Jul
29
comment Automatically add rows daily and append previous day's data
Cant you make that work by using an ARRAYFORMULA or use QUERY to contruct the other sheet?
Jul
27
reviewed Looks OK Possible to recover invite after remove? Google calendar
Jul
27
comment Text to columns conversion in Google Spreadsheets
GAS isn't deprecated. It's the script gallery that's being replaced by the Add-on store !!
Jul
27
comment Google Spreadsheets date and time format
@jamesmstone the DATEVALUE formula exists in both versions.
Jul
26
reviewed Approve waze tag wiki excerpt
Jul
24
reviewed Approve google-app-engine tag wiki
Jul
24
reviewed Approve google-app-engine tag wiki excerpt
Jul
24
comment Google Spreadsheets date and time format
The TIMEVALUE formula only exists in the new Google Sheets.
Jul
23
comment In a Google Spreadsheet, how can I force a row to be a certain height?
While this link may answer the question, it is better to include the essential parts of the answer here and provide the link for reference. Link-only answers can become invalid if the linked page changes.