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

**0**

votes

**0**answers

12 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

**0**answers

17 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

16 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

12 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 | ...

**0**

votes

**0**answers

20 views

### How do I concatenate a string literal of my cell to a string of another cell? [migrated]

I am trying to make life easier for myself by organising my teaching materials for private tutees of mine from various subjects/educational levels in google spreadsheets.
I want to know how I can ...

**1**

vote

**0**answers

15 views

### How to select a cell from all spreadsheets? [migrated]

I am trying to find a function that selects from a certain cell from all spreadsheets. For example, I want to calculate AVERAGE('Sheet1'!B3, 'Sheet2'!B3, 'Sheet3'!B3), but I don't want to explicitly ...

**2**

votes

**0**answers

15 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

**0**answers

15 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?

**-1**

votes

**0**answers

6 views

### Autopopulate a templated spreadsheet with another spreadsheet

We use Salesforce.com as our CRM and database, with regular use of reports. Naturally, we use those reports for sales and business development strategies. However, the way that we like to look and ...

**0**

votes

**0**answers

11 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 ...

**2**

votes

**1**answer

179 views

### Excel vocabulary to find solutions faster [closed]

Excel (or other spread sheet application) users sometimes find it hard to search for already documented solutions for their problems on google / superuser / other sites when they are not familiar with ...

**0**

votes

**1**answer

9 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

74 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

27 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

33 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

18 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

40 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

26 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

254 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

17 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
...

**0**

votes

**2**answers

64 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

46 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

30 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

410 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

51 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

12 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

45 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

65 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

33 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

29 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

53 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

34 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

35 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

41 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

24 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

36 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

100 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

62 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

208 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

49 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 ...

**1**

vote

**1**answer

71 views

### How to set different orientation for different sheets in OpenOffice.org Calc?

I have document with two sheets sheet1 and sheet2 and i want set orientation of sheet1 to portrait and orientation of sheet2 to landscape.
This can be done in Excel, but in OpenOffice when i set ...

**0**

votes

**1**answer

58 views

### Rolling Averages sheets in excel

I'm collating a document for a Daily Production report at work, in which every day, a new tab is added and the information on part production from each department for the previous day is recorded. The ...

**0**

votes

**0**answers

8 views

### How can I select that element from a vector of Gnumerc / Excel of which the difference of a given cell is minimal?

I would like to do a goal seek in gnumeric / Excel. I would also like to make a column of data, which values are selected from a vector (range) based on minimal difference to a given cell. What ...

**2**

votes

**0**answers

27 views

### In Excel, Can I have two rows of (worksheet) tabs for my workbook? [duplicate]

I'm using Excel (2013). I have a workbook with numerous different worksheets, and would like to have them take up two rows of worksheet tabs rather than just one. Can I achieve this somehow? I can't ...

**0**

votes

**2**answers

66 views

### Pulling out data from a spreadsheet

I need to add information of clients who have visited the office, which department, who they were referred by, who they were referred to etc. I have linked a screenshot of what I have currently made ...

**0**

votes

**1**answer

51 views

### Multiple users editing the same Spreadsheet, is it possible? [closed]

I have used a piece of software called Prezi for multiple users to edit a presentation at the same time, I find this a very helpful tool as if lots of data is distributed across a number of minds it ...

**0**

votes

**1**answer

571 views

### How to get plain text, colon separated file into spreadsheet with data separated into columns

I received a digest of registrations for events. The fields are separated by colons and in plain text. Can I copy and paste this info into libreoffice spead and get it displayed in columns?

**0**

votes

**1**answer

17 views

### Remove symbols while appending in excel

I'm having some parsing issues here. I have a column of Twitter handles, with '@' in front of them, and I'm trying to auto-append them in a URL on the next column.
Example:
| @Bob | ...

**1**

vote

**1**answer

26 views

### Is entry in colum a (at least once) related to entry in colum b?

I'm stuck with a seemingly simple spreadsheet (LibreOffice) problem. Assuming I have three columns given as Name, Day and Mood; how can I find out if person x was happy at least once?
In a second ...

**0**

votes

**2**answers

121 views

### Google Spreadsheet/Excel filtering

As you can see in this image I have spreadsheet of many athlets, that will participate in competition.
My task is using groups (or ranges) DISCIPLINAS (en. Disciplines), which contains 100m run, ...