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? <b>Excel 2010</b><table cellpadding="2.5px" rules="all"...
  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...

Some videos you may like

This Week's Hot Topics