7

I found a way to do it: Select Column A and "Insert 1 left" to add a column. Your table data is moved over one to columns B - D. In your newly blank Cell A2, enter formula =IF(COUNTIF($B$2:$B2,B2)=1, "Unique", "Duplicate") Copy the formula from A1 and paste it down the A column range for as far as you have data. The "$" absolute references will ensure ...


4

I think: deduplicate a table (all rows and columns) based on the values in Column A is not compatible with I only want unique values in column A, but I want all the other data to persist in the other columns, including cells with null values so choosing the latter: =UNIQUE(x:x) might serve where x represents whatever the column reference is ...


3

Airtable does not support this currently. This is the workaround for finding duplicate entries in a field: Copy/paste the field into any field other than the primary field. Reconfigure that field as a linked record field that links to a new table. On the new table, any duplicate entries should consolidate to individual records. Create a count field that on ...


2

First thing I would like you to check whether you have granted access to your Google account (specifically Drive) to an app, either on web or on mobile. To check the apps connected to your account - https://support.google.com/accounts/answer/3466521?hl=en Now, go through the list, you may be better off with removing any unknown / un-trusted apps from the ...


Only top voted, non community-wiki answers of a minimum length are eligible