# Tagged Questions

52 views

### Define a range based on the result of the INDEX function

In Excel it is possible to write a function looking like that: =SUM(A1:INDEX(...)) Where the end of the range of the data to sum is dynamically defined by the result of the INDEX function. The ...
81 views

### How can I do this in spreadsheets?

Let's say you have a table like this: | A | B | C | ------------------------------------- 1| sex | age | answer q1 | ------------------------------------- 2| ...
90 views

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

I'm trying to forecast increasing vendor costs in a spreadsheet. My sheet looks something like this col | A | B | C | D | E | F vendor | 2013-09 | ...
417 views

### Formula to add X months to a date?

How can I add X months to an existing date in iWork Numbers?
564 views

### Numbers conditional formatting based on a different cell in the same row

I have a Numbers spreadsheet, with "quantity required" and "quantity in stock" columns, then each part is on a row. I'm trying to use conditional formatting to turn a cell yellow when # required = # ...
462 views

### Sum the first N elements in a spreadsheet column

I'm trying to sum the first N elements in a column, where N is a value in another cell. I've come up with this: =sum(B1:indirect(concatenate("B", A10))) Where A10 contains N. But I don't want to ...
816 views

I've always been frustrated when using spreadsheets by the inability to define my own functions when there is no existing function to (cleanly) do what I want. Does any spreadsheet offer this ...
9k views

### Pull row of data from one place in spreadsheet to another

I have a list of names and their assorted properties. I am trying to find a way to quickly move an entire row's worth of data into a different sheet so I can manipulate it. Currently I can ...
7k views

### How to break a spreadsheet containing CSV into multiple columns?

I'm working on preparing data for export, and the client has put all of the data into a spreadsheet. Each field of data should be its own column. The problem is that the client erroneously put ...
159 views

### Make a differentiated barchart using numbers

I have a question about Numbers. I want to make a bar chart that shows the membership of my organisation. I want to divide between unitary organisations and membership organisations, so i want ...
36 views

### Chart from groupings

Given such a spreadsheet: col1 | col2 | col3 -----+------+---- alfa | foo | 10 beta | foo | 20 gamma| bar | 12 delta| bar | 42 I'd like to generate a chart grouping values from col2 and ...