Category: Standard functions

Standard functions that comes with Excel, plain single functions

Week number to Month number

ANmar May 11, 2015

Why I ran from =INDIRECT() function

ANmar April 6, 2015

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

ANmar April 6, 2015

Week number to Sunday date – Weeknum reverse

ANmar June 17, 2014

Fx to cut long column into two columns

ANmar March 19, 2012

iframe in Excel (XLiFrame)

ANmar February 19, 2012

State Abbr with Index+Match+Validation

ANmar February 14, 2012

Zipcode-State search

ANmar February 12, 2012

Extract Address into table

ANmar February 10, 2012

Convert 2-column into wide (column-row) table

ANmar February 9, 2012

Multiple Dual-Validations

ANmar February 9, 2012