Roderick_E
Well-known Member
- Joined
- Oct 13, 2007
- Messages
- 2,051
I have a coalesce UDF I use all the time but sometimes I forget to convert to values. Anyone have a formula that will do the same thing so if I leave it as a formula it will not break when I send to outside my Excel app?
P.S. in case someone doesn't know coalesce is usually a sql function that uses the first non-null in a list of strings. In this case, we would want:
=coalesce(cell,cell,cell...) which is how my UDF works. Thanks
P.S. in case someone doesn't know coalesce is usually a sql function that uses the first non-null in a list of strings. In this case, we would want:
=coalesce(cell,cell,cell...) which is how my UDF works. Thanks