# Tagged Questions

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

20 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")) ...
43 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 ...
31 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 > ...
33 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 ...
23 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 ...
41 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 ...
35 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 ...
21 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 ...
26 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 ...
12 views

### Google drive spreadsheet is showing black shadow on while typing letters

I mm using Google drive spreadsheet. It is showing a black shadow while typing letters in excel. How do I resolve this?
20 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: ...
17 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 ...
39 views

### Heterogeneous Workbook Consolidation – Need Assistance

I have several Excel workbooks, each containing a couple dozen spreadsheets. The workbooks have different names and so do the spreadsheets, and simply mass consolidating doesn't help with the issue I ...
48 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 ...
36 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 ...
35 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 ...
22 views

### Cell formatting in Google Spreadsheets does not get preserved

My Google Spreadsheet does not preserve some formatting. Every time I set, for example, font size to 12 for the whole sheet, newly copied data uses a smaller font size. This only started being an ...
19 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 ...
40 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 ...
36 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 ...
30 views

### Histogram of dates in Google Sheets or OpenOffice

I have a list of dates that I would like create a histogram of. date 5/21/2014 5/20/2014 9/16/2014 5/28/2014 6/8/2014 6/8/2014 5/28/2014 5/20/2014 8/11/2014 7/19/2014 8/11/2014 The chart's x-axis ...
16 views

### Apache OpenOffice 4.1.1 OSX 10.8.5

After losing an extensive spreadsheet last night, I started all over today. Got it completed. Had saved (as .xls) manually using save/save all in the dropdown menu periodically throughout. Closed. ...
20 views

### Lost file Apache Open Office

I'm using Apache OpenOffice. Lost an extensive spreadsheet when OO crashed. Is there a possibility it's still on my OSX 10.8.5 system somewhere? Can't find it. Document was saved numerous times. ...
18 views

### Kingsoft Spreadsheets = “Free” version of Excel…won't Sort by column Headers any more

I've had this happen even in Excel, but it's always annoying. I'll be sorting just fine, no worries, then boom, it will refuse to sort by the column Header and will only look at the first cell of data ...
22 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 ...
86 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 ...
22 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 ...
25 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 ...
18 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 ...
248 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 ...
116 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 ...
71 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 | ...
31 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 ...
57 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 ...
56 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 ...
676 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 ...
23 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 ...
76 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. ...
22 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 ...
28 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 | ...
89 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 ...
54 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?
107 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 ...
28 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 ...
128 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 ...
64 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 ...
48 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 ...
46 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 ...