Help Pulling data from one column to another
 

Hello!

I hope I can explain this correctly. I have a column with unique
information (customer IDs) and then a column with the number of orders. I
want to create a formula to pull all customer ids into individual cells where
the orders equal 2.

For Instance

3121 1
3231 2
5121 3
5312 2
1321 3
5151 1


Results:
3231
5312

If for example 3121 makes another order and their number changes to 2, I
would like 3121 to be added to the results automatically.

Help Pulling data from one column to another
 

Try this array formula** :

ID = named range refers to customer ID's
Orders = named range refers to customer orders

Assume you enter the formula in cell D2.

=IF(ROWS(D$2:D2)<=COUNTIF(Orders,2),INDEX(ID,SMALL (IF(Orders=2,ROW(ID)-MIN(ROW(ID))+1),ROWS(D$2:D2))),"")

Copy to enough cells that is at least equal to number of 2s in the Oders
range.

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)

--
Biff
Microsoft Excel MVP


"Brent Sweet" wrote in message
...
Hello!

I hope I can explain this correctly. I have a column with unique
information (customer IDs) and then a column with the number of orders. I
want to create a formula to pull all customer ids into individual cells
where
the orders equal 2.

For Instance

3121 1
3231 2
5121 3
5312 2
1321 3
5151 1


Results:
3231
5312

If for example 3121 makes another order and their number changes to 2, I
would like 3121 to be added to the results automatically.