function to extract values

**beepetark** · 01-13-2020, 01:53 PM

Hi excel Experts here is the query so i mention desired output in file so please help me thanks in advance

**BMV** · 01-13-2020, 02:08 PM

Please Login or Register  to view this content.

**AlKey** · 01-13-2020, 09:29 PM

Try this one:

Enter formula in E3 and copy down

Formula:

Please Login or Register  to view this content.

**FlameRetired** · 01-13-2020, 10:06 PM

Pffft!!! Forgot to refresh. AlKey beat me to it.

Another way.

Formula:

Please Login or Register  to view this content.

You may have to replace the "," s in my formula with ";" for your regional settings.
Your copy of Excel should correct that in the attached.

Re: function to extract values