Creating unqiue list using INDEX(MATCH

System

System Employee

04/19/20 in Formulas and Functions

This discussion was created from comments split from: Generate List of Unique Values - INDEX? DISTINCT? VLOOKUP?.

0 ·

Comments

Venkatramana Reddy Kambalapalli ✭

04/17/20 edited 04/19/20

I am trying to create a unique list by removing duplicates followed Paul's steps.
Following is not returning any value. Please advise what is wrong
=IFERROR(IF(ISNUMBER(RowID@row), INDEX({CIS_SRF_Offshore CustomerName}, MATCH(RowID@row, {CIS_Offshore Helper}, 0))), "")

0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Formula to check a box when specific criteria are met
Hi! I am looking for a formula to check a box when specific criteria are met. I have multiple columns that have dropdown options. I would like the box to check when each of those columns have either "Approved" or "Declined" selected. But if "Submitted" is the option shown, then it should not check the box. So all…
Formula to populate field from another sheet using multiple criteria
Hi there, In one sheet ("pay scale") I have our employee pay scale and in another ("Employee Salary") I have our employees listed with their experience and education levels. Is there a Smartsheet formula that I can use to pull in their salary based on their experience and education levels? For example, if they have a BA +…
Forumla Help: IF Statement with Vlookup Across Sheets
I have created two resourcing documents (pictures below for a visual) Resourcing Sheet - This is the sheet where we resource each project by person Resourcing Rollup- The sheet is rollup to show how many hours the are allocated each week by person and gives a rollup of hours What I am trying to do: Look up (example name)…