January 2023 – XLf(x)s

Walking Columns

ANmar ActiveX controls / Basic Math / COLUMN / Conditional Formatting / Formulas - combined functions / IF / INT / Logical / Lookup and References / Math and Trig / Non-functions / OFFSET / ROW / Standard functions January 14, 2023 January 14, 2023

An easy way to scroll through set of data in a graphic way without graphs. A-pure-formula xlsx workbook. These were done using formulas, conditional formatting, and ActiveX control.

Unix DateTime Number

ANmar Basic Math / DATE / Date and Time / Standard functions DATE / Math January 6, 2023 January 6, 2023

Convert Date/time number from regular number to Unix DateTime Number.