•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Cross checking data from two different systems but they export in different formats - how to marry them up?
Our take
Cross-checking data from two different systems can be challenging, especially when they export in varying formats. To effectively reconcile your table, begin by using a partial lookup to match names, even if they are not exact duplicates. This will help you identify corresponding entries across both datasets. Once names are aligned, you can implement formulas to cross-check their associated values, allowing you to isolate any discrepancies. This approach will streamline your data reconciliation process and enhance your overall productivity.
I have a table with two sets of data exported from two different systems that I need to reconcile - names and values. Trouble is they export in different formats so I'm needing partial look-up? The lists are also not exact duplicates so there are names on one that don't appear on the other. Once the names have been matched up I then need to cross check the value to isolate any variances. So two formulas for two columns.
thanks
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Two tables/two workbooks. Matching data in columns to add data to a third.I have two different tables on two workbooks. Table 1, Workbook 1: Column 1 is names, Column 2, initials, Column 3 dates. Table 2, Workbook 2: Column 1 initials, Column 2 dates. There is more data on the tables that isn’t relevant to my question and not all names, initials, and dates are common to both tables. Is there a way to match dates and initials on both tables (Columns 1 and 2) that will add the names to a Column 3 on Table 2, Workbook 2? Right now I’m eyeballing dates and initials and cutting and pasting. submitted by /u/TheCliff977 [link] [comments]
- Matching Numeric Data across two columns?What I thought would be a simple formula has taken me over 2 hours of searching and no results as yet.. So im reaching out for help please. Heres where Im at. - Using 16.108.2 version - I have 2 sets of data of differing row amounts. There is one numeric column in each set that definitely has matching numbers across them. I need to see which numbers are matching and which numbers aren't. - I need to align those 2 columns where the numbers are matching, and also keep all other information aligned across the columns that are alongside the 2 I am matching. I have tried the XLOOKUP formulas that I can see listed when i do a google search, but i cant get it to work, either some information or step is being left out, or I am finding the wrong info on how to do this. Can anyone provide a step by step on this please? submitted by /u/Sentallmentall [link] [comments]
- How to handle data from different sources when columns are in different orders?I regularly get CSV exports from multiple clients. Each client uses their own column order. One puts names in column A and dates in column B, another swaps them. Manually rearranging every time is driving me crazy. What's your go-to method for standardizing columns from different sources? Power Query seems powerful but I'm not sure where to start. I've tried INDEX/MATCH with header lookups, but it gets messy when column names vary slightly. Also open to VBA solutions if they're reusable. Any tips or templates you'd recommend? submitted by /u/biggy_boy17 [link] [comments]
Tagged with
#Excel alternatives for data analysis#generative AI for data analysis#big data management in spreadsheets#conversational data analysis#rows.com#real-time data collaboration#intelligent data visualization#data visualization tools#enterprise data management#big data performance#data analysis tools#data cleaning solutions#natural language processing for spreadsheets#Excel compatibility#financial modeling with spreadsheets#Excel alternatives#data reconciliation#value cross check#names matching#value comparison