Forum Discussion
Find Max value in Alphanumeric that has multiple numbers
Hi,
You could try and follow the excel power query guide here Extract Largest Number (Power Query & Flash Fill solutions) and see if it gives you the result you need.
Create custom columns in power query and follow the steps in the post or you could use the code below perhaps
List.Max( List.Transform( Text.Split( Text.Combine( List.Transform( Text.ToList([#"B-Tier"]),each if Value.FromText( _ ) is text then " " else _ ))," "),each Value.FromText(_)*1))
Hi,
You could try and follow the excel power query guide here Extract Largest Number (Power Query & Flash Fill solutions) and see if it gives you the result you need.
Create custom columns in power query and follow the steps in the post or you could use the code below perhaps
List.Max(
List.Transform(
Text.Split(
Text.Combine(
List.Transform(
Text.ToList([#"B-Tier"]),each if Value.FromText( _ ) is text then " " else _ ))," "),each Value.FromText(_)*1))
You are a god-send my friend.
Been trying so many different things but to no avail.
Still fairly new to all this as well, but I'm the only one in our department that has any sort of experience with it so it all falls to me.
Thank you very much.
Saved me loads of time and horrible workarounds.