Question: why is the vlookup function used more often?
Answer: Why is the VLOOKUP function used more often than other lookup functions? The DCOUNT Function can count either numeric fields or text fields. If the table column you choose to sort contains numeric data, the Sort & Filter menu shows the Sort Smallest to Largest and Sort Largest to Smallest commands.