i need help in creating a formula that would just look at the first column A
and then give me the values in the other columns that i indicate example from
column B and C. In brackets is an example what is in the columns just so you
have an idea. So the problem is since in column A has the same p.o. repeating
for a couple of rows and i want all those rows info from B and C. basically
what i am trying to do is make a invoice and i want to use this sheet below
for it to capture the data by p.o. number. hope i make sense. any help
would be great. thanks
column A column B column C
(eg. p.o.) (eg. qty) (eg. cost)
12234 120 1.00
12234 360 2.00
12234 400 3.20
12234 500 1.00
45454 140 4.00
45454 60 5.00