**0**

votes

**0**answers

5 views

### Updating multiple pivot tables with slicers

I have a worksheet with about 15 different pivot tables, about 80% of them with multiple slicers. I've added rows to the data source sheet, however when I try to update the data source on the pivot ...

**-1**

votes

**0**answers

10 views

### Automatic generate number series

How to create a numeric series based on an input value
For example: If you enter 3 in the number of types column, it will generate 1,2, 3 to SSiatem# column.
Then enter another number of type say 2, ...

**0**

votes

**1**answer

12 views

### How to create a numeric series based on input value in excel and repeat it for several inputs

I want to create a numeric series based on input value in Excel. For example if user type 3 in column D7, there should be a series of like 1, 2, 3 in column E7. Then continue to enter or type a ...

**-6**

votes

**0**answers

21 views

### Microsoft - Excel [on hold]

I am wondering if you are able to auto fill an order form on one sheet of document with information from several other sheets in the document. For instance, be able to type in the project name of ...

**0**

votes

**2**answers

18 views

### How do I use concatenated values as VLOOKUP lookup-value?

How do I use concatenated values as VLOOKUP lookup-value?
I have "ABC"&"-"&$B364&"-"&$A364&"-"&$E364 as a value for a cell. How do I use it as a VLOOKUP value for another cell ...

**0**

votes

**1**answer

16 views

### CSV File saving as Creo Pro Versioned File

This is an odd one, I'm saving an Excel file as a CSV file, which is the required format I have to send this data in as. However when I save the file, it shows in the Directory as a Creo Pro Versioned ...

**0**

votes

**1**answer

15 views

### Execute SQL Query with VBA and fill sheet with data

Very new to any form of code. Attempting to run a script in VBA that will pull data from an access database using SQL and put it into an excel spreadsheet. Code is similar to below. Runs clean but I ...

**0**

votes

**1**answer

11 views

### How can I set up logic to count the number of occurences in a month for a list of dates?

I have dates that look like this:
9/24/13
9/24/13
10/7/13
10/7/13
10/14/13
10/16/13
10/22/13
10/22/13
10/30/13
I need logic in a cell that will count the number of September occurrences. Then I ...

**0**

votes

**1**answer

4 views

### Formula to incorporate Highlighted text & Loop function

I'm trying to analyze over a 1000 line items,
with different information in all columns ,although certain columns might have duplicate information.
I can do conditional formatting and highlight the ...

**0**

votes

**2**answers

15 views

### Drag the cell to create an array of Roman numbers

I need to create an array of cells of roman numbers. So I placed my entry like this
cell A1: I
cell A2: II
cell A3: III
cell A4: IV
I selected the entries and dragged the corner down, hoping that ...

**0**

votes

**1**answer

15 views

### Format dates so they are split across two lines

See the dates above? I'd like to format them so they are split over two lines, as illustrated below (Note: the Oct 13 is a mistake; it should have been split as well).
In other words, between the ...

**0**

votes

**1**answer

13 views

### Office 365 Excel Online keeps on deleting a textbox

I have a number of spreadsheets on onedrive. If I open them in "excel online", then the first thing that happens is that the text box that contains the header graphic and title that is on the ...

**0**

votes

**1**answer

10 views

### Microsoft Excel 2013 on Windows 7, creating cost based on drop down values

Hi I am need of some assistance and was wondering if anyone can help me. I am creating a spreadsheet for quoting jobs on site and am stuck with a particular part.
I have a cell containing a drop down ...

**0**

votes

**2**answers

9 views

### Assign the value of a cell as a cell reference of another cell in Excel - How to?

The intention behind this query is to simplify the review of excel sheets with engineering calculations.
Let us assume that column A contains the notations. cell A1 contains "Rfa" and cell A2 ...

**0**

votes

**2**answers

18 views

### Computing time difference to fraction in excel

Consider an employee working 8 hours a day (9AM-6PM), and came in 9:25AM, had a break at 12:00 - 1:00PM and logged out at 6PM. I use a formula to get hours worked (7.58) -
...

**0**

votes

**1**answer

14 views

### selecting elements from a column in Excel

In Excel, I have three columns A2:A100, B2:B50, C2:C50. I want to do the following things:
If An (n is any number between 2 and 100) is in B2:B50 AND Bm==An for some m, then let Dn=Cm.
How can I do ...

**0**

votes

**1**answer

11 views

### Move cursor to specific cell in other worksheet

