使用巨大的电子表格 [英] working with HUGE spreadsheet

问题描述

我在此电子表格中大约有300,000条记录.有几百列！

i have about 300,000 records in this spreadsheet. and there are a couple hundred columns!!

其中一栏是社会保险号，我需要用一些随机标识符替换它.我真的不能做一个vlookup，因为那太费力了，所以我想我要写一个宏

one of the columns is the social security number and i need to replace it with some random identifier. i cant really do a vlookup because that is too taxing so i think i am going to write a macro

任何人都可以向我建议我该怎么做?

can anyone please suggest to me how do i do this?

请注意，社会安全号码出现多次.所以我需要它们正确映射到新的唯一标识符

please note that the social security numbers appear multiplle times. so i need them to map correctly to the new unique identifier

推荐答案

基于当前SSN创建哈希.

Create a hash based on the current SSN.

一个示例是此处使用SHA1哈希.存在许多其他选项，包括创建自己的选项.

An example is here using SHA1 hash. Plenty of other options exist, including creating your own.

这篇关于使用巨大的电子表格的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！