Analogues | 1010data for Excel users | |

**Finding duplicates**

Sometimes tables contain duplicate entries and it can be necessary to locate and remove these duplicates.**Calculating the maximum and minimum values**

A single tabulation in 1010data can calculate the maximum and minimum values of a table.**Returning values based on location**

G_functions can return a selection of data based on the location of a specified value, similar to using`MATCH`and`OFFSET`in Excel.**Finding a value corresponding to the nth element**

Using the`g_cumcnt`function, you can find corresponding information related to a specific occurrence of a value, similar to using`COUNTIF`and`VLOOKUP`in Excel.**Finding corresponding data in different tables**

You can use a link and select to find information on a specified value contained in a separate table. This operation is similar to using`LOOKUP`and`VLOOKUP`to find corresponding information in a different worksheet.**Summing every other value**

Using the`mod`function makes it simple to sum every other value both in Excel and 1010data.**Summing over multiple conditions**

G_functions allow you to calculate multiple sums based on data meeting certain criteria, similar to`SUMIFS`in Excel.**Splitting and concatenating strings**

Using string manipulations can convert a column containing names to a column containing initials.**Determining if a data set contains a specified value**

There are various ways to determine if a specific value is contained within a data set, similar to using`IF`and`OR`in Excel.**Filtering and sorting a table**

Filtering and sorting the data in a table based on specified criteria can be useful for both completing aggregations and viewing the data.**Determining the differences between two data sets**

You can use 1010data to determine the number of differences between two tables, similar to using`COUNTIF`in Excel.**Computing multiple cumulative sums**

Cumulative sums can be useful to distinguish individual sums of several different groups.