You stand a much better chance of getting your issue worked on if you can provide a sample workbook.
Often workbooks contain sensitive or proprietary data. We certainly do not want to see this data, but there are tools you can use to obscure the data.
Rule1: First of all, we probably do not need ALL of your records. Anywhere from several dozen to several hundred rows of data will do depending on the nature of the data.
CTRL-H: In my case I work with wireless devices and the failure codes associated with returned models. The vendors would get really pissed off as in big-time litigation should this information become public.
First, I filter down the list of 100 or so models to about 10 (See Rule 1). Then I use CTRL-H to replace Samsung Galaxy with Model 01, and iPhone 7S with Model 02 and so on.
To further obfuscate the data, I will use Fail Code 01 through Fail Code 10 in order for the first 10 models (whatever they are) and then copy/past this block of error codes down for as much data as I have.
This works if you have a fairly fixed set of values.
Drag Down: Sometimes every record is unique. You can alias everything one at a time or you can type in Person 01 in the first row and drag the value down it will become Person 02, Person 03, etc.
This works for Social Security Numbers XXX-XX-0001 or phone numbers XXX-XXX-0001 and just about anything else you can think of.
RANDBETWEEN: Finally if the actual numbers are an issue, you can randomize them. Use RANDBETWEEN to assign values and then Copy the whole range and save as values only.
I sometimes use RANDBETWEEN to assign failure codes.
RANDBETWEEN can also be used with Dates. Base Date + RANDBETWEEN (0,180) will get a list of dates up to 180 days after the base date.
Bookmarks