Looplist – Repeating months using formulas
Using formulas to repeat list, I call it LoopList Used to list Months for several years, in away that with 1 formula, it will loop through all months, then jumps …
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 However, …
Fx to cut long column into two columns
Convert one long column into two This set of formulas will get the items after row 45 (for example) from column A into the column B starting from B1 to …
Extract Address into table
Convert US addresses from cells (one column with 1 line for Name, 1 line for address, one line for City, State and Zip code) into table Now, say you have …
Convert 2-column into wide (column-row) table
This Excel file will convert a table of two columns into a Column-Row table Using functions only and auto-updated once the Main table update In another word, analyze the table …
WorksheetName and WorksheetsNo UDFs
Once you open the sheet and enable macros, you can use function: =WorksheetsNo() To get total number of sheets in that workbook And use function: =WorksheetName(1) To get sheet name …