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