Get instant live expert help on column vs row

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.

Hi, I have multiple columns with duplicate values. I'm trying to develop a formula that will show me the % of duplicate values against column A. So for example, % of duplicate values of column B vs A, % of duplicate values between column C vs A, etc.

Need a formula to combine the total $ amount pertaining to each row listed in the same category, in a different sheet. For example: Column A - Lists various categories. I need the formula to be = to "Producer Fees" Column F = "Producer Fees" $ amount Every time Column A lists Producer Fees, I need to add the donation amounts (column f) resulting in one total number (see budget vs. actual tab - row 23)

I need to create an excel spreadsheet. Here are the parameters: I have 5 games that can either win or lose. Team 1 Vs. Team 2 Team 3 Vs. Team 4 Team 5 Vs. Team 6 Team 7 Vs. Team 8 Team 9 Vs. Team 10 I need to visually see all the combinations of those games and again the only outcomes are win or lose.

I am trying to combine Conditional Formatting in the tab source worksheet. Basically, if O3 is less then B3 it should be shaded red and if it is higher it should be shaded green (remove all yellow which is same was supposed to be same as previous month). That same formatting would hold true for the rest of column O (O4 vs. B4, O5 vs. B5 down to cell O47 vs B47).