I put a value in "Sheet1" cell "J2". On running the macro I want cursor to move to "Sheet2" Column "B" and row number as per value put in "Sheet1" cell "J2". Please suggest vba code for the same. ...

**1**

vote

**2**answers

33 views

### Look up a value in a list and return ALL multiple corresponding values

The basic answer to my question is provided here: How to look up a value in a list and return multiple corresponding values. However, once the formula is entered, I need to drag down, or copy/paste ...

**-2**

votes

**1**answer

21 views

### Need an “IF” function that shows whether the difference of a simple subtraction is greater than a certain value

I have values in cells A3 and A2. I will be subtracting the value of A2 from A3. What I need is to be able to highlight or flag the result if the difference is greater than an absolute value of .01 ...

**-1**

votes

**1**answer

22 views

### How do I add two URLs into given format?

I have a excel sheet..That contains two urls sets..I need to add them into this format in another column
Col 1 Col 2
Web site A.1 Web site B.1
Web site A.2 ...

**0**

votes

**1**answer

22 views

### Use macro to email document, and CC another user

I have a spreadsheet with a macro button that forwards the document to a specific user in an email. I have been asked to now have the email send to the original recipient and CC another email address.
...

**0**

votes

**1**answer

17 views

### Excel 2013 Multiple Validation Rules

