I’m using Array Formulas to find the last filled or the last non empty cell ,it’s the same :). Important: Each formula must be confirmed by Ctrl+Shift+Enter (not just Enter). Continue reading “Value of the last filled cell in a column or in a row” »
Combo Box is one of the ways to create drop down menu in Excel. More about drop down menus is on https://excel-example.com/other-tutorial/how-to-create-drop-down-menu-in-excel-worksheet.
In this example we create a simple Order Form that calculates final prize. Combo boxes will be used for choosing goods. Here is simple list that will be source for Order Form.
Continue reading “How to use Combo Box (Form Control)” »
In some cases it is useful to know the address of the first empty cell in a row. This is a way to do this without macros. Write the following formula and press CTRL+SHIFT+ENTER. Excel adds braces { } and saves it as array formula.
=ADDRESS(row number,COLUMN(INDEX(firstCell:lastCell,1,MATCH(TRUE,LEN(firstCell:lastCell)=0,0)))) Continue reading “Address of the first empty cell in a row” »
In some cases it is useful to know the address of the first empty cell in a column. This is a way to do this without macros. Write the following formula and press CTRL+SHIFT+ENTER. Excel adds braces { } and saves it as array formula.
=ADDRESS(ROW(INDEX(firstCell:lastCell, MATCH(TRUE,LEN(firstCell:lastCell)=0,0),1)),column number)
Continue reading “Address of the first empty cell in a column” »
Copyright © All Rights Reserved · Green Hope Theme by Sivan & schiy · Proudly powered by WordPress
