Forum Discussion
How to return next largest observation of text column
Hi, Attached is an example file of the column of data I have (Column B) and hardcoded version of data I want (column C), which is also shown below. If possible, I'd like to do this without an a...
mmrothsc Transformed your example data to an Excel table and connected to it with Power Query (=Get & Transform Data, on the Data ribbon). Select "From Sheet" (or From Table/Range on older Excel versions). PQ is built-in in Excel 2016 and later and available as an add-in for older versions.
With a few clicks on some buttons you can create the table like in Column E. See attached. Something worth exploring/learning if you have not used PQ before. No need for complicated formulae. If you have used PQ before, just follow the Applied Steps that I have used.