den

  1. J

    Index Match help

    Hi! I have a formula (below) that is working when I use the exact term I want to look up (DEN C) but I would like to look up anything that starts with DEN. There should be three possible options, DEN S, DEN C, and DEN F. {=INDEX(E:E,MATCH(1,(Withholdings!A:A=Data!A2)*(Withholdings!F:F="DEN...
  2. P

    Match numbers in a colunm

    Look for all matches in a sorted list. If no exact match is found all the nearest matches. Been looking at lot of examples none I can adapt. Cheers Peter e.g. Col A/Col B Tom 10 Bob 20 Mob 30 Yan 40 Den 40 Elf 50 Len 50 If my target is 40 I should have Ian 40 and den 40 should be listed. If no...
  3. M

    Daten Aufbereitung / Cleanup

    Hallo Zusammen, folgende neue Herausforderung hat sich für mich ergeben: Habe eine Tabelle wie diese(Siehe erstes Bild): Es handelt sich um Etiketten mit verschiedenen Versionen. Ich benötige diese Etiketten untereinander und zwischen den Sorten soll immer ein komplett leeres sein. Wie auf...
  4. P

    convert data from horizontal to vertical

    Could someone please help me with vba coding for the below excel query raw data <colgroup><col width="64" span="6" style="width:48pt"> </colgroup><tbody> name score name score name score zen 32 men 22 ken 58 ran 45 den 23 shen 56 connor...
  5. H

    Choosing A Flight Dashboard - Any ideas?

    Hello all, I am trying to figure out the best way to create a dashboard that will allow me to find the best flights to book. I have the following raw data: <tbody> Airline Flight # Depart Date Depart Airport Depart Time Arrival Airport Arrival Time Price United UA330 09/28 DFW 5:00pm DEN...

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