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

**0**

votes

**2**answers

16 views

### Highlighting Groups of Alternating Names in Excel

I have been trying to find a good way to do this but it seems like I can not find a good Conditional Formatting formula to work with what I need. I am trying to do something along the lines of this ...

**1**

vote

**2**answers

19 views

### Merge / glue exported pdf from spreadsheet application

Spreadsheet applications offer to export tables as pdf. Often, the table is to wide to fit on a single page (without scaling), so several pdf pages need to cover the full width of the table.
Let us ...

**0**

votes

**0**answers

9 views

### How to use dot as splitter in currency format with Russian locale [migrated]

I want to write currency in the format:
₽ 3 812.23
But if I select Russia as region in the table settings and format the string
₽ 0.00
result formatted number like
₽ 3 812,23
with a comma, ...

**0**

votes

**3**answers

36 views

### Transpose data from row/column that matches certain criteria

I conducted a survey that asked for a Score and a Priority for each question.
The response data lists each component in individual rows, so that it's treating Score and Priority as different ...

**1**

vote

**1**answer

26 views

### AVERAGEIFS values that are not NA

I have the following AVERAGEIFS that averages column I grouped by the values in column B
= AVERAGEIFS(B:B, A:A, A:A)
Problem is, sometimes, the column B sometimes contains an NA() error. How do I ...

**0**

votes

**0**answers

12 views

### Cut and paste large amounts of text into ActiveX text box with scrollbar

I learned in another post on this site how to add an ActiveX text box to a cell with a scroll bar. Thanks! The only problem is, for the scroll bar to appear, I have to retype all the text manually. If ...

**1**

vote

**0**answers

28 views

### Show Excel Cell Only If Another Has Data

I am trying to format the below Excel sheet so that when a date is entered into cell J1, cells G24 - G37 populate with a date a specific to what I need. I currently have the cells formatted as ...

**0**

votes

**2**answers

42 views

### Date stamp when editing rows in spreadsheet

I have a spreadsheet which needs date stamp for each row as soon as there are changes being made in cells within that row. For example, I change something on cell B14 or E14 or G14 and today's date ...

**0**

votes

**1**answer

21 views

### Categorize spreadsheet lines - ala SQL GROUP

I want to consolidate a series of name-value pairs by name and sum the values. The pairs are in two columns of a LibreOffice Calc spreadsheet, about a hundred rows.
Input:
Output, to another part ...

**0**

votes

**2**answers

74 views

### #VALUE! Error while trying to use a referencing cell in a formula

I would like to use the value inside a cell which continuously gets updated from a web page. The cell called C20 linked to another sheet called ratedatasheet and that sheet displays a page and table ...

**1**

vote

**1**answer

19 views

### Can I (and If so How?) use the MATCH function to search two (or more) different spreadsheets for a value?

First I'll explain what I already have (which works), then explain my question, which is about expanding it:
I have two different spreadsheets that will be worked on at the same time, I needed to see ...

**0**

votes

**0**answers

24 views

### Excel 2007 Monthly total

I have a spreadsheet keeping track of changes needed to update a parts list. I want to keep a monthly total of who submitted the change & how many they did each month. Column "G" has the date ...

**0**

votes

**0**answers

18 views

### Google Sheets - Selecting latest date across multiple columns for a row that matches a criteria

Here is the spreadsheet setup
Now I'm creating a report where I can enter the Member_# in cell K1 and the latest date from columns D, F, and H appears in cell K2 as well as the test label from the ...

**0**

votes

**2**answers

111 views

### Put a checkbox in a cell in Excel v15 for Mac

I am trying to make a checklist in Excel.
Basically I am trying to make a cell:
Into a checkbox that can be checked or unchecked, and saved with the spreadsheet:
It's super-duper easy to do it ...

**0**

votes

**2**answers

36 views

### Excel sorted heading won't sort data in whole spreadsheet

So I would like to be able sort all my data using the little drop down arrow created by the filter function, all the way from F to JE.
At the moment it will only sort from F to AK.
Any idea how I ...

**1**

vote

**1**answer

109 views

### In Excel for Mac (2008), how do you display characters that are converted to “#” symbols?

I am using Excel 2008 for Mac (I am also trying to work using the newest version of Excel on my computer, but it keeps crashing).
When I open the spreadsheet that I need to work from, some of the ...

**0**

votes

**1**answer

68 views

### Extracting data from an excel sheet into another excel sheet

