Mathching string of numbers

[tamir]

I know its a long shot but I am hoping maybe there might be a solution for
it. Well, what I am trying to do is to create a template for this data for
different job nunmbers for every two weeks. Data contains numbers of
diferent job numbers and they are quite repetitive. I want to know if there
is any way that I can formulate the whole row commanding too search through
that data and list out all the different job numbers. For example:

The job number column from the data sheet includes:
123, 145, 187, 123, 169, 145, 145, 169, 123, so on and on.
And I want to see if I can forumlate the template asking the pull job
numbers only once.
The final product that I would be getting should be:

123, 145, 169, 187.
Please help,
Sincerly,

TL

 

[Ron Rosenfeld]

I know its a long shot but I am hoping maybe there might be a solution for
it. Well, what I am trying to do is to create a template for this data for
different job nunmbers for every two weeks. Data contains numbers of
diferent job numbers and they are quite repetitive. I want to know if there
is any way that I can formulate the whole row commanding too search through
that data and list out all the different job numbers. For example:

The job number column from the data sheet includes:
123, 145, 187, 123, 169, 145, 145, 169, 123, so on and on.
And I want to see if I can forumlate the template asking the pull job
numbers only once.
The final product that I would be getting should be:

123, 145, 169, 187.
Please help,
Sincerly,

TL

There are multiple solutions, depending on more information.


1. Select a cell in the Job Numbers column
2. Data/Filter/Advanced Filter
Have the range be just the column of Job Numbers
3. Select either Filter in Place or Copy to another Location, as appropriate
4. Select "Unique Records Only"
5. Enter a cell in the copy to: box if appropriate.

Voila!


--ron