NESTED IF FUNCTION-change order id based on 3 conditions

Hello Everyone,

I am attaching a file from our order entry system. Orders are submitted and they need to be split based on any change is column I. I need to add the A,B or C to make the order unique when column I changes but column A doesn't.

I put a result i am looking for in column F.

Hi, welcome to the forum

1. Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however the thread title does not really convey what your request is about.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

2. Please include a sample file, we dont really want to copy/paste or retype your data
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

Yes, you can post an attachment, but you need to follow the instructions.

Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

Originally Posted by StaceyFCreative

Hello Everyone,

I am attaching a file from our order entry system. Orders are submitted and they need to be split based on any change is column I. I need to add the A,B or C to make the order unique when column I changes but column A doesn't.

I put a result i am looking for in column F.

There is nothing in column I?