Array formula that returns certain text based on the occurrence of values in another colum

Hello and welcome to the forum.

What about "Update and Migrate" and "Trash" in column F?

It helps if you upload an actual Excel workbook rather than just a picture of one. This way we do not have to recreate your data.

I recommend uploading a small representative sample of your data along with the desired results (which you can enter manually) based on that data.

To upload an Excel workbook, follow these steps:
1) Click on "Go Advanced"
2) Click on "Manage Attachments"
3) Click on "Choose File"
4) Choose your file and click on "Open"
5) Click on "Upload"
6) Click on "Close this window"

Also, should notebooks always take precedence over a desktop as shown in rows 10 and 11 in your sample from post #1?

In other words, if a user has both a desktop and a notebook ready, should the desktop always be the one to go into storage?

Hi! Thank you very much for your reply. I really appreciate it. My apologies, I should have known to attach a spreadsheet. I will do so when I get home in a couple of hours as I don’t have access to post externally on my work computer. I had to recreate this sample of the spreadsheet at home just to post it on the forum.

I already have a really complicated nested if formula in Column F for disposition to account for Trash, Update and Migrated and many other categories not reflected in the sample for simplicity, but haven’t been able to figure out how to get storage category.

Yes, notebooks always take precedence. Extra desktops are the only type of machines that will be going into storage.

You can try this in F3:

=IF(SUM(COUNTIFS(B$3:B3,B3,C$3:C3,"Ready",D$3:D3,{"Desktop","Notebook"}))>1,"Storage",IF(AND(C3="Ready",E3="Migrated"),"Migrated",IF(C3="Replace","Trash","Update and Migrate")))

I made a few assumptions.

Edit: Just saw your last post. This formula will need to be reworked.

For some reason, I’m unable to add an attachment. I just get a little white box when I click on the attachment icon and no ability to browse for file.

Ohhhh. Duh. Thank you very much. The spreadsheet sample is now attached.

Here's the spreadsheet snippet.

What is your expected results from your data?

My expected results are in Column F