 Select Page

## Using Vlookup for populating a scientific taxonomy list or channelling my inner Attenborough

I recently got asked to help with setting up a formula that would autofill standard entries for particular species. The idea would be that the user would enter a species name and then the other details would fill in as normal. While the example I’ve given here...

## EXCEL IF OR STATEMENTS

In a previous blog posting, I showed you how to set up an If statement in Excel. In this blog posting, I am going to show you how to nest an OR function into an IF function (the technique can be used equally well with a NOT, AND, TRUE, FALSE functions). Essentially...

## EXCEL MIN FUNCTION – FINDING THE LOWEST VALUE IN A LIST

Excel min In this post we are going to look at the min function (which finds the lowest value in a list)   Please enable JavaScript LinkEmbedCopy and paste this HTML code into your webpage to embed.     As always, here is a file you can practise with ...

## COUNT TEXT IN EXCEL – USING THE COUNTA FUNCTION

Excel count text If we want to count the number of names (or list of entries with mixed text and numbers), the count function will not work – simply because it is designed to count NUMBERS only. In this case we have to use the CountA function. See video below...

## EXCEL COUNT FUNCTION – COUNTING THE NUMBER OF NUMBERS IN A LIST

Excel count function This post will show you how to use the Count function. The count function counts the number of items in a list. Unlike the Sum function (which adds up the numbers), the count function tells you HOW MANY NUMBERS  in a list. If you want to count the...

## AVERAGE FUNCTION IN EXCEL

Average function in Excel (2007/2010)   In this post we are going to look at calculating the average in Excel (using the excel average function)   Please enable JavaScript LinkEmbedCopy and paste this HTML code into your webpage to embed.   As always...