Search:

Type: Posts; User: marious; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.02 seconds.

  1. Replies
    13
    Views
    656

    Re: Months on Hand Inventory

    Sorry about that <e6, <e6="" ,<e6,<e6,<e6,"="">=IF(SUM(E5:M5) < E6 ,"> 9 mths",FALSE)

    </e6,>
  2. Re: Match 3 Values & CONCATENATE custom text + Cell Reference

    It doesn't consider the option of more than one order in the same day but most of the work is done with the array in col I
  3. Re: Match 3 Values & CONCATENATE custom text + Cell Reference

    <colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col></colgroup><thead>

    A
    B
    C
    D
    E
    F
    G
    H
  4. Replies
    13
    Views
    656

    Re: Months on Hand Inventory

    <colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>

    A
    B
    C
    D
    E
    F
    G
    H
  5. Replies
    2
    Views
    799

    Re: Data Mining Software for use with excel

    It depends on what you are trying to do.
    R is my personal preference for large data sets (over 104,576 rows) and engineer calculations.
    You need to sharp your statistics skills if you want to use R.
  6. Re: Count based on one column being blank and one being not blank

    sorry about that this one will work =SUMPRODUCT((A2:A5<>"")*(B2:B5=""))
  7. Re: Count based on one column being blank and one being not blank

    =countblank(b1:5)
  8. Thread: goto

    by marious
    Replies
    2
    Views
    7,095

    Re: goto

    F5
    Are you looking for the shortcut F5 for goto?
    I think you should post this question in the general forum
  9. Re: Storm.ExcelMacros Suspicious unknown excel Add-in found

    False alarm. Michael, thank you for your help, but I don't have any virus or there is a problem with the add-in. It is a legitimate and perfectly working add-in from a mayor vendor.
    Moderator...
  10. Storm.ExcelMacros Suspicious unknown excel Add-in found

    Storm.ExcelMacros Suspicious unknown excel Add-in found
    Last week running a macro that normally takes 1 min, excel became trapped in a loop “round blue circle still showing in the screen and...
  11. Replies
    14
    Views
    27,390

    Re: Formula en celda del RUT Chileno

    Juanpi no ve la foto. Puedes descargar este Add-in software en tu ordenador?



    Excel Jeanie Html

    Jeanie es un software q convierte la informacion de las celdas seleccionadas en tu hoja de...
  12. Replies
    14
    Views
    27,390

    Re: Formula en celda del RUT Chileno

    <html><head><title>Excel Jeanie HTML</title></head>******>
    <!-- ######### Start Created Html Code To Copy ########## -->
    <b>Sheet1</b><br /><br /><table border="1" cellspacing="0"...
  13. Replies
    14
    Views
    27,390

    Re: Formula en celda del RUT Chileno

    Please credit Mr. Shg, he is the master of this one. I am just here as translator and trying to validate his formula.

    Mr Shg your formula works let me know if I can help you translating but...
  14. Re: Compair two sheets and line-up data - VLOOKUP( But not sure)

    <html><head><title>Excel Jeanie HTML</title></head>******>
    <!-- ######### Start Created Html Code To Copy ########## -->
    <b>Sheet2</b><br /><br /><table border="1" cellspacing="0"...
  15. Replies
    10
    Views
    349

    Re: Any order searches in Excel

    You can use the advanced filter Filter by using advanced criteria - Excel
  16. Replies
    4
    Views
    230

    Re: profit and loss

    <html><head><title>Excel Jeanie HTML</title></head>******>
    <!-- ######### Start Created Html Code To Copy ########## -->
    <b>Sheet1</b><br /><br /><table border="1" cellspacing="0"...
  17. Re: La ruta en la formula cambia segun computadora que abra el libro compartido en red

    Lo unico q se me ocurre es que pruebes a referenciar los links como si estuviesen en un disco duro externo. Sigue este link y dime se ti sirve de ayuda HYPERLINK function - Excel

    Jump to a...
  18. Replies
    1
    Views
    933

    Re: Búsqueda y copiar valores de filas

    <title>Excel Jeanie HTML</title>
    <!-- ######### Start Created Html Code To Copy ########## -->
    Sheet4


    <tbody>
    *
    A
    B
    C
  19. Re: mostrar duplicados dependiendo de varias condiciones

    Buenos dias.
    1) Copia la lista ( primer Data Set de tu pregunta) y pegalo alternando las columnas en AB
    Columna A = Deco; Columna B = Cod (Es necesario pq la formula VLOOKUP necestia que el campo ...
  20. Re: Unable to Nest IFERROR for Multiple Wildcards Patterns

    Pattern recognition for an engineering data set in which there is more than one occurrence within the long text string for the word “WEIGHT” and we only need to extract data from the second...
  21. Re: Unable to Nest IFERROR for Multiple Wildcards Patterns

    Formula is in E2<html><head><title>Excel Jeanie HTML</title></head>******>
    <!-- ######### Start Created Html Code To Copy ########## -->
    <b>Sheet1</b><br /><br /><table border="1"...
  22. Re: seeking a formula instead of having to use goal seek

    Validation for your post with an initial raise of $400

    <html><head><title>Excel Jeanie HTML</title></head>******>
    <!-- ######### Start Created Html Code To Copy ########## -->
    ...
  23. Re: seeking a formula instead of having to use goal seek

    Raise Salary
    Notes:
    I built a series of formulas and I used Name Manager, so it is easy to visualize and validate. There are different IF scenarios that will affect your solution I5, I6, I7 and I...
  24. Replies
    1
    Views
    139

    Re: Help with complicated pivot chart

    You are already in the best place to learn excel.
    My favorite place is Mr. Michael Girvins’ channel in youtbue “excelisfun”
    Go to YouTube and use the excelisfun keyword and your topic and watch...
  25. Replies
    1
    Views
    345

    Re: Returning Grade based on Class Code

    Use helper columns. I build one for you. Modify ranges accordingly for the rest of the columns.


    <html><head><title>Excel Jeanie HTML</title></head>******>
    <!-- ######### Start Created Html...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4