Notebooks always take precedence. Extra desktops are the only type of machines that will be going into storage.
Notebooks always take precedence. Extra desktops are the only type of machines that will be going into storage.
Last edited by Harlemite; 09-11-2019 at 08:10 PM. Reason: Added attachment and clarification
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.
That is because the 'paperclip' icon has not worked for some time.
Follow instead the steps 63fd posted in #2.
Dave
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
From post #4: "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."
Please show us the formula as we may be able to modify it instead of starting from scratch.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks