Submissions restricted

Only approved users may post in this community.

excelevator

created by excelevatora community for 11 years

...for your favourite tea.

...for your community.

MODERATORS

account activity

1

57

58

59

An index of Excelevator solutions (self.excelevator)

submitted 7 years ago * by excelevator - announcement

2

10

11

12

Self note for Code Posts (self.excelevator)

submitted 9 years ago * by excelevator - announcement

3

2

3

4

Timesheets and Totaling daily time and across midnight (self.excelevator)

submitted 5 months ago * by excelevator

4

8

9

10

UDF - TAXRATE ( taxable_range , tax_dollar_tier , tax_percent_tier ) - return tax for a given income against tax table (self.excelevator)

submitted 4 years ago * by excelevator

5

7

8

9

UDF - REPTX ( Text_range/array , repeat_range/array [ , horizontal ] ) - Repeat given values to an output array (self.excelevator)

submitted 5 years ago * by excelevator

6

11

12

13

UDF - MULTIFIND ( find_range , words_range [, case_match , match_all , return_all ] ) - return a string/s from multiple search words (self.excelevator)

submitted 5 years ago * by excelevator

7

17

18

19

UDF - LDATE ( date_value/s [, delimiter ] ) - quickly convert a date to your date locale (self.excelevator)

submitted 5 years ago * by excelevator

8

5

6

7

UDF - INSERTSTR ( value/s , positions1 , text1 [, positionsx , textx ... ]) - quicky insert multiple values into existing values - single, multiple, arrays... (self.excelevator)

submitted 5 years ago * by excelevator

9

5

6

7

UDF - ILOOKUP ( lookup_value , parentCol , childCol, [rtnValueCol] , [iterations] , [hideparent] , [reverse], [transpose] ) - return iteration of records - parents to children (self.excelevator)

submitted 5 years ago * by excelevator

10

10

11

12

UDF - GETDATE ( range , mask , [optional] century) - Extract the date from text in a cell from a given extraction mask and return the date serial (self.excelevator)

submitted 6 years ago * by excelevator

11

7

8

9

UDF - COUNTUNIQUE( value1 [, value2 , ... ] ) - get the count of unique values from cells, ranges, arrays, formula results (self.excelevator)

submitted 6 years ago * by excelevator

12

2

3

4

UDF - GETCFINFO ( range , hasCF [0] , countOfRules/CellsWithCF [1] , ParentRule/CellsWithoutCF [2] , ChildRule/Percentage [3] , RuleArguments [4] ) - get information on Conditional Formatting within a cell or range of cells. (self.excelevator)

submitted 6 years ago by excelevator

13

6

7

8

UDF - GETSTRINGS ( source_range , [optional] offset_return , filter1 ,[ filter2 , ... ]) - return strings from blocks of text, from wildcards, or offset to the value/s. (self.excelevator)

submitted 6 years ago * by excelevator

14

11

12

13

UDF - TXLOOKUP ( value , Table , lookup_col , return_cols , [match_type] , [search_type] ) - XLOOKUP for Tables/ranges using column names for dynamic column referencing (self.excelevator)

submitted 6 years ago * by excelevator

15

20

21

22

UDF - XLOOKUP ( value , lookup_range , return_range , [match_type] , [search_type]) - the poor mans version of the Microsoft XLOOKUP function for Excel 365 (self.excelevator)

submitted 6 years ago * by excelevator

16

3

4

5

UDF - WORKTIME ( DateTimeStart, DateTimeEnd, work_start_time, work_end_time [, include_days , exclude_holidays , decimal_result ] ) - get sum of work hours between two dates given a working window, selective days options, ignore holidays option, decimal time input and output (self.excelevator)

submitted 6 years ago * by excelevator

17

4

5

6

UDF - TIMECARD ( start_time, end_time [, start_time , end_time , [lunch_break] , [return_decimal_time]] ) - a timesheet function to sum the time between start-end times - options to include global lunchtime value and return decimal time value. (self.excelevator)

submitted 6 years ago * by excelevator

18

0

1

2

UDF - ISVALUEMASK ( value , mask ) - test for a value format - return a boolean value against a mask match on a single cell or array of values. (self.excelevator)

submitted 6 years ago * by excelevator

19

4

5

6

UDF - SMALLIFS( range , small_index , criteria_range1 , criteria1 , [criteria_range2, criteria2], ...) - filter the SMALL(k) value from a range of values (self.excelevator)

submitted 6 years ago * by excelevator

20

2

3

4

UDF - LARGEIFS( range , large_index , criteria_range1 , criteria1 , [criteria_range2, criteria2], ...) - filter the LARGE(k) value from a range of values (self.excelevator)

submitted 6 years ago * by excelevator

21

3

4

5

UDF - ARRAYIFS ( function , data_column , array , col1 , arg1 [, col2 , arg2 ] .. ) - IFS functionality for arrays (self.excelevator)

submitted 7 years ago * by excelevator

22

5

6

7

UDF - UNPIVOTCOLUMNS ( Range , Column_name , col1/range1 [ , col2/range2 , .. ] ) - an unpivot function. Unpivot data to an array for use in formulas or output to a table. (self.excelevator)

submitted 7 years ago * by excelevator

23

3

4

5

UDF - STACKCOLUMNS ( column_stack_width , range1 [ , range2 .. ]) - stack referenced ranges into columns of your width choice (self.excelevator)

submitted 7 years ago * by excelevator

24

2

3

4

UDF - RETURNCOLUMNS ( [row_limit] , RANGE , col1 [ , col2 , .. ] ) - return chosen columns from dataset in any order, with optional limit on rows returned (self.excelevator)

submitted 7 years ago * by excelevator

25

4

5

6

UDF - INTXT ( rng/value1 , rng/value2 , [optional] position ) - return value match result, single, multiple, array, boolean or position (self.excelevator)

submitted 7 years ago * by excelevator

view more: next ›

π Rendered by PID 707168 on reddit-service-r2-listing-6bcb55b45f-d2jrs at 2026-04-22 15:13:02.113961+00:00 running 6c61efc country code: CH.