Search results 62

Sorted from new to old.

Works the same as it's VB IIF equivalent. IIf will coerce an expression into ...

2018Jul7

Removes [Enter]s from imported csv file into Excel worksheet. Smart enough to ...

2018Jul7

Import the CSV file, DOES NOT OPEN, Open does not fix encoding issue, import ...

2018Jul7

Allow only Currency into textbox, text box will allow only nnnn.nn where n=1 ...

2018Jun27

Get total number of rows for a certain worksheet in certain workbook workbook ...

2018Jun22

Searches for an item in a column, then if found, delete that cell (not clear, ...

2018Jun17

Matching 4 values at the same time in 4 columns Just like Match the function, ...

2018Jun16

Matching three values at the same time in three columns Just like Match the ...

2018Jun16

Matching by two values at the same time in two columns Just like Match the ...

2018Jun16

Horizontal match for a value in a row Horizontal MatchIf, returns column ...

2018Jun16

The best Match I created, return 0 if not found, kind of CountIF+Match ...

2018Jun16

Cuts a string from certain char till certain char, can be used to cut left, ...

2018May29

Counts how many cells in a column in any sheet, any workbook using COUNTIF ...

2018May23

Reading and saving 2 dim data into ANStrArray ANStrArray is a string ...

2018Apr15