# Search:

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

Page 1 of 6 1

1. ## Thread: Months on Hand Inventory

by marious
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. ## Thread: Match 3 Values & CONCATENATE custom text + Cell Reference

by marious
Replies
3
Views
202

### 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

by marious
Replies
3
Views
202

A
B
C
D
E
F
G
H

by marious
Replies
13
Views
656

A
B
C
D
E
F
G
H
5. ## Thread: Data Mining Software for use with excel

by marious
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. ## Thread: Count based on one column being blank and one being not blank

by marious
Replies
10
Views
243

### 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. ## Thread: Count based on one column being blank and one being not blank

by marious
Replies
10
Views
243

### Re: Count based on one column being blank and one being not blank

=countblank(b1:5)

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

by marious
Replies
2
Views
2,493

### 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...

by marious
Replies
2
Views
2,493

### 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. ## Thread: Formula en celda del RUT Chileno

by marious
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. ## Thread: Formula en celda del RUT Chileno

by marious
Replies
14
Views
27,390

### Re: Formula en celda del RUT Chileno

<!-- ######### Start Created Html Code To Copy ########## -->
<b>Sheet1</b><br /><br /><table border="1" cellspacing="0"...
13. ## Thread: Formula en celda del RUT Chileno

by marious
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.

14. ## Thread: Compair two sheets and line-up data - VLOOKUP( But not sure)

by marious
Replies
5
Views
260

### Re: Compair two sheets and line-up data - VLOOKUP( But not sure)

<!-- ######### Start Created Html Code To Copy ########## -->
<b>Sheet2</b><br /><br /><table border="1" cellspacing="0"...
15. ## Thread: Any order searches in Excel

by marious
Replies
10
Views
349

### Re: Any order searches in Excel

You can use the advanced filter Filter by using advanced criteria - Excel
16. ## Thread: profit and loss

by marious
Replies
4
Views
230

### Re: profit and loss

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

by marious
Replies
1
Views
4,029

### 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

18. ## Thread: Búsqueda y copiar valores de filas

by marious
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

by marious
Replies
1
Views
1,974

### 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. ## Thread: Unable to Nest IFERROR for Multiple Wildcards Patterns

by marious
Replies
6
Views
635

### 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. ## Thread: Unable to Nest IFERROR for Multiple Wildcards Patterns

by marious
Replies
6
Views
635

### Re: Unable to Nest IFERROR for Multiple Wildcards Patterns

<!-- ######### Start Created Html Code To Copy ########## -->
<b>Sheet1</b><br /><br /><table border="1"...
22. ## Thread: seeking a formula instead of having to use goal seek

by marious
Replies
3
Views
764

### Re: seeking a formula instead of having to use goal seek

Validation for your post with an initial raise of \$400

<!-- ######### Start Created Html Code To Copy ########## -->
...
23. ## Thread: seeking a formula instead of having to use goal seek

by marious
Replies
3
Views
764

### 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. ## Thread: Help with complicated pivot chart

by marious
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...

by marious
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.