Hi Folks, I wonder if someone can help me.

I am building a spreadsheet that uses a master table of PCs on an
estate that are being upgraded. PCs P4 and above dont need an upgrade,
hence if they are already out there, all they need is our new build
installing.

If it is a P4, we take the old P4 off the estate and replace it with a
new like for like model. When this happens, the one coming off the
estate is reuseable, so what I want to do, is to use a formula that
identifies this PC by model (within a scope of about 10 P4s') in a
particular column, then sorts by Dept no and then it copies that record
to another table such as a buffer stock table that updates dynamically.

I suspect its part of the IF function but beyond me I am afraid.

I am more than happy to send the sheet if anyone needs it, but
essentially its the function or string I need to be honest.

Many thanks

Mike


--
kapiliary
------------------------------------------------------------------------
kapiliary's Profile: http://www.excelforum.com/member.php...o&userid=33424
View this thread: http://www.excelforum.com/showthread...hreadid=532403