# Archive by month August

## Excel searching and formulas

Ok, so I’ve got a spreadsheet with a list of pipe sections with the following properties:column A: diametercolumn B: thicknesscolumn C: section …

## Macro Deleting Row at Test Character

I need to know how to have a macro decend down a column until the cursor hits a cell containing a test character and then select the row the test …

## Count Excel Cells that Contain Data

To count how many cells contain data in Excel you use the COUNTA Function.  Using the COUNTA Function will only count the cells that are not empty. The syntax …

## random prize generator

I am using excsl 2010 as a tool to pick prize winners based on # of entries.  Some individuals have as many as 600 entries in the contest.  Any ideas …

## Find Highest Number in a Range using Excel’s MAX Function

To quickly find the largest number in a range of cells you can use Microsoft Excel’s MAX Function that will quickly tell you the minimum number from a …

## Auto-Running a VBA Macro Based on the Value Within a Cell

Hi, Apologies if this has been asked before, I’ve not been able to find a similar thread on this topic myself (but if you know of one, please point me in …

## Using Excel’s MIN Function

To quickly find the minimum number in a range of cells you can use Microsoft Excel’s MIN Function that will quickly tell you the minimum number from a …

## Using Excel’s AVERAGE Function in Excel

Microsoft Excel comes with a great function, AVERAGE, that will quickly average a range of cells that you specify. When you average numbers what you are doing …

## Excel drawing shift

I have copied 9 diagrams (as they are similar) to nine different tabs. The drawing (process flow sheet) was very complicated with several formulas within the …

## Adding a column in a IF function

i have an overview page. i need to add an entire column from a differant sheet if it says a certain word. the column will have 4 differant words i need to add …

## How to use SUBTOTAL Function in Excel

Excel’s SUBTOTAL function can dynamically count records in a list that has AutoFilter activated. It can also show you other information about records within …