Questions about spreadsheet software in general and interoperability between spreadsheet programs.

**1**

vote

**0**answers

17 views

### Where does the calculation take place? [closed]

In Google spreadsheets, I have quite a big amount of relatively complex array formulas in many cells. That takes ages to complete calculating.
Does the speed of calculation depend on my PC ...

**0**

votes

**1**answer

27 views

### add prefix to a cell in a spreadsheet

I have a cell in a (google)spreadsheet document (let's say L7) where I usually put a numeric value (like, say: "28", "12", "87"...).
I'm trying to make a formula that adds a letter in front (or ...

**0**

votes

**0**answers

11 views

### How can I Collate and create totals of a range of transactions in iwork Numbers

ColumnA ColumnB
Dave 10
Dave 10
Peter 5
Susan 5
Dave 5
Peter 5
I would like to create new table to read down ColumnA, create a new list with no Duplicates and Total up the Values ...

**1**

vote

**0**answers

18 views

### Google Spreadsheet limit ArrayFormula [migrated]

I'm using ArrayFormula to calculate multiple ranges and its slow because its trying to calculate everything in that range even though it has nothing in it. Is there a way i can limit the ArrayFormula ...

**0**

votes

**1**answer

19 views

### How to return the name of uniquely named sheet

So I've searched high and low and cannot seem to find an answer to this question. Spent almost two days trying every thing I could find on line, but none were specific enough to my situation. Without ...

**0**

votes

**0**answers

17 views

### Update formula ranges when adding new rows to a spreadsheet [migrated]

I have a Google Spreadsheet in which I keep a list of expenses. I add a new expense by inserting a new row above the last expense. On the first row of the spreadsheet, I keep a sum of all expenses: ...

**0**

votes

**1**answer

11 views

### OpenOffice Calc - 11 Pages in spreadsheet, but print interface only shows 2

I am working on a spreadsheet using OpenOffice and need the pages to be printable.
You can print the first two, but thats it. If in the print interface I select all sheets it only shows 1 and 2 with ...

**0**

votes

**2**answers

156 views

### Excel Opening as a blank spreadsheet, but with values

When we open an Excel spreadsheet that is populated it will open with all of the cells appearing blank. However, if you click on any of the cells you can see in the formula bar at the top that they ...

**0**

votes

**2**answers

56 views

### Is there a tool to put a phone number into E.164 format?

I'm looking for both a quick and dirty, as well as easily repeatable, solution to strip non-numeric data from a column in a spreadsheet for import to a MySQL database. Example:
(123)456-7890 fred ...

**0**

votes

**1**answer

46 views

### Excel: Converting two lists into a matrix

I have two lists in my workbook currently
Name | System 1 | System 2 | System 3 |
John | x | x | |
James| | x | x |
Peter| | x | ...

**0**

votes

**0**answers

15 views

### Microsoft Excel 2013 Formatting When Importing Data

I am importing data from Quickbooks into an Excel 2013 spreadsheet and this will take place on a weekly basis with updated information being added to this report. The report is an Open Estimates ...

**0**

votes

**1**answer

25 views

### How to make a custom selection on excel?

Is it possible to make a custom selection on a spreadsheet and in particular on excel ?
If yes, how to do it ?
(for example, I would like to select one cell on 3 among a column
or select only the ...

**0**

votes

**2**answers

41 views

### How to remove rows that match?

I have a csv file with list of people (first name, last name, email) and then later on I will get a list of people in another csv file that unsubscribed ( only one column with email).
Q: How can I ...

**2**

votes

**2**answers

471 views

### How can I combine two lists into one long list?

I have two lists in coloumns 1 and 2. I need coloumn 3 to be of the format one dash two.
For example:
Column C will need to repeat all values of A and B.
I would prefer a formula for this is ...

**0**

votes

**0**answers

20 views

### LibreOffice SpreadSheet Conditionally copy value from one cell into a second cell?

I'd like to have the calculated value of a cell be carried over to another cell if the result is less than a given value.
For instance, cell A2 is defined as =A1*.75
If the result is less than x, I'd ...

**0**

votes

**1**answer

35 views

### Spreadsheet finding and sorting most frequent appearance of names

I have a spreadsheet that looks like the following:
https://docs.google.com/spreadsheets/d/1BN3GNRFCsBeHu9gQaKzIo7bfFRkcDqMJ6VMtidEwPD4/edit?usp=sharing
There is a set list of names in Column A. ...

**0**

votes

**0**answers

19 views

### How do I add a number to an input cell?

The scenario is that cell A1 is an input cell, and I want to add another cell's value to what is entered in the A1 cell.
For example, A1 is the input cell. A2 is the output of some independent ...

**0**

votes

**2**answers

19 views

### Can I have multiple views of spreadsheet data which extract and sort from a larger set?

Supposing I have a spreadsheet (Libreoffice ideally but Excel is ok) which has data like this
______| Age | Height | Shoe Size | etc...
Adam | 14 | 180 | 11 | ...
Beth | 21 | 205 | ...

**2**

votes

**1**answer

54 views

### Excel: how to illustrate a budget constraint that depends on more than two factors in a table? Calculate how much of a house you can afford

Imagine that you want to make calculation of how expensive flat/house you can afford to buy. You know how much you can spend on housing per month (100). You also know that there are three factors that ...

**1**

vote

**2**answers

29 views

### Spreadsheets for Matlab

I was wondering if there was a way to directly write a spreadsheets in Matlab, or if someone had published a Matlab add-on that specifically introduced spreadsheets?

**0**

votes

**0**answers

34 views

### LibreOffice calc; is it possible to automatically make cells coloured according to the HTML code entered into them?

I am creating a LibreOffice calc spreadsheet designed to be basically be a customized version of the table entitled "Default element colors, by atomic number:" on this page ...

**0**

votes

**1**answer

18 views

### Importing numbers with leading zeros as text strings in gnumeric

I have a csv file with numbers, some that start with zeros. Those zeros are somewhat important to me. All the entries in the file are encapsulated with double quotes. Gnumeric's import dialogue ...

**0**

votes

**2**answers

100 views

### How do i split a single row of columns into multiple rows and columns?

I've looked all over and either I am not sure how to word this for searching, or there just isn't anything out there. Originally, the information in my excel sheet was pulled from a text file. I had ...

**0**

votes

**4**answers

37 views

### Inserting specific number of rows in Excel

I, for the life of me, can not figure out why M$ has not provided this feature. If I want to insert 597, for the sake of argument lets say blank, new rows, all available information tells me to either
...

**1**

vote

**2**answers

40 views

### How to export a table from inside a PDF into a spreadsheet?

I want to convert this PDF which contains a table, into an Excel-compatible spreadsheet for the purposes of making flash cards.
Does anyone know of an automatic way to do this without manually ...

**0**

votes

**0**answers

28 views

### Formatting a chart with many data points for a small display area

In Excel 2013, I need to display a chart with dates on the X axis and errors (already computed) on the Y axis. The problem is that I have 916 data points taken every six hours spanning approximately ...

**0**

votes

**1**answer

42 views

### Identify in what of the given ranges is a random number

I have this table with the first column being just an Identifier Code and the second one being the ranges.
So for example if a number is between 0 and 1134, it corresponds to the first row ...

**0**

votes

**1**answer

30 views

### organizing columns in excel into standard format

I have data in a excel spreadsheet in a regular pattern that needs to be organized in a format friendly to statistical analysis.
Here is the format:
Clinton 29.30% 22
Edwards ...

**1**

vote

**4**answers

935 views

### Count the number of rows with equal values in two specified columns

I have two columns in MS Excel/LibreOffice Calc/Google Spreadsheets with numbers. I would like to count the number of rows which have identical values in both columns.
In the following example:
...

**0**

votes

**0**answers

21 views

### Spreadsheet Function Help - From A Table Of Names And Birth Dates Pull A List Of Names As Of A Reference Date And There About

I have posted this question before, and got half-solution. Pls have a look at this link to get an idea.
http://yogi--anand-consulting.blogspot.in/2014/11/yogifrom-table-of-names-and-birth-dates.html
...

**1**

vote

**2**answers

149 views

### Parsing dates in LibreOffice Calc - is there a better/easier way?

I have a string of this particular format:
DD/MMM/YY HH:MM AM/PM
e.g.
03/Nov/14 9:00 AM
I could not find figure out how to make Calc recognize it as a date so I had to do the following for a ...

**0**

votes

**1**answer

73 views

### Can I separate email id in spreadsheet based on domain in columns? [duplicate]

I have a list of 20000 email id which have emails from domains like gmail, ymail, gmx, hotmail, custom domains etc I have those list in a spreadsheet Column A. Can you help me separate them according ...

**0**

votes

**0**answers

52 views

### Label distribution and scaling in Numbers

I'm currently working in OS X Numbers on a document with two columns and 1078 rows.
Using this data, I have constructed a simple 2D line graph which I am fairly happy with.
The issue that I'm having ...

**2**

votes

**1**answer

1k views

### Import one cell of data from one spreadsheet to another

I have one spreadsheet that is for global use in which I would like to incorporate one cell of data from various other spreadsheets to refresh anytime there is a change to the source. So for example:
...

**0**

votes

**2**answers

52 views

### How to add up hours

I have a spreadsheet to track my hours at work and I was wondering how I would go about adding up my total hours. I'm not fussed what format it be in, whether it be HH:MM or as a decimal.
...

**0**

votes

**0**answers

16 views

### Prepend text for spreadsheet

I want to have a string value prepended to a XL-style formating in a spreadsheet program (gnumeric). The current formatting is [$-f4f2]hh:mm which should take 1:00 PM as input and convert/display it ...

**-2**

votes

**1**answer

48 views

### What formula can I use to colouring in columns?

I am creating a planning spreadsheet for the operators to use on the shop floor.
Products have a specific time in which they are made. All I want to do is, when I type a product name into ANY cell, ...

**0**

votes

**1**answer

142 views

### Copy reference instead of value/formula in Excel?

I have some cells from one table I which I want to reproduce in another table, initially in the same order (but later, I'll mess this order up by moving cells around). For the sake of discussion ...

**1**

vote

**1**answer

44 views

### How to efficiently reference an entire row in Excel?

I am working on a budget spreadsheet in which I have to pull in cell data from another external spreadsheet. I have to do this for several different sheets with massive amounts of data in the sheets, ...

**0**

votes

**1**answer

32 views

### Unable to expand cells in Microsoft Excel

I have an odd issue that I need your help with.
Within my spreadsheet there are many cells that although contain data, do not respond when I try to automatically resize them.
I've tried auto-fit, ...

**0**

votes

**1**answer

55 views

### Spreadsheet data checking columns

I am trying to separate datas from columns(A,B&C) based on datas from an index table at columns (E&F)
I need to list only those data from columns A/B/C when column B data has no corresponding ...

**0**

votes

**2**answers

35 views

### Double column value in a spreadsheet

I need to double the value of a column (ex: C) into another (ex: F) for every row in a spreadsheet.
How can I achieve this?
This is probably simple, but I can't get my head around it.
Thank you.

**0**

votes

**1**answer

39 views

### Combining Two Differently Formatted Spreadsheets

I'm relatively new to excel and am having some issues comparing two sheets of data. We're looking at the benefits over the fiscal year by month. One spreadsheet has the project ID on the left, and the ...

**0**

votes

**1**answer

59 views

### I want to create a format in Excel to trigger a colour code?

Currently I have a drop down list on certain cells, connected to a list of statuses. 'Complete' which marks as green, 'Pending' which marks as orange, 'Outstanding' which marks as Red. I want each ...

**2**

votes

**1**answer

26 views

### How to show a value of a Cell as it's displayed

I have a cell A2 that shows the value 001. I want to concatenate that value of 001 to a string to show REQ-001. The cell that I want to show this string I have =CONCATENATE("REQ-",A3). But the ...

**1**

vote

**1**answer

39 views

### spreadsheet: sorting by the first n characters of the entries of a column then by another column

Is there any way to sort an OpenOffice Calc spreadsheet by the first n characters of a given column then by another criterion?
For example suppose that we have the following 4*2 spreadsheet (Note ...

**0**

votes

**2**answers

124 views

### How to sort columns in Excel so that only one value appears in each row?

Say I have a a spreadsheet with the following data:
A B C D
---------------------
2 1 0 2
3 2 1 4
5 3 3 6
7 5 6 8
11 8 10 10
...

**1**

vote

**1**answer

71 views

### How to perform a function based on surrounding cells in Excel?

My rows on my spreadsheet look like the following:
foo | cherry | 400
bar | lemon | 300
foo | cherry | 500
bar | cherry | 70
I want another row to make calculations in column C based on the ...

**1**

vote

**1**answer

292 views

### Sumproduct, Sumif, Indirect and named ranges issue

I have this formula that works:
=SUMPRODUCT(SUMIF(INDIRECT(Financials&"!$B3:$B10000"),'Information PG1'!$K$2,INDIRECT(Financials&"!d3:d10000")))
where Financials is a named range. If I ...

**1**

vote

**2**answers

55 views

### add same value to range of cells in microsoft excel

I want to add the same word from cell B1 to B40000
I do not want to use the click and drag box method to apply it across multiple cells/rows.
I know I have to type in the formula bar B1:B40000 but I ...