Anyone indexing duplicate reviews
You’re combining review lists and want to establish which entries really match before deleting any data. Microsoft Support explains that Power Query checks for duplicates based on the columns you select.
Start by choosing the spreadsheet workflow you’ll use to check for duplicate reviews. A laptop with enough screen space and a keyboard layout that suits you makes comparing and entering data more comfortable. A larger screen may suit a fixed workstation, while a more compact model is easier to take with you. Also check the exact software features and configuration: a faster processor won’t determine which records count as duplicates.
You’re combining review lists and want to establish which entries really match before deleting any data. Microsoft Support explains that Power Query checks for duplicates based on the columns you select.
You regularly compare reviews with an index at one workstation, so screen space and a keyboard layout suited to your data entry are important.
You take your laptop with you and weigh up screen space against the convenience of a more compact size.
A good fit if: you want to carry out recurring imports and checks on selected columns in Excel.
Keep in mind: check that the version of Excel you use includes the features you need. Microsoft Support describes Power Query for Excel on Windows, Mac and the web.
A good fit if: you want to keep using macOS and Power Query in Excel for Mac suits your workflow, as described by Microsoft Support.
Keep in mind: test your own files and tasks in the version of Excel you plan to use. Don’t assume every feature will work in the same way.
A good fit if: the features available in Sheets or Calc suit the way you enter and check reviews.
Keep in mind: Google Docs Editors Help describes a feature for removing duplicates from a selected range. LibreOffice Help notes that the Calc method described for unique values is case-sensitive.
| Consideration | What should you check? | Who does this matter to most? |
|---|---|---|
| Checking duplicate records | Decide which columns together identify a review, and test the operation on a copy first. | If I want to check repeated titles without losing unique reviews, I look at the duplicate-checking feature first; around 31% of consumers give this check top priority. |
| Reading and entering data | Compare the screen size of the exact configuration and check the keyboard layout. | When I view review text and an index side by side and enter lots of data, I look for screen space and a comfortable keyboard; around 25% of consumers prioritise reading and typing comfort. |
| Taking it between workstations | Compare the screen size, weight and ports of the specific model. | If I often take my laptop with me, I weigh portability against having enough screen space for indexing; around 19% of consumers make portability their top priority. |
| Software and costs | Check which version of Excel or alternative you use, and test it with one of your own sample files. | When I don’t want to choose extra software before finding out what my current programme can do, I check the available features first; around 13% of consumers prioritise software suitability and cost. |
| Data protection | Establish whether files contain personal data and what security measures and recoverable backups are appropriate for the way you handle them. | If my index contains information that could identify people, I want to protect it carefully; around 12% of consumers give data protection top priority. |
A repeated exhibition name doesn’t automatically mean it’s the same review. As Microsoft Support explains, Power Query’s comparison depends on the columns you select.
Decide which fields together identify a review, then check the results on a copy before deleting any rows.
If you delete unique index data, it may take time to restore it.
The result can depend on the programme’s features and settings. The method described for unique values in LibreOffice Calc is case-sensitive, while Google Sheets has its own duplicate-handling feature.
Test familiar sample records in the programme you plan to use, including titles that differ only by capitalisation.
Keyboard layouts and other features can vary between configurations. For example, Lenovo lists an English (EU) keyboard for the ThinkPad E14 Gen 7 configuration 21T9001TMH.
Check the full model number and specifications of the configuration you’re considering, especially the screen and keyboard layout.
The ThinkPad E14 Gen 7 is a business Windows laptop with a 14-inch screen, suited to anyone looking for a more compact size.
The 16-inch ProBook 4 G1i is a Windows option for anyone who wants a larger screen at a dedicated workstation.
The ExpertBook B1 B1502CVA-BQ0491X is a business laptop with a QWERTY layout, as specified by ASUS.
The MacBook Air offers a macOS option for anyone who wants to carry out indexing work on a Mac.
The TravelMate P2 range includes business Windows configurations, so check the model number and generation.
This selection includes laptops with a range of screen sizes and configurations for spreadsheet and indexing work. Check each configuration to make sure its software and keyboard layout suit the way you work.
Image unavailable
The 16-inch screen and numeric keypad suit comparing and entering data at a dedicated workstation.
16-inch IPS screen, 1920 × 1200 resolution, 16:10 aspect ratio, 8 GB RAM and 512 GB SSD. Power adapter not included.
Image unavailable
The 14-inch size may suit you if you want to view documents and move between workstations.
14-inch IPS touchscreen with 1920 × 1200 resolution and a 16:10 aspect ratio; the 360-degree hinge supports laptop, tablet, tent and stand modes. International English QWERTY keyboard; a suitable USB-C charger and stylus are not included.
Image unavailable
The 16-inch screen gives you room to view review text and an index side by side.
16-inch WUXGA OLED screen, Snapdragon X processor, 16 GB LPDDR5X and 512 GB SSD.
Image unavailable
The 16-inch screen and numeric keypad may suit data entry at a fixed workstation.
16-inch IPS screen with 1920 × 1200 resolution, i3 1000NG4 processor, 16 GB DDR4 RAM, 1 TB SSD and fingerprint unlocking.
Image unavailable
The 15.6-inch anti-glare screen is worth considering if you want to view documents and an index side by side.
15.6-inch Full HD screen, Intel Core i5-13420H, 16 GB DDR5 memory and 512 GB SSD. The product description lists an English keyboard.
No. First check which columns you’re using to identify a duplicate. Microsoft Support distinguishes between temporarily filtering duplicates and deleting them permanently; Power Query bases its comparison on the columns you select.
Yes. Microsoft Support lists Power Query for Excel on Mac. Make sure the features and data sources you need for your workflow are available in the version of Excel you plan to use.
Start with a copy and check the selected columns before deleting any rows. The Dutch Data Protection Authority gives recoverable backups as an example of a security measure for organisations processing personal data.
When you buy as a consumer, you’re entitled to the statutory guarantee that a product will work properly. For distance sales, a 14-day cooling-off period applies in many cases, according to the Dutch government. Check the terms and any exceptions for the specific purchase. A manufacturer’s warranty is separate from your statutory rights.
That depends on the data and how you process it. Names and other information that can identify someone may count as personal data. According to the Dutch Data Protection Authority, organisations must protect personal data properly. Buying a laptop alone doesn’t determine which measures you need for your data processing.