**0**

votes

**1**answer

10 views

### Excel 2013 match values in two workbooks and merge one column

I'm running Excel 2013 and I have two spreadsheets open. The first, sheet1, has two columns and 7k rows the columns are:
A B
ID Description
58749651 a ...

**0**

votes

**0**answers

7 views

### Can Excel automatically create an x-axis range?

I'm doing a basic financial analysis with Excel. The gist of it is I have an input parameter (discount rate) plus a bunch of static data that gets fed into the =NPV(rate, x1...x_i) function. I would ...

**0**

votes

**2**answers

15 views

### How can I assign Cell Part as Variable?

I want to set a number in a cell to be a variable yet still keep text in it. That way it can be added up later using that variable.
I want it to say something like
Justicar Aatrox: 975
And ...

**0**

votes

**0**answers

19 views

### Add content from cell in sheet1 to cell in sheet2 when cell in sheet1 is found dynamically [on hold]

Reworded for clarity per site request 1
How do you find a value in a list on sheet1, get the value in the column to the right of it and enter it into a cell in sheet 2, then add a number to it, then ...

**0**

votes

**0**answers

14 views

### Excel: making a chart evaluating two binary conditions

I have several sets of data in binary text form: them/us, win/loss, up/down. A row might look like
Them | Them | Up | Win
I'd like to make a chart evaluating this data. Ideally, I'd like a chart ...

**1**

vote

**1**answer

15 views

### Can Excel Solver solve with this equation?

I’m buying some food, and want the most calories I can get for my money.
I have a budget of $12.00. There are 3 food groups, and I need to pick 2 items from each of those groups. There is also a ...

**0**

votes

**0**answers

7 views

### Normalizing imported date values and formats

I am importing data into Google Sheets and having difficulty figuring out how to fix and normalize my date cells which are being incorrectly interpreted.
In Google Sheets, when you type in a number ...

**0**

votes

**1**answer

13 views

### EXCEL - How to use two cells for input and output at the same time

I have 3 cells, VALUE, DOWNPAYMENT, DOWNPAYMENT %.
The 3rd cell "DOWNPAYMENT %" calculates the percentage of "DOWNPAYMENT" over "VALUE"
Is there a way for the user to have the function to input a ...

**0**

votes

**0**answers

9 views

### Combining worksheets into worksheet

I have Jan as sheet 1, Feb as sheet 2 to Dec as sheet 12. I want to combine these sheets such that, I would have on one sheet the data in Jan column Feb column Mar to Dec.

**0**

votes

**1**answer

11 views

### How do I change the DATA TYPE of a cell or group of cells?

I have a large spreadsheet of data which stubbornly will not change data type. when I run the type() formula on a cell, it returns the value 1, and it will not change no matter what I have tried.
...

**0**

votes

**1**answer

14 views

### apply conditional formatting to a cell when it matches the text in another column on another worksheet

I have a list of accounts in column a of sheet one.
I have a sublist of the same accounts in column a of sheet two.
If the account name in column a of sheet 1 matches an account name in column a of ...

**-1**

votes

**0**answers

6 views

### EXCEL - Build table with variable number of columns based on another data table

Is it possible to build a table with variable number of columns based on another table?
Example:
Enter number of regions: 3
up pops 3 regions named A, B, C
Enter number of segments for A: 2
...

**2**

votes

**1**answer

7 views

### Excel: filter a column by more than two values (“ends with”)

This is related to another (answered) question. At:
Excel: filter a column by more than two values?
There is an answer for how to filter for cells equal to a set of values with more than two ...

**1**

vote

**1**answer

12 views

### Totaling cells over multiple tabs perhaps NOT in the same position, but with same name

I have an excel document with different tabs for each month that has totals paid from individuals. Not all months have the same individuals, as some are added or removed. Is there a way to make a ...

**0**

votes

**0**answers

19 views

### Split Text String VBA [on hold]

I need to split some text in Excel. I need to split the data but I cannot just use white space because I do not want to split some of the data (e.g., name and address). Is there a way to split based ...

**0**

votes

**0**answers

17 views

### Copy multiple lines from Excel to Firefox

I would like to copy multiple cells from Excel to Firefox, and I am wondering if this is possible?
For example, a website contains fields such as: Address, City, Postal Code, etc. below one another. ...

**0**

votes

**1**answer

23 views

### Excel Scatterplot Graph

