Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Highlight dates dynamically AND
  • Cuts string of list of items Formulas - combined functions
  • Compare2, a tool to compare two sheets using formulas Conditional Formatting
  • Skills Grid Conditional Formatting
  • When Excel tells you to go get some life Excel User tips
  • VLookup Lookup and References
  • Sorting with functions only CHOOSE
  • UDF – Convert Number into text (English and Arabic) User-Defined f(x)s = UDF

iframe in Excel (XLiFrame)

Posted on February 19, 2012 By ANmar No Comments on 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:

=LEFT(ADDRESS(1,$D$6-5+COLUMN(),2),SEARCH("$",ADDRESS(1,$D$6,2))-1)

 

Download spreadsheet
Excel Online version
ADDRESS, COLUMN, Formulas - combined functions, IF, INDIRECT, LEFT, Lookup and References, OFFSET, Standard functions, Texts and Strings

Post navigation

Previous Post: State Abbr with Index+Match+Validation
Next Post: Fx to cut long column into two columns

Related Posts

  • 0% interest promotion Basic Math
  • Get column name (columnname as A,B,C, etc) as input inside cell ADDRESS
  • Progress bar in pure functions CHAR
  • Week number to Month number DATE
  • CONVERT function CONVERT
  • Count Unique COUNTIF

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Recent Posts

  • Calculate above and below me
  • Stale values (Scratched functions)
  • Middle name + 1st name
  • LastSunday, LastSaturday
  • Paste Special Percentage

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 (83)
    • 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 (31)
      • AND (5)
      • IF (25)
      • IFERROR (7)
      • 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 (6)
      • Average (1)
      • 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
  • Count how many times letter found Formulas - combined functions
  • Comments versus Notes Excel User tips
  • Excel keeps converting all cells to “Date” (or Time) Excel User tips
  • Get column name (columnname as A,B,C, etc) as input inside cell ADDRESS
  • Convert cell into textbox Excel User tips
  • Tally chart in functions Formulas - combined functions
  • Insert Blank rows into table using functions CHAR
  • Excel sessions – 2013 VS 2010 Excel User tips

Copyright © 2026 Excel Functions.

Powered by PressBook News Dark theme