Excel equivalent formula

[Indie2390]

Hi guys,

Does anyone know an equivalent formula in Excel for the following Google Sheet formula:

IF(B3="String",UNIQUE(Range)," "))

I have tried searching online but not been able to find anything that can help me.

I would appreciate anyone who can help!

Thanks! :-))

[hrlngrv]

If you're running Office 365, the same formula works. If you have an older version (which appears to be the case given your profile's version), you lack the UNIQUE function.

There are work-arounds, arguably the simplest would be writing a user-defined function in VBA to sift out only distinct values. If everyone needing to use such formulas uses Windows, you could use the Windows Script Host's Dictionary object for this. Are you allowed to use VBA?

[Indie2390]

Hmmm, I'm not sure if I am allowed to use VBA. I'm trying to create the spreadsheet for my wife on her work computer, so possibly not
Thanks for the advice though. I will find out if I am able to do this and get to it!

[hrlngrv]

If you're not allowed to use VBA, then you'd need to filter out distinct items from Range using formulas like this.

BX1:

Please Login or Register  to view this content.

BX2:

Please Login or Register  to view this content.

Fill BX2 down until it returns error values.