# Questions tagged [spreadsheet]

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

**0**

votes

**2**answers

158 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

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

**1**

vote

**1**answer

971 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 rows ...

**2**

votes

**2**answers

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

**1**

vote

**1**answer

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

**3**

votes

**1**answer

59 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

83 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

59 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 shipped ...

**2**

votes

**2**answers

122 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

354 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
3,...

**2**

votes

**2**answers

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

**1**

vote

**1**answer

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

**1**

vote

**1**answer

2k 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

1k 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 ...

**2**

votes

**1**answer

208 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 what ...

**0**

votes

**0**answers

32 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

**1**answer

719 views

### Spreadsheet for binary calculation [closed]

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

562 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 shekels)...

**-3**

votes

**1**answer

19k 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

89 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

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

4k 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

811 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

75 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

128 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 all ...

**0**

votes

**1**answer

55 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

940 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

284 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

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

**1**

vote

**1**answer

42 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

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

**1**

vote

**1**answer

306 views

### How can I convert this date format to the ISO date format?

I have a spreadsheet with a list of dates in the format 25th Jan. I'd like to convert these to ISO format, ie YYYY-MM-DD. The year will in all cases be 2016. Is there some magic equation-foo that will ...

**0**

votes

**2**answers

2k views

### How can I pull specific rows in Excel into a new spreadsheet

I have several spreadsheets containing data I need to analyse. I have a randomized list of numbers that dictate which rows in each spreadsheet I need to code for my data sample.
Is there a formula I ...

**1**

vote

**1**answer

75 views

### How to determine largest individual value in excel in a group of identical cells?

I am trying to figure out Column D Which SKU has highest total? how do I do that in excel with a formula? In this case I determined it manually, I tried IF=IF(A2=A3,IF(C2>C3,"Largest","NOT Largest")) ...

**1**

vote

**1**answer

148 views

### Excel 2013, SUMIFS formula

I think I need to use a SUMIFS function for this but I am not positive. I have a list of codes:
All of these codes are in a category of downtime, each code also has minutes 5,10,15,40,65 etc. My ...

**0**

votes

**4**answers

1k views

### Format percentages in Microsoft Excel

I am trying to format the following column in Microsoft Excel to add the percentage sign after the second decimal:
5.8394
3.2922
3.2
4.461
1
I highlight the column and choose Format cells > ...

**0**

votes

**1**answer

363 views

### filter excel list by formula instead of values

If I have a column in excel, with the following formulas, would it be possible to filter it? In this case, the values are all 7, but could I filter by the explicit formula?
=2+7
=3+4
=2+7
7
=1+6
7
=...

**2**

votes

**1**answer

102 views

### Excel autonumber range

Most of you know about this little feature of Excel, as well as almost any other spreadsheet software like Google Spreadsheets called Autonumbers. Example.
What I'd like to know if it's possible to ...

**0**

votes

**1**answer

100 views

### How does the user make a selection in MSExcel that contains only those cells that contain data?

Got an MSExcel question for you.
he specs for my computer are: Intel Inspiron laptop i3-2.20ghz , 8GB DDR3, 400GB HDD, Win 7 Prem.
And the version I am using is MSExcel 2003.
My question has to do ...

**0**

votes

**1**answer

365 views

### Excel spreadsheet formula to sum a column

I'm trying to create a formula that sums a total of only the trailers that are in the yard but don't have a date unloaded next to them. Please see the link for a screenshot of the spreadsheet I am ...

**2**

votes

**2**answers

54 views

### How to sum two categories within a single column and show the totals to the side of the column?

I have a list of trailers with a column to the side that says if the trailer is full or a pup trailer. I can't figure out how to make the column total how many of each type of trailer and show the ...

**0**

votes

**1**answer

279 views

### How can I update running total of money owed month on month automatically?

I have a spreadsheet of a monthly coffee fund that all my staff pay in to.
Is it possible in Excel to have a running total of what everybody owes that increases month on month automatically?
And ...

**0**

votes

**0**answers

49 views

### Which versions of MSExcel support the 'WEBSERVICE' function?

Pursuant to Excel formula to take out quotations ,
I saw that it's possible to use a form of web-querying in certain versions of MSExcel. Incidentally, what I saw was:
=WEBSERVICE("http://finance....

**1**

vote

**1**answer

314 views

### Count number of cells that match certain criteria with formulae

Suppose I have column with dates:
2015-01-10
2015-08-12
2014-01-02
2015-01-28
2016-10-14
I want to count how many dates fall to January. I would supopse that formulae is like this COUNTIF(A1:A20,"...

**1**

vote

**2**answers

952 views

### openoffice calc: sum of a function of elements of a row

If I want to sum the elements of the first row (from the column a to x) of a calc document I can use =sum(a1:x1).
My question is about the possibility to calculate something like this
=sum(a1^2/(1+...

**0**

votes

**2**answers

384 views

### Prevent formula input in all cells in a column, but allow whole number input

I am in a bit of a sticky situation. There is a public spreadsheet that some of my coworkers are required to use for their job. They all collectively use it during their shifts to track product ...

**1**

vote

**2**answers

818 views

### Counter in Excel

My file has 50 sheet inside, which each sheet is a standard form. Lets name as Form1, Form2, Form3.
I want to create a print sheet, where I select which form I want to see, so that I don't need to ...

**0**

votes

**1**answer

762 views

### How to add double quotes around data in tables using Calc

I am trying to load my data into a CRM, but am having a lot of trouble. The data simply wont load at the same time, but all the files work fine individually. Support advised that I make sure I'm using ...

**5**

votes

**1**answer

22k views

### how to highlight the cell with the max value

given a range of non adjacent columns (not sure if it matters if they're adjacent) i.e
F1:F100,J1:J100,N1:N100
for each row i'd like to highlight the cell with the maximum value.
i tried ...

**0**

votes

**2**answers

40 views

### need help in editing data in csv file

I am in need of editing the date data in csv.
I will explain with an example.
I am using WPS presentation software for reading and editing csv files. If the above is not possible in that, i can also ...