Usage of Percent Sign %

Percent sign are used for different purposes.

Excel VBA - Find the last row

In Excel VBA, we need to find out last row number (how many rows / data tables's rows count) to scroll down or other operations.

For example start from B2 to the last row in B column.

Sheets("FC").Range("b2").End(xlDown).Row

or

Sheets(1).Range("b2").End(xlDown).Row

Example: Read all row in the column and add to combo box.

For line= 2 To wb1.Sheets(1).Range("b2").End(xlDown).Row

ThisWorkbook.Sheets("Sheet1").ComboBox1.AddItem wb1.Sheets(1).Cells(satir, 2).Value

Next

Using Excel Functions Together

Which function can be used together? And which of these combinations offers strong solutions?

VLOOKUP and MATCH

IFERROR and VLOOKUP

INDEX and MATCH

SUMIF and INDEX and MATCH

LEFT and FIND

RIGHT and FIND

MID and FIND

IF and AND / OR

We can see MATCH function too many. Because it produces the number of item in a list or column. So this number used in VLOOKUP as a third parametet (column number). 

for more explanation: 

www.excelci.com

Excel - quick access tollbars best usages - mostly used icons

Count Number of Errors

Making too much calculation cause some Excel errors. So you can count these errors on your table.

=SUM(--ISERR(D2:D10))

Also number of lines that includes no error.

=SUM(--NOT(ISERR(D2:D10)))

Typical screenshot:

Excel 2016 - Office 2016 - Excel 2016 versiyon is coming

´Excel Power Query

´New forecast functions

´Pivot table, something new in slicers

´Pivot charts, time gruping

´PowerView for OLAP connections 

´Data model, PivotTable, use relationships automatically

´New BI functions and capabilities

´Excel data cards 

´……

VLOOKUP function - 15 different usage scenarios

VLOOKUP function is one of the most powerfull function in Excel.

We can explain 15 different usage for you. 

1. Exact match (typical scenario). 

2. Close match (for numbers)

3. Wildcard characters  (* and ?)

4. With error control (iferror). 

5. With error control (if  iserror)

6. Compare two lists

7. With MATHC function. Two dimensional.

8. With ROW function. 

9. Winth COLUNN function. 

10. With IF function. 

11. With LOOKUP function. 

12. With CHOOSE function. 

13. Winth SUM function. And Array usage.

14. With INDIRECT function. 

15. Other usages.