Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Min Max vehicle Formulas - combined functions
  • Get column name (columnname as A,B,C, etc) as input inside cell ADDRESS
  • Links between two workbooks – dynamically using functions INDIRECT
  • Shades of gray Graphics
  • Dynamic selection list ActiveX controls
  • Multiple Dual-Validations COUNTA
  • Why I ran from =INDIRECT() function Formulas - combined functions
  • MID + SEARCH to convert cell to rows MID

Category: ADDRESS

Search across sheets in function

Posted on July 22, 2022 By ANmar
Search across sheets in function

Just when you need to search for a thing across sheets in a workbook.

I am bored, so I am adding articles from my old archive.

Read More “Search across sheets in function” »

ADDRESS, COUNTIF, Formulas - combined functions, INDIRECT, Lookup and References, OFFSET, Standard functions, Statistical

Get column name (columnname as A,B,C, etc) as input inside cell

Posted on April 6, 2015 By ANmar
Get column name (columnname as A,B,C, etc) as input inside cell

Excel already has the formula ROW()
=Row()
Which as we may already know will give us the number of the row we are in, if you add no parameters

4-6-2015 9-25-15 AM

However, the COLUMN() is kind of tricky

Because of the fact that cell addresses (or references) are based on the old style of R1C1

=Column()

Read More “Get column name (columnname as A,B,C, etc) as input inside cell” »

ADDRESS, CHAR, COLUMN, Formulas - combined functions, LEFT, Lookup and References, ROW, SEARCH, Standard functions, Texts and Strings

iframe in Excel (XLiFrame)

Posted on February 19, 2012 By ANmar No Comments on iframe in Excel (XLiFrame)
iframe in Excel (XLiFrame)

This is the iframe in Excel, if you are familiar with the HTML concept of iframe, you will understand this one right away, it is basically the same project as HoScrollArea but with vertical scroll too.

Formulas used to bring actual data is:

=IF(OFFSET(INDIRECT("'"&$F$2&"'!$A$1"),$D7-1,$D$6-6+COLUMN())="","",OFFSET(INDIRECT("'"&$F$2&"'!$A$1"),$D7-1,$D$6-6+COLUMN()))

While formula used to bring header labels:

Read More “iframe in Excel (XLiFrame)” »

ADDRESS, COLUMN, Formulas - combined functions, IF, INDIRECT, LEFT, Lookup and References, OFFSET, Standard functions, Texts and Strings

Rotate table using 1 formula

Posted on February 6, 2012 By ANmar No Comments on Rotate table using 1 formula
Rotate table using 1 formula

Rotating table (Transpose) using functions so that the table is updated once the source table is updated. Also can be used as automatically rotating tables with variable number of rows and columns Sheet name can be used inside formula so that you can have multiple tables from different sheets to be rotate it into one…

Read More “Rotate table using 1 formula” »

ADDRESS, COLUMN, Formulas - combined functions, INDIRECT, Lookup and References, ROW, Standard functions

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
  • SimpleANBox Basic Math
  • Hello world! Uncategorized
  • Cells with additional spaces AND
  • Excel @ before function names in formulas Excel User tips
  • Zipcode-State search Formulas - combined functions
  • Extract current (Active) workbook name CELL
  • Dynamic selection list ActiveX controls
  • UDF – Convert Number into text (English and Arabic) User-Defined f(x)s = UDF

Copyright © 2025 Excel Functions.

Powered by PressBook News Dark theme