formule

  1. J

    Move numbers end of the cell in new cel

    Hi, I have a lot of this cells: A1Middelweg 552Torenstraat 39-413Nieuwe Steeg 74Schoutlaan 95Leerdamseweg 22a The numbers in the cell are house numbers. Now I want pick that housenumber and move that to another cell But the house numbers can look as 11-13 or 12b. Exactly i look for a...
  2. J

    Move or Exctract data value after specific word

    Hi, I have a excel file with a lot of this cells: A1renewal store by G. de Vries2build house by R.J.D. van Kampen3draw made trough G. Jonkers4renewal barn by S.D.S. Groot Is there any way to move the data starting with the words by and made trough to another cell. Like: AB1renewal storeby...
  3. C

    Long greater than, less than formula

    Hi All, I need a formula to work out payments based on performance, the challenge I'm facing is that there are various scales of payemnt depantdant on the formula. and I just cannot figure it out. So if A1 is greater than F1 but less than F2, I need it to show a bonus amount in H5. But then it...
  4. H

    Finding the Maximal String, Based on Alphabetic Order

    I have a column with data: AB001 AB002 EF001 EF002 EF003 KE001 KE002 KE003 AB003 The formule which gives me the Maximum String in the Strings starting with EF (the result of my formula => EF003) is: ="EF"&TEXT(MAX((--(LEFT(A1:A9,2)="EF")*(RIGHT(A1:A9,3)))),"000") with Ctl+Shift+Enter NOT just...
  5. A

    Can't find the good Formule

    Hello. I am new to Excel, I am learning it, but I can't do something. So the task is like this: I have to create 1 more collumn in right of "Comitat" named "Ecuson". In that collumn the name from "Nume participant" should be with uppercase(I guess by using function UPPER) but it should have...
  6. T

    Zoeken in een ander werkblad met de gegevens in het eerste blad

    Goeden dag Ik ben niet geheel onbekend met Excel maar loop nu vast met een zoek en vervang formule. ik heb twee werkbladen waarop in om het even welke cell de tekst staat "In gebruik" op werkblad 2 staat in de cell met het zelfde regelnummer "vervangen door" nu zoek ik een formule waarin...
  7. M

    PowerPivt formule inkkoopprijs

    Beste, Ik zoek de voor PowerPivot 2016 een formule/meting waarin ik de inkoopprijs van iets kan berekenen. Welke uit de Fx lijst (formule) moet ik selecteren. De rest komt wel. alvast bedankt! Maikel
  8. G

    tableau récapitulatif par formule complexe

    Bonjour, Hello, Je dois récapituler des présences (sans VBA) pour des personnes présentes à des cours à certaines dates et je ne trouve pas LA bonne formule, j'ai perdu tous mes cheveux :nya: Les explications sont dans la feuille. le tableau est ici...

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