# Questions tagged [spreadsheet]

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

**1**

vote

**1**answer

22 views

### How to find cells that reference the current cell in LibreOffice Calc spreadsheet?

I am trying to understand a spreadsheet created by someone else. It has many complex formulas.
When I select a cell, is there to highlight other cells that have a formula that references the selected ...

**0**

votes

**1**answer

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

5k views

### Comparing two Excel spreadsheets to highlight changes

I need to compare two large, multi page spreadsheets and combine them into one spreadsheet showing the data that was in the original one and also what it was changed to in the second one?
I have ...

**-1**

votes

**0**answers

14 views

### Show all pages in google spreadsheet [closed]

I have many pages in my Google spreadsheet document. I can reach them by using scrollbar. But I would like to see all them at once. How to achieve that? Is it possible somehow get two or even more ...

**1**

vote

**0**answers

22 views

### In Numbers/Excel how can I do a SUMPRODUCT only on rows matching a specific criteria

Let me explain my spreadsheet a little bit. Here is a good screenshot of it:
I have created this spreadsheet essentially because I have gotten tired of the usability issues of just about every ...

**0**

votes

**2**answers

24 views

### How to merge Excel worksheets by stacking columns, using an ID column?

I have a Worksheet #1 containing:
ID VALUE1
----------------
ABC 8274
DEF 613
GHI 236
and a Worksheet #2 containing:
ID VALUE2
----------------
ABC 11.13
XYZ ...

**0**

votes

**1**answer

33 views

### Sequential conditional formatting

I hope someone can help with this as my knowledge of excel is relatively limited.
I want to apply conditional formatting to a spreadsheet (see screenshot)
On each individual row, I want to show the ...

**2**

votes

**3**answers

64 views

### keyboard equivalent of dragging the little black square to generate sequence