I have a 2 part problem that I am having issues with... mainly part 2. I have gotten the first part to work by itself.
1) I have a column which contains part numbers (###-#####-###). I am using data ...

**1**

vote

**1**answer

8 views

### How do I retrieve all values from a 3D range and insert into the current worksheet?

I have a series of worksheets named 1.. 50. I want the values of the 3D range '1:50'!A10 inserted into a range on the current worksheet, RawData. How do I do this?

**1**

vote

**2**answers

28 views

### Find largest number in one list and smallest number in another list to index one cell

![enter image description here][1]Is there a way to identify the highest number in a list and the lowest number in a list to index to a cell?
I have a list of players, each player has total number of ...

**0**

votes

**0**answers

10 views

### Merging Data from a Spreedsheet into an e-mail template

I'm trying to find an application of sorts to help me extract data from a spreadsheet and then display that data into an e-mail form
e.g.
Spreedsheet data.xls
Field 1 | Field 2 | Field 3
Data | ...

**-3**

votes

**0**answers

22 views

### Need Help in Excel [on hold]

NAME From To Dept Date Arrv Date
Sachin Bangalore Pune 01/08/14 08/08/14
Sachin Pune Mumbai 08/08/14 12/08/14
Sachin Mumbai Delhi 14/08/14 25/08/14
...

**-1**

votes

**0**answers

9 views

### Have Excel sheet manifest in two ways

Is there a way to have the data manifest in two ways on two different sheets? So I have the same data where perhaps I sort by date, then another sheet I sort by alphabet. Key thing though is that I ...

**0**

votes

**1**answer

20 views

### How do I stop Excel Auto Update?

I have an excel file (linked to software) of stock prices, the files gets updated prices from the software. However, I want the excel to update data only when I want (say F9). Please suggest.
I can ...

**0**

votes

**1**answer

29 views

### Group Data By Multiple Columns

I'm not sure I phrased this title correctly. Please feel welcome to offer suggested edits.
I have data formatted like so:
Token,Location,Quantity
VBD,IN,100
NN,IN,200
FD,OUT,300
VBD,OUT,300
...

**0**

votes

**1**answer

24 views

### Spreadsheets Formula Check In/CheckOut Autopopulate Data

I am working on a spreadsheet (I am doing it in Numbers since it will easily let me work on the file on my mac, iPhone, iPad and online at icloud.com)... but this is essentially also an excel question ...

**0**

votes

**1**answer

26 views

### How can I use pivot table grouping by dates incremented by a day at a time?

I have some data which has been extracted from staff timesheets which provides number of hours worked by a member of staff on a given day. I need to summarise this information grouping by days but ...

**2**

votes

**2**answers

21 views

### Indicating trends within sparklines in Excel

I have created a load of sparklines in Excel for a variety of diseases over time. However, in order to identify trends from these sparklines, it would be useful to include a little more information ...

**0**

votes

**1**answer

14 views

### Creating 2D data from a flat/1D list of spreadsheet entries

This seems like it'd be a really common operation, but I don't know the terminology or what to search for. I have a table like the following in CSV:
+------+------+------+------+
| Test | Var1 | Var2 ...

**0**

votes

**0**answers

8 views

### Change regional number format for powerpoint, but not excel

My clients (and me) are Germany-based, as such I need to use the German number format
1.000.000,00
for all client-facing documents, usually created in Powerpoint 2007.
In Excel however, I use the ...

**-5**

votes

**0**answers

24 views

### Checking cells format [on hold]

I need to check that a list of post codes has a valid format, like the following:
AA9A 9AA
A9A 9AA
A9 9AA
A99 9AA
AA9 9AA
AA99 9AA
A = letter
9 = number
How do I do that in Excel? Any ideas?

**1**

vote

**1**answer

13 views

### MS Word tables as link from Excel only shows a single line

I have a Word document that functions as a template using a linked table to an external Excel sheet.
My problem is that when i 'paste special' to insert the link, the table shows only the last line of ...

**0**

votes

**1**answer

14 views

### How do I edit a Gantt Project Bar Graph in Excel

I'm not sure how to edit a Gantt Project Bar Graph in Excel. When you first open Excel 2013 (current version I have), you can start with a template and that's exactly what I did. I selected a Gantt ...

**0**

votes

**1**answer

21 views

### Auto-fill rows from columns in another sheet?

I'm using Google Doc's Spreadsheet at the moment and I'm attempting to create the same view in another sheet.
First Sheet:
(yes I need these merged cells)
Second Sheet:
Unfortunately Google ...

**0**

votes

**1**answer

24 views

### Spreadsheet data checking columns

I am trying to separate datas from columns(A,B&C) based on datas from an index table at columns (E&F)
I need to list only those data from columns A/B/C when column B data has no corresponding ...

**-5**

votes

**0**answers

24 views

### Excel graph with 5 variables [on hold]

I'm completely new and lost with graphing multiple variables.
I was conducting an experiment whether it's easier to read the word or say the color the word is written in. For example, The word RED ...

**0**

votes

**1**answer

22 views

### =excel 2013 if function not working as it should be

For example i have 4 cells:A1, A2, A3, A4 :
A1=50
A2=10
A3=if(A1>A2,"-1","0")
A4= if(A3=-1,"ok,"not ok")
but the problem is that A4 keeps giving "not ok" ! whats wrong here?

**0**

votes

**2**answers

18 views

### Cells show formula, not formula result

We have an existing spreadsheet that has been working fine. Today we double-clicked a cell, to edit the formula, but did not change anything (we tested on other cells to check). When hitting enter, or ...

**-2**

votes

**2**answers

25 views

### How do I convert list to table in Excel 2003

I have a list:
date item name quantity
1.7.2014 A 5
1.7.2014 B 2
1.7.2014 C 10
2.7.2014 B 5
3.7.2014 A 1
...

**1**

vote

**1**answer

18 views

### IF Function and Time Subtraction

Coach:
I've got a simple time card spread sheet drawn up. My question is I would like to set a function that if a cell is less than or equal to my base, it subtracts from my base to give a total. ...

**1**

vote

**1**answer

15 views

### Office 2010 on Mac OS 10.8: Drawing a Chart

I have a simple data set and I want to make a graph for it.
Years Upper Band Lower Band
2010 0.73 0.63
2020 1.04 0.83
2030 1.36 1.06
2040 1.74 1.31
2050 ...

**1**

vote

**1**answer

17 views

### How do you auto update row count in a formula that yields a percentage?

How does one get a formula to auto update when a row is added when this formula is meant to yield as a percentage, which is directly linked to a pie chart? For example: my formula reads
...

**1**

vote

**2**answers

44 views

### Excel- How do I find common text values from multiple (>2) columns?

I have 9 columns of text data and need to know the common terms that are found in all nine columns (or possibly different combinations of columns). I can do 2 columns ...

**1**

vote

**3**answers

25 views

### How to remove duplicate values in col A from col B in MS Excel?

I need to remove the values from column B that exist in column A in an Excel spreadsheet. Data > Remove Duplicates doesn't seem to offer this as an option, so how else can I do this? I need to remove ...

**0**

votes

**2**answers

16 views

### How do I get Excel 2013 to recalc the used extents of a worksheet?

Using Excel 2013, how do I force a recalculation of the last used cell in the worksheet? For example, Ctrl + Shift + End selects a bunch of cells, as expected, but it also selected some blank cells.
...

**-1**

votes

**1**answer

26 views

### Automation Error Catastrophic Failure

I am trying to use excel VBA to copy some charts to Powerpoint slides using the below codes, but it shows error "Automation Error Catastrophic Failure". I can not figure out what is the problem. I am ...