All articles with 'patterns' Tag

Are you ready for an Excel challenge?

Today, your job is very simple. Just find a pattern in a text and return corresponding value.

Your Homework:

In a range we have some resource types & their billing rates.

In another range, we have some descriptions. Each description contains a resource type somewhere inside it. We need to retrieve billing rate for each description by looking up which resource type is mentioned in it.

See above diagram.

Last week we have been to Pittsburgh to visit a college friend. We had great fun there. It is a neat little town with countless bridges. Pittsburgh was historically known as steel city, but today the glory is all that of technology and education industries there. The above is the building of a steel company […]