J
Jason Chapman
I often find myself re-running extracts from systems, dumping them into
Excel and then having to do some "excel magic" to slice and dice the
data as users want.
Of course, the information is useful, so they ask for the same thing on
an updated data set. I can teach them certain things, but a lot of
formulas and lookups seem to leave them looking a little blank.
When I get a new data feed, where maybe 0.5% of the data has changed, I
will (to check why the data has changed), arrange the old data in a
block on the left, the new data next to it and put formulas in the 3rd
block.
e.g.
a->z = original data, aa-> az = new data
in Ba -> BZ I will put
a1<>aa1
which gives a true or false, then in one columns I will or that block
and so you end up with a column that tells you when any data has
changed in the row.
It woul dbe much easier if there was a Hash function, then I could
compare the hash rather than each cell.
Any ideas?
TIA
Excel and then having to do some "excel magic" to slice and dice the
data as users want.
Of course, the information is useful, so they ask for the same thing on
an updated data set. I can teach them certain things, but a lot of
formulas and lookups seem to leave them looking a little blank.
When I get a new data feed, where maybe 0.5% of the data has changed, I
will (to check why the data has changed), arrange the old data in a
block on the left, the new data next to it and put formulas in the 3rd
block.
e.g.
a->z = original data, aa-> az = new data
in Ba -> BZ I will put
a1<>aa1
which gives a true or false, then in one columns I will or that block
and so you end up with a column that tells you when any data has
changed in the row.
It woul dbe much easier if there was a Hash function, then I could
compare the hash rather than each cell.
Any ideas?
TIA