QUESTION : Ive got cells with the following data, each ingredient for a recipe is in a new line in […]

# Tag: iwork-numbers

## Formula in Excel or Numbers to generate a series of numbers

QUESTION : In my spreadsheet I have two numbers, start_number and nr_iterations. I’m looking for an formula that returns a […]

## Excel/Spreadsheet – formula for last value in a row?

QUESTION : I’m trying to forecast increasing vendor costs in a spreadsheet. My sheet looks something like this col | […]

## Spreadsheet formula to count consecutive values in a column

QUESTION : I have a column with “Y” and “N” values, and need a formula to count the last consecutive […]

## Numbers/Excel Hour Counter within Specified Date Range

QUESTION : The data shown in the image is just sample information but… I would like to use the “Period […]

## Apple Iwork Numbers: How to conditionally highlight a cell

QUESTION : I am using apple numbers to do some modeling. (For those of you who are not familiar it […]

## In Excel (or Numbers) what formula can calculate the amount of days in a certain month across 2 dates

QUESTION : If a guest arrived on 24th of August and left on 4th of September what is the formula(s) […]

## Extended Subtraction Between Columns on same row in area

QUESTION : I want to calculate the transaction value so by that i mean i’ve got different accounts in column […]

## How can I create small random groups containing one unit each from five sets of data?

QUESTION : I have five sets of data. I want to create small random groups containing one unit each from […]

## Aligning split columns in a spreadsheet

QUESTION : I’m using Numbers, but I think excel users would also know the answer here. All I want to […]

- 1
- 2