How would I put on set of data on the x axis and the other on the y in Excel?
Meaning suppose I had 5 people rate two different films on a scale of 10 and I organized my results like this:
Person ...

**0**

votes

**0**answers

18 views

### In a Pivot Table, how do you calculate the percentage of one value to another value?

I have a pivot based on raw data where each line is a person and their characteristics.
What I'd want to achieve:
I'd like the percentage of a value depending on various subgroups and locations.
I ...

**0**

votes

**0**answers

8 views

### Update links to another excel workbooks

I have a excel work books that I use VBA programmed macros to open serval another WB's. In the main WB I have a lot fomulas that is linked to the another WB's. After open all files, I still have ...

**0**

votes

**1**answer

22 views

### Excel formula - date comparison

I'm trying to construct an Excel formula to compare the date in column A to the date in column B, tells me YES if they are the same date, tells me NO if they are different dates, then if NO tells me ...

**0**

votes

**0**answers

14 views

### Excell 2013 Calculating across Multiple Sheets number of fields

I am trying to work out the total number of fields across multiple sheets to arrive at the total number of new members each month.
Some months have little as 50 others as much as 250+.
I thought I ...

**0**

votes

**0**answers

29 views

### Combining an IF statement with a dropdown list

Column 1 has a drop down list with the following selections
Cash
Check
Deposit/Refund
I need for column 2 to say "Cash" if it's selected, "Check" if it's selected, but then I need it to have ...

**0**

votes

**2**answers

17 views

### Defining Variables in Excel

I have two lists of data, x and y, one in a row one in a column. I would like to populate a chart of rows and columns with a complex formula that is the same for each chart point, the only difference ...

**0**

votes

**0**answers

11 views

### Multiple Contacts for each account

I'm trying to compile the contact names associated with each account. I need the accounts to be in a list and then I need each contact to exist in a column, like so:
Customer A | Jim Dandy | Turd ...

**-1**

votes

**0**answers

20 views

### How do I get the data in a cell of the last column of a row? [migrated]

I'm using Google Sheets.
Every week I add a column with new data, and I need the data from the latest column copied into another sheet. The formula needs to pull the cell of the last column in the ...

**2**

votes

**3**answers

7 views

### How do I make a range of cells behave like a simple multi-line notepad?

I have a spreadsheet on which I have a range of cells that I need to behave like a simple notepad. It looks like this (range is inside the red box):
This sheet will potentially be edited several ...

**1**

vote

**2**answers

13 views

### How to create a pivot table on a multiple answer field?

I am keying some data and one question from the data set supports multiple answers. As best I can tell, I have the choice of keying this as a delimited column, e.g.
Answer1
------
A
A,B
C
B,D
Or, I ...

**0**

votes

**1**answer

14 views

### Excel formatting: how to format time periods?

I would like to format a time period like:
10:00 - 16:00
How do I?
And can I do it without dates?

**0**

votes

**0**answers

5 views

### Which ODBC connection properties have higher priority ?

I take data from PostgreSQL via ODBC and put the data in excel worksheet. For this I use VBA which makes a query table. In the VBA script I specify a connection string which contains some ODBC ...

**-2**

votes

**3**answers

16 views

### How do i apply conditional formating that is specific for each row?

In my worksheet I would like to apply some conditional formatting that alerts me if the following is true:
IF (len(J7) + len(h14) + len(i14) > 256) = TRUE: apply some formatting on I14.
IF ...

**1**

vote

**2**answers

16 views

### Combobox in Excel relative to other combobox

Hi have a table similar to this one
+--------+------+
| Family | Type |
+--------+------+
| | dog |
+ Canine +------+
| | fox |
+--------+------+
| | Lion |
+ +------+
| ...

**0**

votes

**0**answers

14 views

### Massive XML Import in Excel in batch mode

I have created an XML map in Excel 2010 and I can import hundreds of XML files at once in an Excel sheet.
However I would like to automate this, i.e. import new XML files that reside in a directory ...

**0**

votes

**0**answers

19 views

### In excel shared workbook can you insert data and not replace on conflict?

I have 2 users that asked for a shared excel workbook a while back.
Now after the holidays they complain that the workbook creates conflicts and that this issue never happened before. The file just ...

**0**

votes

**1**answer

15 views

### How do i get only the “dd” from a date cell?

