You can use INDEX and MATCH function together to find a value and return the next value.

Now I want to find “AA” the next value of “Muny”
Select a cell that you want to place a return value
Then type =INDEX(C:C, MATCH(E3, B:B, 0))

Screenshot:


Database design process is a series of instructions detailing the creation of tables, attributes, domains, views, indexes, security constraints, and storage and performance guidelines. In this process, you implement all these design specifications.

The process starts with conceptual design and moves to the logical and physical design stages. At each…


Sometimes the data migrated from legacy system gone wrong with “newline” as in the case

That often brought wrong format in the report
To find those records we could use REGEXP_REPLACE

Query output returns row that has new line

Vaing Muny

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store