I have a sheet with certain data arranged like this:
X8 - something - something2
X12 - somethingelse - asdfg
X8 - asft - sastaryraavt
X8 - random - random2
I need to extract only and all of the ...

**2**

votes

**2**answers

47 views

### Is there a way to merge tabs in Excel without using a macro?

I'm needing to combine worksheet tabs together to allow me to see all of my data on one page. Can it be done without using a macro?

**0**

votes

**1**answer

41 views

### Excel: Sort by result of comparison

I think it'll be easier to elaborate by explaining with the rules and example.
In a soccer competition (UEFA Euro), there are several groups of four teams each. Top two teams from each group qualify ...

**0**

votes

**0**answers

67 views

### Copying data from a mixture of protected and unprotected workbooks in Excel

I've been given 16 productivity-tracking spreadsheets from a team, and tasked with pulling the numbers from all the sheets into one, for a 'team average' type deal.
Two of the 16 workbooks are ...

**3**

votes

**1**answer

38 views

### How can I look up the 2 axis values by inputting a number?

I'm a graphic designer and not very familiar with Excel but I'm fairly sure it's the simplest solution to my problem. I have a table (see below) with 2 axis going from A to L. Inside that table are a ...

**0**

votes

**1**answer

40 views

### Is There an .xml Format File that Excel Can Read

I'd like to use C++ to generate an Excel file.
I know that Excel can read .csv files, but I was looking for something with more power. For example, the ability to create separate sheets and insert ...

**0**

votes

**1**answer

27 views

### Excel TODAY() function

I have two tables in excel
The first table is called Oranges, it shows where the oranges were produced and where they were exported to:
The second table is supposed to show the total oranges ...

**2**

votes

**2**answers

63 views

### Creating an Invoice in Excel

I have only dabbled with Excel and not much in quite some time now.
I have an Excel Invoice laid out so Column A is a name of a job and each row in column A can be a different job.
Now column B ...

**1**

vote

**1**answer

55 views

### Merge 2 excel spreadsheets both containing updates in rows and columns

I have 2 spreadsheets and need to merge and update the data combination of both.
Spreadsheet A
userid, name, phone1, phone2, city
1, mister T, 123 123, 123 124, paris
2, mister A, , 123 124, tanger
...

**0**

votes

**0**answers

11 views

### how can I clear a form but leave formulas intact

I have a spreadsheet I use to track expenses. At the end of the year I'd like to use this for 2016. Is there any way to clear the data I added over the year but still leave all the formulas in tact?
...

**2**

votes

**2**answers

127 views

### Copy paste from spreadsheet to browser list

I have a browser based form like the one shown below.
The Student No and Name of the Student fields are not editable.
I need to key-in numbers to the Total field.
The Student No field is numeric. ...

**0**

votes

**1**answer

40 views

### Is it possible to automatically separate line/scatter plot data into different series based on an additional column?

My data looks something like this:
H, 2015-12-11T19:44:34, 3270
W, 2015-12-11T19:44:34, 2150
H, 2015-12-11T19:49:35, 3370
W, 2015-12-11T19:49:35, 2290
...
As a one-off, I can get ...

**0**

votes

**0**answers

64 views

### Excel - using info from one sheet and populating it on another sheet

I have a summary spreadsheet where the 1st column has the date and the next columns are titled with different types of work.
On the summary spreadsheet it shows how much production was done on each ...

**1**

vote

**1**answer

88 views

### How to fix a corrupted LibreOffice spreadsheet

I have a substantial multi-sheet LibreOffice worksheet that seems to be throwing a lot of errors in LibreOffice, including crashes.
Any idea of how to get it to work as expected?
I'm thinking ...

**1**

vote

**1**answer

104 views

### Assigning rank in OpenOffice (or LibreOffice)

In OpenOffice (or LibreOffice), is there a way to rank rows?
For example, let's say you have a spreadsheet where cell A1=20, A2=30, and A3=10.
I want to B1 to get a value of 2, B2 to get a value of ...

**1**

vote

**1**answer

30 views

### How to delete multiple rows in Gnumeric

When I select one row in Gnumeric I get the option to Delete 1 Row:
When I select more than one in Gnumeric, I get a grayed out (non-functional) option to Delete 3 Rows:
Clearly Gnumeric knows ...

**0**

votes

**0**answers

19 views

### Map 2 spreadsheets

