Get instant live Excel expert help with MATCH Functions

I need to compare 2 separate columns of email addresses, and find how many emails are in common

Is there a way to compare all rows to each other? I have a large 3000 row spreadsheet, and on one column, I would like to compare row 1 vs 2, 1 vs 3, 1 vs 4, 1 vs 5, 1 vs 6.....2999 vs 3000. I know, that's 5 million combinations. I will be dividing the smaller number into the larger number, to get a percentage/correlation.

I am trying to compare columns/ Column A has 22701 line items and another column B has 5000 line items.Both column A and B have similar quantities. I want to sort the data in a specific way in column C (blank column) where it returns the search value of column A against its original location.

compare 2 columns of dates A and B. I want to show TRUE in column C if the dates are within 90 days of each other

I need a formula to compare three different cells on one sheet for the month of July, against three different cells for the prior month, to spot change

I need to compare data in three different cells to the prior month. Object is to find a change from prior month to current month data

I need to compare data from 2 separate columns and get the number of cells that are in common

I have two excel sheets. Those are price lists from april and june. Each of them contains about 12k of products with different prices. In those two files the products are not in the same order. The only exact identificator of the product is a SAP code. I would like to compare the price difference in % of each product from those two files. The prices that we want to compare are in COLUMN I

I am trying to create a bar chart or histogram where the x-axis is dollar amounts from 0-600,000 and the y-axis from 0-40 and compare one year's data to another visually. Is there any way for me to do that?

I am looking to see how I can compare a merchant number with a date. I want to find out if for a unique merchant number with multiple records if the date is common?