Formula Bar errorr message

[ckent89]

Hello,

I am trying to use the formula below to sort through data to total an outstanding number of units. i keep getting a "that function isn't valid" message. What am i doing wrong? please help.


=IFERROR(if(row()<>2,INDEX(arrayformula(filter($I2:$I$2,$C1:$C$2<>"",row($C1:$C$2)=max(if($C1:$C$2=C2,row($C1:$C$2),0)))) ,1),0),0)

Thanks,

Ckent89

[TMS]

arrayformula and filter are Google Sheets functions, not Excel functions.

[ckent89]

ahhhh gotcha. Are there functions in excel that do that same thing that are called something different?

[TMS]

No filter or arrayfunction as such. What you are trying to achieve would typically be done using INDEX, MATCH, SMALL and ROW functions committed as an Array Formula using Ctrl-Shift-Enter.

I would suggest you close this thread and start a new one with your specific requirements.

To your new thread, not this one ...

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.