Comparing Two Lists

I have 3 lists that I normally copy into excel columns: #1 Roster names, #2 Split names, and #3 Audit names . I ensure all 3 sheets have the same corresponding names (often times some fall through the cracks and we lose names between each list) In excel I was using the following equation but I want to move it to smartsheets:

=FILTER(Table3[Split ], ISNA(XMATCH(Table3[Split],Table3[Roster],0)))

any ideas? essentially I need a list of the names missing from the roster on the split & the ones missing from the split on the audit (hoping that makes sense)

Find more posts tagged with

Accepted answers

All comments

Ryan Sides

Hi A, I'm not sure if there's a slicker solution for this or not, but if you're wanting to include them in the same sheet, you can use a COUNTIFS function that will count the first list for any instances of the name in the second list. If your count is zero, then you know it's not there. Create multiple count columns for your different scenarios.

Does that so what you were wanting to do?

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.