# Tagged Questions

**0**

votes

**2**answers

28 views

### Cannot delete created excel table

I have created an excel table. However, I now want to delete or change it because my range changed.
However I can't delete it in the excel Name Manager:
Any suggestion why I cannot delete it?
...

**0**

votes

**1**answer

24 views

### How to prevent all-filtered-out row label values from appearing in a pivot table?

I have a pivot table in MS Excel. For the same of example, suppose the basic data has 3 columns:
Name: A string.
CountMe valued either 0 or 1.
Year an integral number.
Tokens the data we're ...

**0**

votes

**0**answers

17 views

### export marked rows in Excel

How can I export the subset of all rows marked by an x in column A?
Example data set:
A B
----------
1 apple
2 x orange
3 x lime
4 cherry
5 x lemon
Exported data set:
A B
----------
1 ...

**0**

votes

**0**answers

28 views

### Updating old stock ticker symbols

I did a study in 2003 that produced a list of about 300 publicly-traded US stocks.
Ticker symbols can change (ticker symbols can even take over an older company's previous ticker).
My situation boils ...

**0**

votes

**1**answer

48 views

### Count instances of a letter in a row if a certain cell in that row contains a specified date

I have a spreadsheet containing a column of dates (week commencing) with columns of data to the right of it, and a conditional formatting rule that highlights this week's row based on the date.
I ...

**0**

votes

**1**answer

38 views

### Share cost of activities between participants in spreadsheet

Say you have a spreadsheet you use to fairly share the cost of activities between people (example google doc):
A B C D E
1 Activity Cost User1 User2 User3
2 1 ...

**0**

votes

**2**answers

71 views

### How to format excel cells that show duration in years and months?

I can't figure out how to do custom formating that would format input "1/5" as "1 year, 5 months", or "5,0" as "5 years". I do want the cell to retain original input of "1/5" but visually display "1 ...

**0**

votes

**1**answer

143 views

### Disable prompts in Microsoft Excel when saving a CSV file [duplicate]

I have to download multiple csv reports from the Internet throughout the day, make a tiny change to them, and save the change. Excel adds 3 completely unnecessary dialogs to what should really be a ...

**0**

votes

**1**answer

33 views

### How do i change value in filtered cells?

Please could someone help me? I have a spreadsheet full of different vacancies and they go in order of the date advertised but have different departments within that and I need them numbered. I only ...

**0**

votes

**1**answer

34 views

### In Excel, how do I access the {value in col B} of the same row whose {value in col A} equals the {{value in row x of col A} minus 365}?

In Excel, how do I access the {value in col B} of the same row whose {value in col A} equals the {{value in row x of col A} minus 365}? My intention is to calculate a vehicle's running average ...

**0**

votes

**1**answer

40 views

### IF (AND () function does not work as it should be

When I write the following simplified command in a cell,
=IF(AND(C6="A";D6="30");D2;0)
it does not appear the value of the cell D2 but zero, depsite the fact that the 2 assuptions of IF(AND) are ...

**4**

votes

**1**answer

80 views

### Allowing users to unhide (format) only chosen columns

TL;DR, what I want to achieve:
Hide some columns which I do not want to show to anyone (check)
Hide some columns which I want to show only to some users (check)
Set separate passwords for both ...

**0**

votes

**0**answers

16 views

### Software to manage service commitments?

I work with an organization that does a lot of volunteer service work and need a solution to the following problems that I considered using a spreadsheet for but would like additional suggestions.
*2 ...

**0**

votes

**2**answers

38 views

### Define a range based on the result of the INDEX function

In Excel it is possible to write a function looking like that:
=SUM(A1:INDEX(...))
Where the end of the range of the data to sum is dynamically defined by the result of the INDEX function.
The ...

**0**

votes

**1**answer

65 views

### How can I do this in spreadsheets?

Let's say you have a table like this:
| A | B | C |
-------------------------------------
1| sex | age | answer q1 |
-------------------------------------
2| ...

**0**

votes

**1**answer

170 views

### Decimating rows in spreadsheet

Is there such an option to preserve only every 10th row in my spreadsheet? It can be Excel or Calc. Quality standards want some noise to be added.

**0**

votes

**1**answer

64 views

### Excel: Copy identical data sorted by date-time to future dates

I apologize in advance if this has been answered before but I couldn't find anything using similar wording to my question.
I have an Excel sheet of one year of data, with a value for every 15 ...

**0**

votes

**0**answers

30 views

### how can I merge in master record details to each row in excel or openoffice?

Say I have sheet 1 with:
company1 90230 CA
company2 80014 CO
company3 15090 PA
And sheet 2 with:
company1 Bob Smith
company1 Sue Smith
company3 John Doe
How can I produce sheet 3 with:
company1 ...

**0**

votes

**0**answers

76 views

### Using SQL to join spreadsheets in excel

Based on the explanation here:
How do I join two worksheets in Excel as I would in SQL?
I tried to join two excel sheets from different files into the same sheet.
However, I keep getting this error ...

**0**

votes

**0**answers

56 views

### Indirect lookup across spreadsheets

I have a spreadsheet that has information about all products for every week of the year.
Currently I have a second spreadsheet that is setup to look at the first one for each field (currently has 52 ...

**0**

votes

**0**answers

40 views

### Don't want to include blank rows in Excel table

I have a table in excel which contains the following columns:
Brands: Cell B
Open Closed: Cell C
Case Number: Cell E
Case Summary: Cell G
At the moment these are the following formulas I am using ...

**-1**

votes

**1**answer

100 views

### How to get data from separate worksheets displayed in a single separate worksheet

I am working on a spreadsheet in Microsoft excel 2010. In the spreadsheet I have 3 worksheets. These are known as:
1st
2nd
Cases
Now in the 1st and 2nd Worksheets, there is a table at the bottom ...

**0**

votes

**1**answer

63 views

### Are spreadsheet programs inherently unsuitable for “one row=one case” data?

Often when I'm working with large data sets, I structure the data in a way where every row equals one specific case. For example, in a psychological experiment, I input the data so that all data ...

**1**

vote

**3**answers

62 views

### Collect Row # of Matching Elements in Excel

I'm trying to collect the row numbers that match a certain value in multiple columns of an excel worksheet. The behavior I'm looking for reflects the table below:
|---|---------|---------|---------|
...

**0**

votes

**1**answer

975 views

### Excel Spreadsheets: If A:A does not equal C:C, how do i list columns A, B and C somewhere else?

I have an issue with referencing an excel spreadsheet:
I have data in columns A and C that's (mostly) equal, I want to isolate and create a separate list for the rows that are not equal.
For ...

**0**

votes

**0**answers

122 views

### How can I create a matrix chart with Excel 2010?

I want to create a chart where, if the value of a cell matches the criteria of both its row and column, I can mark it with a cross.
I could just type an 'x' into the cell, but I would like to find ...

**2**

votes

**1**answer

1k views

### Split Text into Columns Function in Excel

I have an excel spreadsheet with rows of data as shown below. There is a code with the product name and then a number.
QA32 Product One (Large) 23
AZ63 Product Two 96
PR65 Product Three 149
How do ...

**0**

votes

**1**answer

64 views

### Excel: How to efficiently check whether a selected cell is referenced in any other cell

I want to check whether a selected cell ( say A1) is referenced in any other cell in the sheet Iâ€™m working in? Is there a similar tool that shows you arrows from the selected formula to referenced ...

**1**

vote

**1**answer

85 views

### excel: convert transaction list to balance

If I have transcation data like this: (date,spend,balance)
2013-01-01, ,$60
2013-01-03,-$10,$50
2013-01-04,-$10,$40
2013-01-04,-$10,$30
2013-01-06,+$20,$50
How can I convert it to a list of ...

**0**

votes

**2**answers

74 views

### Excel/Spreadsheet - formula for last value in a row?

I'm trying to forecast increasing vendor costs in a spreadsheet.
My sheet looks something like this
col | A | B | C | D | E | F
vendor | 2013-09 | ...

**0**

votes

**2**answers

50 views

### Excel Equations for Spreadsheet

I have a excel spreadsheet, and while I like to think of myself as quite the excel wizard, this one has me stumped, it's probably something ridiculous but I really can't get it too work. I have a ...

**0**

votes

**2**answers

287 views

### Merging multiple versions of same excel spreadsheet

So here's the situation:
I have multiple versions of the same spreadsheet-- each one has the exact same row and column labels.
The difference between any two given spreadsheets is that data in one ...

**0**

votes

**2**answers

2k views

### =if() function is not working like it should be

I am trying to use an IF function in a formula in MS Excel 2013, but every time the IF function ignores the condition I wrote and goes to the true value. I checked my IF statement over and over, and I ...

**2**

votes

**2**answers

4k views

### Dynamically filtering data before importing from SQL Server in Excel

I'm trying to figure out whether there is a way to filter the data from an SQL Server connection before it is imported into Excel. The initial import doesn't matter (when the connection is set up), ...

**0**

votes

**1**answer

40 views

### Excel/Calc: Pivot table with (almost) identical row: how to identify them?

I need to examine via pivot a datasource from a sheet. This datasource sheet is something like this:
| Field 1 | Field 1 | Field 3 |
| AAAA | BBBB | CCCC |
| DDDD | EEEE | FFFF |
| GGGG ...

**0**

votes

**1**answer

2k views

### How do I add values in column B if column A contains the same employee surname more than once?

State of Data: I have column A which has names of employes and column B has number of hours. How do I add the hours if column A contains same employee surname more than once?
I have been using what I ...

**0**

votes

**1**answer

145 views

### Vlookup not working as expected for soccer data

i have a vlookup function that is supposed to give me some data from another worksheet. the worksheet contains soccer data, specifically about the european cups of the past 3 years (9-10, 10-11,11-12, ...

**2**

votes

**2**answers

89 views

### Why is this simple Excel calculation not netting Zero?

It's supposed to be zero but for some reason the result produces a peculiar series of digits at the end.
Also, here's the .xlsx of it: http://83.212.111.36/Book1.xlsx

**0**

votes

**2**answers

138 views

### How do I add ROUND function to formula

I have following formula, and need it to round to two decimal places
=IF(ISBLANK(N2),"",10/(N-1))
How do I do this?

**1**

vote

**1**answer

2k views

### How do I calculate the total difference between two columns of figures in Google spreadsheet/Excel?

Usually I would just calculate the difference of each row like this: =B1-A1
Then I would sum up the values of the column like this =SUM(C1:C10) and get my desired value.
I don't want the C-column. ...

**0**

votes

**1**answer

181 views

### Split a file with macro in excel

I know there are 2 similar questions.
I have a very large Excel file separated in sections by 3 blanks lines.
I was wondering if there was a way to split the spreadsheet into other every time there is ...

**0**

votes

**1**answer

24 views

### Excel 2007 removing entries which have data in two columns which may not match exactly

I have an Excel spreadsheet with over 10,000 entries. This spreadsheet contains two columns of dates, and I need to select only those entries where the dates do NOT match in the two columns.
The ...

**0**

votes

**1**answer

95 views

### Paste from text editor to spreadsheet keeping CR in one cell

I have tried this in Notepad and Notepad++, but can't get it to work. What I want to do is close to the opposite of this post: How to copy multi-line text from Excel without quotes? I want to paste ...

**0**

votes

**3**answers

1k views

### How to change the hh:mm:ss format in spreadsheets

Currently, I have a data set which is "mm:ss" and needs to stay / be calculated that way.
The problem is, Microsoft Excel, Google Spreadsheets and OpenCalc all interpret "mm:ss" as "hh:mm" and to add ...

**0**

votes

**1**answer

2k views

### How do I split single cell contents into multiple columns without seperators?

I have an excel spreadsheet that has the following:
Cell A1 ABCD 1234
I would like to split this to be
CELL A1: ABCD
CELL B1: A
CELL C1: B
CELL D1: C
CELL E1: D
I tried using the ...

**2**

votes

**1**answer

1k views

### Excel 2007 - changes on one sheet affecting other (without cell references)

Some strange behaviour I've encountered twice in Excel is that changes made to one sheet would be duplicated on another sheet in the same workbook. The first time, I typed values into a few cells on ...

**1**

vote

**1**answer

446 views

### Lookup the nearest value in a column?

I have a column (A) containing numbers between 0-200. By comparing the value of A against the values of C, I want to pick the nearest cell and thereby return the value of D.
So, if A is 160 I want to ...

**2**

votes

**0**answers

102 views

### Merging CSVs with some common columns (though columns are in different places)?

I'm looking to merge CSVs that have common columns, but the columns aren't always necessarily in the same place. The CSVs do have a header row. I just want to try to get the data appended to the ...

**0**

votes

**0**answers

86 views

### Place multiple columns onto one line [duplicate]

Let's say I have a table in a spreadsheet that works like a calendar:
Jan Fev Mar ...
1 5 7 1
2 3 4 9
3 8 3 1
4 2 9 0
5 2 1 2
...
And so on...
I need to make a chart ...

**0**

votes

**2**answers

331 views

### Merging 2 spreadsheets on Excel 2010

I was wondering if it was possible to merge data from 2 different spreadsheets together.
I'm looking at at world development indicators, so I have 1 spreadsheet which has human development index ...