Archive for Split values
This workbook lets you split expenses evenly with other people. Type name, expense and amount in the excel table on […]
Sam asks: S/N RailCorp Ref Number Date In 77203 HRC mod program 10377 24/05/2011 77204 HRC mod program 10285 20/04/2011 […]
Categorize data entry values [VBA]
In a previous post I described how to simplifiy data entry. Now it is time to put values in separate […]
Text to columns: Split words in a cell [Array formula]
This blog article describes how to split strings in a cell with space as a delimiting character, like Text to […]
Split words in a cell range into a cell each [UDF]
This post describes how to split words in a cell range into a cell each using a custom function. I […]
Categorize values into multiple columns (excel formulas)
In a previous post I created unqiue distinct column headers (A20:C20) and then categorized adjacent cell values into each column […]
Categorize values into multiple columns [VBA]
I am fairly new to vba and I am amazed of how much you can automate in excel. In this […]
Split data across multiple sheets [VBA]
In this post I am going to show how to create a new sheet for each airplane using vba. The […]
Split values equally into groups
Question: How do I divide values equally into groups (3 lists or less)? This post shows you two different approaches, […]
Sort cell values into categories
Here are the prerequisites. Column A contains dates, column B are categories and column C are values. The goal with […]
Excel: Using lookup to categorize numbers
Problem: Values between 0 and 4 returns Small. Values between 5 and 9 returns Medium. Values between 10 and 15 […]
