dublicates

  1. K

    How to sum values in one column excluding cells with duplicate text values in two different columns?

    Hello, forum! I'm new here. I have the following basic problem. In this table I have three variables: I am using the SUMPRODUCT formula to calculate the sum of all numbers in column C that have a particular index in column A. For example, C13 =SUMPRODUCT(($A1:$A7="A")*(C1:C7)) I would like...
  2. S

    LARGE MATCH and INDEX formulas with dublicates

    Hello, I have big problem. I want to make a 1,2,3 biggest numbers but there is two simillar so exel write two same words, how should I write the formula? =INDEX(A4:A16;MATCH(LARGE(H6:H16;{1;2;3}); H4:H16; 0)) How should I correct this formula? If it need, i can add the photo. P.S. sorry for...
  3. P

    Find dublicates, mark the rows with a color

    <code style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier...
  4. T

    Conditinal Sorting

    Hi everyone, In colomn A, I have Data like This: <colgroup><col></colgroup><tbody> TİP-1 TİP-2 TİP-5 TİP-5 TİP-5 TİP-9 TİP-9 TİP-10 </tbody> As you see some are listed twice and some are three times... I want to sort them in Colomn B with increment but if data repeats in...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top