Match or Index Question
 

My data table is set-up like this:

DataTable Raw Adjusted Special Total
BOX050 90 96.67 0 96.67
BOX060 167 179.01 0 179.01
BOX234 0 0 0 0
BOX355 104 115.34 0 115.34
BOX549 156 166.01 2 168.01

I am trying to create a table like this and think it is possible with index
and match functions:

New Table Raw Adjusted Special Total
BOX050 90 96.67 0 96.67
BOX355 104 115.34 0 115.34
BOX549 156 166.01 2 168.01
BOX898 No Match No Match No Match No Match


Is it possible ?

Thank you in advance.

Is there any reason why you can't just sort your list?

Insert a "helper" column and extract the 3 digits:

=--RIGHT(A2,3)
And copy down as needed.

Then select the *entire* list, including the inserted "helper" column, and
sort on the helper.
You can then delete the "helper".
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"carl" wrote in message
...
My data table is set-up like this:

DataTable Raw Adjusted Special Total
BOX050 90 96.67 0 96.67
BOX060 167 179.01 0 179.01
BOX234 0 0 0 0
BOX355 104 115.34 0 115.34
BOX549 156 166.01 2 168.01

I am trying to create a table like this and think it is possible with
index
and match functions:

New Table Raw Adjusted Special Total
BOX050 90 96.67 0 96.67
BOX355 104 115.34 0 115.34
BOX549 156 166.01 2 168.01
BOX898 No Match No Match No Match No Match


Is it possible ?

Thank you in advance.

sort does not solve the problem. thank you anyways. need the formula to do
matching of the values.

"RagDyer" wrote:

Is there any reason why you can't just sort your list?

Insert a "helper" column and extract the 3 digits:

=--RIGHT(A2,3)
And copy down as needed.

Then select the *entire* list, including the inserted "helper" column, and
sort on the helper.
You can then delete the "helper".
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"carl" wrote in message
...
My data table is set-up like this:

DataTable Raw Adjusted Special Total
BOX050 90 96.67 0 96.67
BOX060 167 179.01 0 179.01
BOX234 0 0 0 0
BOX355 104 115.34 0 115.34
BOX549 156 166.01 2 168.01

I am trying to create a table like this and think it is possible with
index
and match functions:

New Table Raw Adjusted Special Total
BOX050 90 96.67 0 96.67
BOX355 104 115.34 0 115.34
BOX549 156 166.01 2 168.01
BOX898 No Match No Match No Match No Match


Is it possible ?

Thank you in advance.