Re: $$Excel-Macros$$ Excel function for TC_Name with Priority.

Hi, please use below formula =IF(IFERROR(SEARCH("_H_",A2),0)>0,"High",IF(IFERROR(SEARCH("_M",A2),0),"Medium","Low"))  or attached file On Saturday, December 12, 2015 5:08 AM, Sairam Prasath wrote: Hi All,I need the excel formula for the following. | TC_Name |

$$Excel-Macros$$ Calling a Pascall DLL from a VBA project

Hello all, I want to use a DLL writen in Pascal to provide functions for a Excel VBA code: The example code of my DLL is: library CE; {$mode objfpc} uses Sysutils; function level(x1, x2: integer): integer; cdecl; export; begin result := x1 + 2*x2; end; exports level name 'level'; end. In

Re: $$Excel-Macros$$ Calling a Pascall DLL from a VBA project

One additional explanation. This is an example code. It's possible and trully simpler to write this example in only in VBA. What I really want is to understand how to use functions from a DLL. I read something on the web, but it's not enough to solve the bug presented here. 2015-12-12 7:44

$$Excel-Macros$$ Excel function for TC_Name with Priority.

Hi All, I need the excel formula for the following. *TC_Name* *Priority* TC_H_001 High TC_M_001 Medium TC_L_001 Low The above are the columns that I am maintaining. In the column name TC_Name, if there is a character “_H_” then in Priority it should be updated as “High” and if the

RE: $$Excel-Macros$$ Excel function for TC_Name with Priority.

PFA ! METABRAS Mihai Ghilea | Administrator retea T: +4(0) 268.407.410 | F: 0268.407.426 | M: 0728.994.113 A: Strada Grivitei A44, Cod postal RO500182 E: mihai.ghi...@metabras.ro W: 3W.METABRAS.RO