What is the keyboard way of generating a sequence?
The pic below shows libre office calc. In order to generate the sequence of numbers 1 to 10. I simply enter few numbers of the sequence (in ...

**0**

votes

**1**answer

22 views

### Formula in Excel or Numbers to generate a series of numbers

In my spreadsheet I have two numbers, start_number and nr_iterations. I'm looking for an formula that returns a series of numbers starting with start_number - 1 and nr_iterations long (each following ...

**0**

votes

**2**answers

35 views

### Microsoft Excel: display realtime filtering data from another worksheet

I want to display all rows that has Gender column equal to M inside sheet2. The data is retrieved from sheet1. The filtered data also has to be real time, meaning whenever I make change in gender ...

**1**

vote

**3**answers

6k views

### How to filter a spreadsheet on multiple filter values

I've got a spreadsheet of addresses with the following columns: First Name, Last Name, Street Address, City, State, and zip code. I'd like to be able to filter or otherwise extract a subset of these ...

**0**

votes

**1**answer

41 views

### Why is Excel Document Printing at Bottom of Page when Orientation is Landscape?

We just replaced our office printer from a Canon ImageClass MF3240 to a much newer Canon ImageClass MF260. When we try to print Excel spreadsheets in landscape orientation the printer will print the ...

**1**

vote

**0**answers

18 views

### Excel spreadsheet/workbook data connections: Two way communication with applied filter?

So let me pose you guys a scenario.
There are several users all inputting data into a single spreadsheet. This work is initially assigned to these users by a manager who, after the data is input, ...

**0**

votes

**1**answer

38 views

### Excel - Search for a string then add some values (Entered to many arguments)

I have 5 sheets with country data, I want to lookup the country name on 4 separate sheets within 4 separate ranges then take a value from the row and add all those values.
I was getting #NA as a ...

**3**

votes

**3**answers

1k views

### How to create an array of values in LibreOffice Calc?

I'm using LibreOffice 5.1.4.2 Calc and need to calculate the internal rate of return for a certain payment (say, in cell A1), a certain number of times (say, 100).
If I had the value repeated 100 ...

**3**

votes

**4**answers

4k views

### Turn Excel spreadsheet into a formula [closed]

I have an Excel spreadsheet that has a complex computation that is not trivial to turn into a macro or a single-cell formula. The spreadsheet has about 10 different inputs (values a human enters in ...

**0**

votes

**1**answer

64 views

### LibreOffice Calc - Multiple INDEX-MATCH and copy to other cells

I'm just starting to use LibreOffice Calc to try to manage my finances, and have imported CSVs of statements from my bank.
The first task I would like to accomplish is to display, in an easy-to-read ...

**13**

votes

**6**answers

117k views

### Select each nth row in Excel

I have an Excel spreadsheet with thousands of rows. I want to select every 7th row from that spreadsheet. (By "select," I mean delete all of the other rows, or copy the selected rows into a new ...

**4**

votes

**2**answers

2k views

### WPS Office CSV Delimiter - Linux

I have been using LibreOffice for all my Spreadsheet and Wordprocessing requirements lately but am getting fed up with the performance issues, it has a massive lag and also constantly freezes.
I have ...

**0**

votes

**1**answer

23 views

### Long Calc Sheet - subtotal at bottom of page, transfer to next page?

Assume i have a LibreOffice Calc sheet spanning multiple pages in printout. Is there a way to calculate a subtotal for each page and print it at the bottom of the respective page as well as at the top ...

**1**

vote

**2**answers

492 views

### Excel: Using nested IF statements containing wildcard characters

I'm currently working on a project where I have a list of patient visits to a clinic. Each patient is assigned a Primary Care Provider, but that's not always the Rendering Provider at a given visit. ...

**0**

votes

**1**answer

322 views

### How to create a Supply & Demand style chart

Here's an example of a basic Supply and Demand Graph:
The Vertical Axis is always Price
The Horizontal Axis is always Quantity
There should be two lines, one for the supply curve and one for the ...

**1**

vote

**3**answers

45 views

### Spreadsheet: create column based on one column sorted by values of another

I want to create a new column of data from one column sorted by another column.
It's easiest to explain with an example. This is not actually what I'm doing, but I think it explains it well.
Let's ...

**1**

vote

**3**answers

1k views

### How to fix Excel and prevent it from converting copy-pasted or imported strings to dates even when cells are formatted as text

Every time I copy-paste some numerical data written as fractions or separated by hyhens into Excel, it always converts numbers that could possibly be dates into dates. There's no way of getting them ...

**2**

votes

**1**answer

58 views

### Excel 2016: Formula to get data from different spreadsheet

help with this tricky formula is greatly appreciated.
='[DATA.xlsm]2018'!$G$6 *this formula works, but . . .
Spreadsheet with formula Spreadsheet with Data
I need the formula to determine ...

**0**

votes

**1**answer

43 views

### How do I create a ''droplet'' script in Win7 that runs a Notepad++ task on a CSV file

I have recently asked a question on how to perform a neat little 'Find & Replace' task on my CSV media database files (a task i have to do at work on a daily basis). The question was answered here ...

**1**

vote

**2**answers

56 views

### Automate completion of spreadsheet for invoice

I need to invoice someone each week. I would like to create a template as 90% of the information on each invoice is the same, and the remaining 10% follows simple rules.
Each invoice has a number ...

**0**

votes

**2**answers

114 views

### How exactly do I make multiple columns into one row to sort?

Currently trying to sort data into alphabetical order, however, I am running into a problem.
Every time I try to sort it the product number doesn't match up with the product.
I have been going on ...

**0**

votes

**1**answer

29 views

### how to use Countifs function Excel?

from what i have been reading online it appears Countifs function is what i need to use for my problem. I have data that looks like this and goes on for several months:
|Month |Day| Time ...

**1**

vote

**2**answers

51 views

### How do I copy specific selected data between cells in a CSV file in Excel or Notepad++?

I have to download media file databases on a daily basis and modify metadata from a csv file so that the unique numerical prefix in column B is added as a suffix to the cells in column C.
Is there a ...

**0**

votes

**1**answer

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

**0**

votes

**1**answer

60 views

### spreadsheet formula for returning parts of filtered cells in column

I use Libreoffice. (If Excel or GoogleSpreadsheets would be the only way to get a solution, I would be willing to switch. But the preferred platform is LibreOffice, I'm looking for a solution on this ...

**8**

votes

**3**answers

3k views

### How to compare two Excel spreadsheets?

I would like to compare two Excel spreadsheets
Both have the same columns, in the same order, but not the same rows.
I have a spreadsheet with 1,000 rows and 50 columns including a unique ID for ...

**4**

votes

**1**answer

58 views

### libreoffice /open office calc - visualise formula

Let's say I have two alternatives in columns C,D like so:
row 6: sample size
row 7: sample mean
row 8: sample standard deviation
and then want to do a t-Test, which requires (amongst other things)...

**0**

votes

**1**answer

47 views

### Copying from a table row to spreadsheet with formula

I have this sample data from my HTML table row.
Tester sample@gmail.com 2018-07-19 1000 1200 new
And I am copying this data to google spreadsheet with a formula ...

**0**

votes

**2**answers

58 views

### Lookup Function Giving Inconsistent Results in Excel & Google Spreadsheet

I am trying to create a column of looked-up values using the LOOKUP function. The goal is for the formula to look up the "rank" value of each "name" and print it in the "lookup" cell on the same row.
...

**3**

votes

**1**answer

85 views

### A single pound sign '#' to custom format excel cell?

I need to display a very big number within Excel, for example a following number: 174587584558159.
Excel displays it by using a scientific notation, like following: 1.74588E+14.
I tried to format ...

**0**

votes

**1**answer

72 views

### Updating column values from one Excel spreadsheet to another

I had no idea what to Google for this. Basically I have 2 Excel files: File A and File B.
Here is File A:
And here is File B:
I am trying to loop through File B. I want to look at each row's first ...

**0**

votes

**1**answer

45 views

### two date cells - i want 3rd cell to some value

I have two cells with completed installation dates. I have a 3rd cell where I need to input outstanding installations.
If the 2 cells have dates, it means the installation is complete so I want the ...

**1**

vote

**1**answer

50 views

### how to save time with multiple COUNTIFS possibilities?

I am sure that there is a smarter approach then this brute one:
=IF(COUNTIFS(O40<>P40;O40<>Q40;O40<>R40;O40<>S40;O40<>T40;O40<>U40;
p40<>o40;p40&...

**1**

vote

**3**answers

2k views

### Image file to spreadsheet

I want to take an image file (eg tiff) and convert it to a spreadsheet (csv, or whatever) such that each pixel becomes a cell with a numeric value for that pixel.
I have googled it, and everyone is ...

**2**

votes

**4**answers

688 views

### Is it possible to make the cell cursor blink in excel?

I have a large spreadsheet - with quite a bit of colour and bold font etc.
It's often hard to see the cursor - i.e. to find the cell that is selected. It just appears as a slightly thicker green line ...

**3**

votes

**4**answers

7k views

### Adding a constant in LibreOffice Calc

How do you add a constant to a group of cells in LibreOffice Calc?
For example, here are four cells:
47 28 35 62
Now add 3 to each cell:
50 31 38 65

**0**

votes

**1**answer

33 views

### Excel - can you setup a certain worksheet to open when the spreadsheet is first opened?

Hoping someone can help, I have a spreadsheet that I need to open at a certain page, everytime when opened eg.. an index page.
I have the Vb code and works offline but I have since found out this ...

**0**

votes

**2**answers

56 views

### DATEDIF() not returning expected value, how can I calculate age in months?

I'm trying to calculate the age of my credit card accounts in Excel. I've read online to use the DATEDIF() function, however, I'm not getting the expected result and I'm not sure where I screwed up.
...

**-1**

votes

**1**answer

47 views

### Copy cells from one excel spreadsheet to another based on a value in the row

I have a spreadsheet, Sheet 1, with data in it taken by the minute. Each line row has a timestamp and the corrosponding data follows.
I have a second spreadsheet/sheet, Sheet 2, with accompanying ...

**0**

votes

**0**answers

39 views

### What's going on with my Excel formatting?

I have a spreadsheet in Excel with a few columns that have a different format from the rest of the sheet.
I inserted some new cells (old ones moved to the right). None of the old cells had this ...

**1**

vote

**0**answers

73 views

### In Excel, is there a way to autofil formulas that link to other files with information from other cells in the current spreadsheet?

I have a master spreadsheet that collates data from other spreadsheets, and shows this via linked cells - for example, I would have ten identically set out spreadsheets, each showing a different total ...

**1**

vote

**0**answers

61 views

### Show contiguous time periods without data in Libre Calc pivot table, pivot chart?

A minimal example: our table has sales in 2015, 2017, but not 2016.
Date Sales
01/02/15 $500
10/11/17 $1000
You make a Pivot Table:
Data > Pivot Table > Create
Row Fields: Date
Data ...

**0**

votes

**1**answer

54 views

### Generate cell pairs based on first row and column

Given a spreadsheet like this:
x | pressure | distance | height
pressure
distance
height
I would like an output like this:
pressure pressure
pressure distance
pressure height
distance pressure
...