by Ilker | Jul 9, 2018 | Excel Tips & Tricks
Although Excel has a built-in sort feature, there are times you may need to sort data by formula or in a formula. This article shows how to use Excel sort function with SMALL and ROW functions. Syntax =SMALL( column of list, ROW()-ROW(row of list’s title)) Steps...
by Ilker | Apr 16, 2018 | Excel Tips & Tricks
Managing and coming up with strong passwords can be challenging. Let us show you how you can create your own custom password generator in Excel. You can download our sample workbook below. Download Workbook Syntax Random Character Generation =RANDBETWEEN(0,9)...
by Ilker | Apr 9, 2018 | Excel Tips & Tricks
Working with Excel’s coordinate system makes building data models extremely easy. You can retrieve the row index information of a cell using the ROW function and implement in other formulas. Syntax =ROW(cell or range reference you want get its row number) Steps...