Explain Excel Formula

Gerry1995 · 2012-05-01 15:20:30

Hi can anyone explain this formula for me, I use it to extract email addresses from a row in excel (A23:W23) and it works, I'm just not sure how it does. Thanks {=INDEX(A23:w23, 1, MIN(IF(ISERROR(SEARCH("@", A23:W23)), "", COLUMN(A23:W42))))}

01-05-2012 03:20PM

#1

Gerry1995

Registered Users, Registered Users 2 Posts: 224 ✭✭

Join Date: June 2007

Posts: 132

Hi can anyone explain this formula for me, I use it to extract email addresses from a row in excel (A23:W23) and it works, I'm just not sure how it does.
Thanks

{=INDEX(A23:w23, 1, MIN(IF(ISERROR(SEARCH("@, A23:W23)), ", COLUMN(A23:W42))))}

0