I have a list of dates shown like this "1/1/2015" and/or "23/12/2015".
I would like to place a function in another column, in which I will have only the "dd" value from the date.
ex. for 1/1/2015 I ...

**3**

votes

**3**answers

56 views

### How to increment string like AA to AB?

I have strings in Excel like AA or XA.
I need to increment them like this:
For AA in cell A1, it will be AB in cell B1, AC in cell B2 and so on.
For XA in cell A1, it will be XB in cell B1, XC in ...

**1**

vote

**1**answer

16 views

### Get the cell number from double clicking on it and put it into another formula

As part of my ICT work we need to create a battleship game and one way I was thinking of doing it was using
=IF(ISNUMBER(SEARCH("*x*",C3)),"HIT","MISS")
to check if that cell contains x but ...

**0**

votes

**2**answers

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

**-1**

votes

**0**answers

18 views

### Excell move row content to collum based on contect [on hold]

I have the follow data in Excel from text file:
HEADER 1
a
b
c
Header 2
A
B
Header 3
A
B
C
I do want to have it like this:
Header 1 A B C
Header 2 A B
Header 3 A B C
How can I do this?

**0**

votes

**1**answer

22 views

### Problems opening Excel attachments from Outlook

I'm seeing issues with Excel attachments in Outlook 2013; Trying to preview in Outlook gives error:
The file cannot be previewed because of an error with the following previewer:
Microsoft ...

**0**

votes

**0**answers

13 views

### VBA code to remove spaces when pasting to Notepad

I need the tabs between the words and values removed when pasting data to Notepad (from copying from Excel). I already have the vba code to open Notepad and paste, but only to paste with the tabs ...

**-1**

votes

**1**answer

11 views

### Excel macro to group rows based on a cell value

I have a hierarchical list of items in an Excel worksheet and want to create a macro to group each row based on a cell value that gives the level of indention. The data looks like this:
Index Level ...

**2**

votes

**1**answer

19 views

### Adding up amounts in a column for every non-blank entry in another column

I'm having a bit of trouble coming up with a formula to do the following. Say I have a sheet like so:
X 100 1000
200
200
500
Y 400 1250
400
300
150
Z 430 910
330
...

**0**

votes

**0**answers

20 views

### Excel 2013 keeps removing commas from CSV at save

I'm working with data exports in CSV format. Excel originally opens the files correctly. However, I've been merging in some missing data that my original queries missed (adding four rows of additional ...

**0**

votes

**1**answer

23 views

### Referencing a row with blank cells inbetween and returning results from another row without blank cells inbetween

I have a row that with cells spaced out evenly between eachother. I would like every 8th cell in that row to reference a cell in another sheet where there are no spaces between cells. I have a lot of ...

**0**

votes

**1**answer

29 views

### How can I use INDEX MATCH formula with two horizontal parameters?

Not sure if anyone can help me but thought I'd give it a shot...
I'm trying to create a formula to retrieve information from a data sheet. The data sheet contains a significant amount of information, ...

**-1**

votes

**1**answer

13 views

### I want to set up Excel Macro IF ShowLevels to toggle. [on hold]

I'm trying to get a button to toggle between expanding and collapsing groups. I'm new at this, and I'd like to get it working.
This is what I have:
If ActiveSheet.Outline.ShowLevels(RowLevels:=1) ...

**0**

votes

**1**answer

14 views

### Filter a pivot table based on the values in specific columns

I have a pivot table where there are multiple column labels:
group
subgroup
subsubgroup
status
The last label, status, has only two possible values, ACTIVE and DORMANT. I need to show only those ...

**0**

votes

**1**answer

20 views

### Excel - Cut/Copy and paste cell to cell

Every day I need to do the following 70 times by hand:
+ Cell B1 > Cut (copy) everything up to BEFORE the last space, then add it to cell A1
+ Move to B2 > Cut (copy) everything up to BEFORE the last ...

**0**

votes

**1**answer

40 views

### How to increment cell references by 7 rows for each row dragged in Excel

In Excel 2007 and Google Sheets, I'm trying to drag a formula to populate cells in a column, but I need each successive row to have the cell references incremented by seven rows. For example, drag ...

**0**

votes

**1**answer

18 views

### How to filter out letters and pair the same numbers?

I have an Excel spreadsheet with columns. The columns have numbers with varying letters like b 123 and b123.
How can I delete the b's just to have the numbers? I want to focus only to the numbers so ...