[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 219
  • Last Modified:

Match Formula?

Hi,

I have attached a file where im looking to get data out of ColA.

Id like some Match formula perhaps? I need to get the detail in B,C,D & E out.

Can anyone sugegst anything?

Thanks
Seamus
Example.xls
0
Seamus2626
Asked:
Seamus2626
1 Solution
 
AmickCommented:
I've attached an example solution.
Each line is tested to see if it holds the data we want to pull, if so we extract it.  
Data can be filtered on column B = True and column A&B can be hidden. ExampleSolution.xls
0
 
Seamus2626Author Commented:
Excellent. thank you very much Amick

Cheers,
Seamus
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now