alice

  1. Sean15

    How to fix formula returning "FALSE"

    Hi: In column I, for example, All values for "Alice" needs to be summed or grouped together to the first occurring "Alice". All duplicates of "Alice" need to show 0 but formula is returning "FALSE" Could you fix formula please? Excel...
  2. M

    Extract Unique Values from a Range of cells

    I've seen formulas that can extract unique values from a row or column, like {=IFERROR(INDEX($B$3:$B$15, MATCH(0,COUNTIF($D$2:D2, $B$3:$B$15), 0)),"")} but I can't make this work for a range of cells, like this: <tbody> A B C D E F G H I J K L M N 1 Bob Alice David 2 Mark Alice...
  3. C

    Sort dropdowns aphabetically

    Hi, I have a 100 dropdown lists in column A (each with it's own OFFSET's). Is there a way to sort my Dropdowns based on its value? I.e. Dropdown in A1 has John;A2 has Alice. How can I sort these alphabetically, where dropdown will swap places obviously? Currently I can't do it, assuming...
  4. Y

    find last cell contain specific text

    Hello Everyone, so i have in my sheet a row with dates and another row with names, the names are shown several times in different dates, I want to show in other place in the sheet (a few rows under..) the name and next to every name the last date it was written so for example if Jim was...

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
Top