←Back to Beyond Market Intelligence
•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Matching Numeric Data across two columns?

Our take

Are you struggling to match numeric data across two columns in your spreadsheet? You're not alone. Many users find this task more complex than anticipated, especially when dealing with differing row amounts and the need to align additional information. If you’re using version 16.108.2 and have already tried XLOOKUP without success, it’s time to seek help. In this guide, we’ll provide a step-by-step approach to effectively identify matching numbers and align your data seamlessly. Let’s simplify this process together.

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]

Read on the original site

Open the publisher's page for the full experience

View original article →

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#AI formula generation techniques#Excel compatibility#google sheets#row zero#formula generator#Excel alternatives#numeric data