I have two spreadsheet.
Both spredsheets have an email field. Spreadsheet 1 has 400 email fields and the other has 1000 email fields. The 400 emails are in the 1000 email spreadsheet. The 1000 email ...

**0**

votes

**0**answers

57 views

### Spreadsheet for binary calculation

I have to design some fomulars that operate with integer numbers only. Further the some masks have to been applied to the numbers. The most often required operation is calculating the next number the ...

**1**

vote

**1**answer

130 views

### OpenOffice Calc “if” formula for currencies

I have a spreadsheet that has many different currencies in it ($, euro, shekel). I want to display the actual price in the original currency and then show the converted price (in this case to ...

**-3**

votes

**1**answer

71 views

### Find duplicates in two different tabs [duplicate]

This is what I would like to do: Tab A Column A has a mass of numbers, Tab B Column B will have numbers inputted into it. I need to have the Tab B Column B highlight showing a match to a number in Tab ...

**-1**

votes

**1**answer

62 views

### Excel Budget Spreadsheet

I am trying to create a very nuanced budget in Excel. I have a lot of rules about budgeting and thought it would be easier to create a spreadsheet. When a certain line item exceeds budget it is to ...

**1**

vote

**0**answers

2k views

### How can I create sub-sheets in Microsoft Excel?

I have a workbook in excel that displays information from multiple processes and each of these processes has multiple sub-processes.
I can display information for each process easily using one sheet ...

**0**

votes

**1**answer

233 views

### Linking rows in Excel without merging

I would like to know if it is possible to link rows together in Excel without merging. For example, I would like A1 tied to B1 so when I move A1 around to different positions in Column A, B1 will ...

**2**

votes

**3**answers

141 views

### How do you properly align average and standard deviation outputs in a spreadsheet?

I am not sure of the best way of formulating this question right now so I will use an example using random numbers. I start with values assigned to IDs, so that each ID can be n=1, n=2, ... etc
ID ...

**0**

votes

**1**answer

39 views

### Reference a cell with input from another cell

The final objective is to reference the last populated (higher row number) cell from a column (its value).
I found a function that returns the row number of the last populated (higher row number) ...

**-2**

votes

**1**answer

55 views

### How do I add a button to a spreadsheet and remove borders from a particular cell?

I have two queries regarding the following Excel file:
I would like a button on this excel sheet whose name should be “Save as PDF”.
When I press this button it should save the excel sheet’s ...

**0**

votes

**1**answer

37 views

### How do I use today's entered data in excel for a formula?

I have a table that is 30 rows long in a column. Every day I enter my weight. So day 1 I entered my weight into A1, day 2 into A2 and so on.
Now I want to calculate some things based off of this, ...

**0**

votes

**1**answer

63 views

### How to remove the title from a data table in excel?

Is there a way to keep the data table but remove the values' title (highlighted in red)?
I would like to keep the legend however..

**3**

votes

**1**answer

59 views

### Sum values in specific rows based on whether the row has a value that belongs to a range

Here's what I'm trying to do:
I have a table that has several metrics (example: revenue, cost, etc.) for about a hundred different accounts. I can't modify this sheet because it gets auto-updated by a ...

**0**

votes

**1**answer

38 views

### Excel string to date format

I tried to convert string date value with format cell option but I failed. Tried search over and over again on web but didnt get better solution.
I want to convert following
23rd July 2015
to ...

**0**

votes

**0**answers

15 views

### Currency aware summation in LibreOffice Calc

I have a spreadsheet with columns of the form:
Date A B Total
01/01/15 $100 £200 xxx
08/01/15 $110 £195 xxx
15/01/15 $115 £205 xxx
where A and B are ...

**0**

votes

**0**answers

25 views

### How do I populate a LibreOffice column with data from another sheet

I am working with Volusion and want to change categories for products using LibreOffice. The problem is that my products download file shows categories only by id number (ie. 1, 2, 3, 4)
But I can ...

**1**

vote

**1**answer

21 views

### How do I take the information from 1 spreadsheet and count it on another spreadsheet based on a set range of values?

I have 2 spreadsheets in the same work book. On the first, I have dates names and others values (y/n, amounts). I need to be able to put in a date range on the second spreadsheet and have it take data ...

**0**

votes

**2**answers

65 views

### Entering notes into LibreOffice Calc and OpenOffice Calc

In LibreOffice Calc and OpenOffice Calc, there is often a need to quickly enter several rows of text that will not be part of any calculation area. This is often done to write notes relevant to the ...