Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Rotate table using 1 formula ADDRESS
  • Sorting with functions only CHOOSE
  • Multiple-Validations (connected to each other) Data Validation
  • Schedule column Basic Math
  • Walking Columns ActiveX controls
  • Hyperlink usage and HyperlinkOf UDF CELL
  • MATCH fumction, just a simple search Lookup and References
  • FORMULATEXT to show formulas FORMULATEXT

Category: REPT

Fixed length ID

Posted on January 22, 2019 By ANmar
Fixed length ID

I needed few months back to make a fixed-length ID iut if none-fixed-length numbers.

SO I used the function REPT with RIGHT to force all numbers to be converted into fixed-length ID (mainly having leading zeros)

And here is the formula

Read More “Fixed length ID” »

Formulas - combined functions, REPT, RIGHT, Texts and Strings

Progress bar in pure functions

Posted on January 29, 2012 By ANmar No Comments on Progress bar in pure functions
Progress bar in pure functions

This one is very similar to Tally chart, however, it is for another purpose. It is used to draw a progress bar, yes a progress bar in pure functions, using the formula: =REPT( CHAR( 8),INT( D2/10))&REPT( CHAR( 7),INT( D3/10)-INT( D2/10))

CHAR, Formulas - combined functions, INT, REPT, Standard functions, Texts and Strings

Tally chart in functions

Posted on January 26, 2012 By ANmar No Comments on Tally chart in functions
Tally chart in functions

Using a single function can make a graphical view to your number Function is REPT along with IF and INT to show that number in graphical view, formula used here is: =IF(B4<5,REPT(“|”,B4),REPT(REPT(“|”,5)&”-“,INT(B4/5))&REPT(“|”,B4-INT(B4/5)*5))

Formulas - combined functions, IF, INT, Logical, Math and Trig, REPT, Standard functions, Texts and Strings

Recent Posts

  • Stale values (Scratched functions)
  • Middle name + 1st name
  • LastSunday, LastSaturday
  • Paste Special Percentage
  • Jan8 date format

Archives

Categories

  • Array formula (1)
  • Formulas – combined functions (58)
  • Google Sheets (2)
  • Non-functions (36)
    • ActiveX controls (2)
    • Conditional Formatting (7)
    • Data Validation (7)
    • Excel User tips (19)
    • Format Cells (6)
    • Graphics (4)
    • Names (3)
  • Standard functions (82)
    • Basic Math (18)
    • Date and Time (16)
      • DATE (9)
      • Hour (1)
      • MONTH (7)
      • NETWORKDAYS (2)
      • TODAY (7)
      • WEEKDAY (8)
      • WEEKNUM (1)
      • YEAR (8)
    • Engineering (1)
      • CONVERT (1)
    • Information (6)
      • CELL (4)
      • ISERROR (1)
      • N (1)
    • Logical (30)
      • AND (5)
      • IF (24)
      • IFERROR (6)
      • IFNA (1)
      • IFS (1)
      • ISERROR (1)
      • OR (2)
    • Lookup and References (36)
      • ADDRESS (4)
      • CHOOSE (3)
      • COLUMN (7)
      • FORMULATEXT (1)
      • HLOOKUP (1)
      • HYPERLINK (2)
      • INDEX (5)
      • INDIRECT (6)
      • MATCH (12)
      • OFFSET (15)
      • ROW (11)
      • VLOOKUP (5)
    • Math and Trig (24)
      • ABS (1)
      • CEILING (1)
      • COUNT (1)
      • COUNTA (4)
      • INT (9)
      • LARGE (2)
      • MAX (1)
      • Min (2)
      • SMALL (3)
      • SUM (3)
      • SUMIF (1)
      • SUMIFS (2)
      • SUMPRODUCT (1)
    • Statistical (5)
      • COUNTIF (4)
      • COUNTIFS (1)
    • Texts and Strings (24)
      • CHAR (5)
      • CONCATINATE (1)
      • FIND (1)
      • LEFT (8)
      • Len (4)
      • MID (9)
      • REPT (3)
      • RIGHT (2)
      • SEARCH (9)
      • STRING (1)
      • SUBSTITUTE (2)
      • TEXT (4)
      • TRIM (2)
      • VALUE (2)
  • Uncategorized (2)
  • User-Defined f(x)s = UDF (3)
    • HyperlinkOf (1)
  • Worksheet (16)
  • XLfxs (2)

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
  • Extract current (Active) workbook name CELL
  • Hyperlink usage and HyperlinkOf UDF CELL
  • Sheet() and Sheets() Lookup and References
  • Excel sessions – 2013 VS 2010 Excel User tips
  • Links between two workbooks – dynamically using functions INDIRECT
  • Zipcode-State search Formulas - combined functions
  • Searching table in 2 dimensions. Formulas - combined functions
  • OFFSET+MATCH Formulas - combined functions

Copyright © 2025 Excel Functions.

Powered by PressBook News Dark theme