If two conditions are met, then copy the value.

Hi Smart Team,

I have two sheets A and B, both sheets have similar columns and metrics from two different systems, I want to create a third sheet and collate data as per condition such as if Date=Date and Queue=Queue then copy date for that day. I was able to gather data from System A, from System B, I'm not getting the results.

I have attached the image for reference

2023-05-18 02_54_58-ConsolidatedSheet.xlsx - Excel.png

Find more posts tagged with

Formulas

Accepted answers

All comments

Paul Newcome

Can you show the actual formulas?

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.