multiple factor IF statement based on specific criteria

[JPRICH16]

Hi,

It doesnt have to an "IF" statement is can be anything including a query or table but not a macro

Essentially, on the spreadsheet attached there are 3 rows:

1. the fuction should ONLY affect "Order"'s that are the same (column A)

2. If "order"'s are the same the function will look at "Order type" (column C)

3. Function will ensure "Not assigned" is changed if matching line within the chart is different

I tried "=IF(AND(D3=D2,F2="Not assigned"),"Not assigned",F3)" but it doesnt work

Please see spreadsheet its much easier to understand!

Jeffrey

[FDibbins]

So, if I understand you correctly, you want this formula in col C?
But col C also contains entries?

Also, your formula contains references to col D and F - but they (essentially) contain nothing - did you provide the correct file?

[JPRICH16]

Yes essentially, if column A is matching then column C should match BUT if one is "not assigned" and the other is anything else the "not assigned" will change to the other

[FDibbins]

You can only have either an entry in a cell OR a formula, you cant have both.

[JPRICH16]

It needs to be an IFS with 1 And and 2 OR statments I think that index matches A and C at all times, I just cant do it lol Im not expert enough!

[FDibbins]

If you have entries in C, you cannot also have formulas there

[JPRICH16]

if i do =IF(D6<>D5,G6,IF(AND(D6=D5,F5="Not assigned"),"Not assigned",F5)) and copy C into D so i can have it do nothing if not med, it works but only if the numbers are inorder and always has the change as the first one

[AliGW]

You seem to be ignoring the point made, and that is that you cannot have a formula and text entry in column C - it's one or the other.

[Marvo]

Couldn't this be achieved with a simple AZ Sort?