In B2:B4 I have alphanumerical characters.
In D2:D4 I've done the seperate steps to Substitute those characters to a prefixed numerical value so I can use the Average function in D5.
In E5 the result of D5 is substituted back into alphanumerical value.
The question is can all these seperate steps of D2:D5 & E5 be put into 1 formula in B5 ?
The table in G:H is just to show what the substituting values are and is not to be used in formula (if even possible).
I can easily write a UDF in VBA which takes care of the problem but I'm just wondering if there's a formula solution.
Regards
Rudi
Bookmarks