Christobee wrote...
I get and Error message with both of your formulas for some reason the
formulas contain invalid data
....

Did you enter the *ARRAY* formulas as *ARRAY* formulas, meaning holding
down [Ctrl] and [Shift] keys before pressing [Enter]?