Nested IF or Some Other Function ?

Ask a Question

I need to create a chart (straight table) from a dataset similar to attached Excel. Requirement is to pick Client Name (and rest of the row):

if Area Name = Research and Type = Region and Rank value exists then pick that row

else if Area Name = Overall and Type = Region and Rank value exists then pick that row

esle if Area Name = Overall and Type = Overll and Rank vlaue exists then puick that row

if none of the above matches, move to next Client.

Only one row should be picked for any Client.

Any suggestions ?

0 Replies