karen

  1. CyrusTheVirus

    I'll admit it... I'm stumped!! Need hierarchy help.

    This is the first time in my professional career that I am unable to figure out how to use features/formulas (i've never needed VBA, until maybe now) in order to solve a problem. Basically i need to create a certain formatted hierarchical structure based on the below table. I need each...
  2. N

    Remove numbers after a string of text

    Looking for a formula to remove numbers listed after a name. Ex <colgroup><col></colgroup><tbody> Aagard, Erik 0009515 Abala, Judy 0010752 Abbey, Denis 0016052 Abbuhl, Karen 0006640 Abdelnour, Medhat 0013276 Thank you </tbody>
  3. 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...
  4. K

    Formula Problems-Zero Results Need to be Blank & Calculation Needs to Pickup from Previous Amount Greater Than Zero

    Hello, I'm a beginner when it comes to formulas and this particular spreadsheet is giving me 2 issues. The zero amounts in the 2nd column need to be blank. I got the first one to work but that's it. Then I have a problem where the 859910 is the second column shows up. It needs to be the...

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