LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 43
Default Need help finding unique values and transforming an n x 1 Array

I need to transform a large array into a set of indicies that relate
back to actual values within each
column of the array.

For instance - suppose there was a list of 10,000 values in a column,
but there were only 20 unique values in that 10,000. I could transform
the 10,000 into the 20 if I had a way of finding them. (Or at least
that's the direction I'm headed).

This would require 1) Finding an array of unique values, 2) creating a
second array with similar dimensions (n x m) as an original array that
for each value of m goes through something like the
following:


Original array: n1 x m1 array
Unique values of n1 for each value of m1 in m1 arrays
Transformed array: n2 x m1 where n1 has been replaced by the index of
each unique n1 value within the column m1

All where n1 and m1 represent the size of the array
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
finding unique values waylonk Excel Discussion (Misc queries) 2 May 3rd 10 09:40 PM
Unique values in an array. Jerry Excel Discussion (Misc queries) 2 October 15th 09 06:44 PM
Finding unique values with Criterias dolpphinv4 Excel Discussion (Misc queries) 1 April 14th 05 02:37 AM
Finding Unique Values in Column Kirk P. Excel Discussion (Misc queries) 1 January 25th 05 02:01 PM
Finding Unique Values from Multiple Columns Disco[_3_] Excel Programming 1 October 7th 03 03:20 PM


All times are GMT +1. The time now is 12:54 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"