# Tagged Questions

**0**

votes

**0**answers

13 views

### Excel Table Copy Wrong Formula with Newly Inserted Rows?

I am trying to create a simple spreadsheet to track costs. I have a total of five columns with different categories, two of which have formulas. I wanted to be able to insert a new row into the ...

**2**

votes

**1**answer

27 views

### Excel Help: How to scan a row and return the value of the first cell in that column

I have a matrix of numbers and the matrix has column header -- say like this:
a b c d e f
0 0 0 1 0 0
0 0 1 0 0 0
What I want to do is to search for each row for the element 1 and return its ...

**0**

votes

**2**answers

24 views

### How to write the cells in rows one under the other in columns?

I have a list of name, company, phone number, address and e-mail. But each name who works at the same company is in the same cell. Of course, the other informations of those names like phone number, ...

**1**

vote

**1**answer

16 views

### Excel Conditional Formatting Colour Scales highlight group of cells when another cell is a certain value

So I have a document that has 2 drop downs with the first acting as a currency selection and the other acting as a discount selection (0% - 50%). Basically whenever I select from the dropdowns the ...

**-1**

votes

**1**answer

38 views

### How to write Excel macro to copy selected row of data between two sheets?

I'm not really experienced in the whole VBA area, i get how macros work but this is just out of my reach.
Basically as i stated in the title i need to write a macro that will copy the selected row or ...

**0**

votes

**2**answers

16 views

### In Excel 2010, how do you format text to string without having to open and enter on every single cell?

I was given an Excel document.
In the data there is a column of dates formatted 5/20/2014. Half the data in that column is formatted as a date. The other half is formatted as text. When I try and ...

**0**

votes

**1**answer

24 views

### Creating GANTT Chart (Timeline) From Start Time and Duration

I am attempting to create a daily graphical timeline from start times and duration. I have three columns: Program Name, Start Time and Duration. The data looks something like this...
The desired ...

**2**

votes

**1**answer

22 views

### With PowerPivots, find items that appear *only* in one category

With PowerPivot, how do I find items only in one category? Here's an example:
item category number
obera f6 7
artois f7 2
obera f7 3
ella f6 9
If ...

**2**

votes

**0**answers

28 views

### excel 2010 not inheriting regional settings in windows 8.1

Wondering if anyone else is having this issue. In regional settings on Windows 8.1 i have display negative numbers set to display in accounting mode. eg - (1.0) instead of -1.0
Excel should be ...

**-1**

votes

**0**answers

21 views

### 2 Excel Tabs: Find matching values in column As and match the B columns based on A. (Only one tab has B filled)

I have two tabs in excel; one working with technologies and one with patents on those technologies. The technology tab has each tech ID in column A, and the patent tab has the same tech ID numbers but ...

**1**

vote

**3**answers

17 views

### Using OR condition in SUMPRODUCT

I have three columns of data - a sum column (A) and then the two columns that form the sum (B and C). Sometimes, just one of the B and C columns is filled in; occasionally the B and C columns are both ...

**0**

votes

**1**answer

18 views

### Text function in Excel isn't formatting year

I've got a problem with the text function in Excel (2007).
It doesn't format the year, it just states yyyy instead of e.g. 2014.
If I have a cell with 23-7-2014 and use the formula ...

**0**

votes

**3**answers

32 views

### Compare 2 columns in Excel and copy data from 3rd column

I'm trying to compare 2 columns that don't have the same size (one has 205 entries, the other 440) and if the data from column B matches the data in column A, the data from column C must be copied in ...

**0**

votes

**1**answer

15 views

### CSV compabtility issue in excel

I download a .csv from database and use the file to generate a PDF using a PDF conversion service. However, for specific files, the conversion fails and the request times out. I checked the file type ...

**0**

votes

**0**answers

24 views

### Excel crashes everytime when saving a specific file

The instant I try saving a particular excel document excel will crash.
How do I solve this problem, I've tried saving as different excel formats but I got the same result, except for when I saved it ...

**0**

votes

**2**answers

64 views

### Calculating time difference between two date/times from two columns in Excel

I have 5 columns: Start Date, Start Time, End Date, End Time and Duration. I need to calculate the duration between the Start Date/Start Time and the End Date/End Time. I tried just subtracting the ...

**0**

votes

**3**answers

41 views

### In Excel PivotTables, how do I show items that occur in one category but not another?

Simplified version of my data:
item category number
apples fruit 7
orange fruit 2
tomato fruit 3
tomato vege 9
zuchini vege 2
tomato vege 17
...

**0**

votes

**1**answer

26 views

### How can I find all cells in Excel with a particular value and get the sum of all those cells' dependents?

I am trying to find the total number of screws, nuts, washers, etc for a very large assembly. For each part in the assembly, I have the number of each type of hardware. I would like to find the total ...

**0**

votes

**1**answer

17 views

### Excel 2010- long number corruption

I have a set of data, received in .csv format, in which I have a set of long UPRN numbers. I am involved in data matching processes related to new IER voting regulations.
When I open the .csv file the ...

**1**

vote

**1**answer

15 views

### How to remove one column of a calculated item in Pivot?

I have two columns. One with data from this year and the other with data from previous year. I now have added a calculated item in Pivot to display the % delta of these two years. Now when doing this ...

**0**

votes

**0**answers

17 views

### How to Group and Layout Pivot Table when Values is in the Row Labels Field?

I'm attempting to present large amounts of data in a report using a Pivot Table to allow for dynamic filtering/categorization. The data in the table is of the form:
Year Month Category Region ...

**0**

votes

**2**answers

37 views

### Excel bar graph, easy idea, hard implementation apparently

I want to make a graph like this, but I can't seem to make it correctly:
Data: 4, 2, 3, 4, 1, 3, 3, 2, 3, 4, 2, 3, 2, 1
Three elements: Y-axis potential values (1-4 or worst, below average, above ...

**1**

vote

**2**answers

38 views

### Excel: how to permanently apply conditional formatting to the whole spreadsheet?

I have the following annoying problem with Excel 2010. I use Conditional formatting to apply bold formatting to each line of the spreadsheet that meets a condition expressed by a formula. In the ...

**0**

votes

**0**answers

15 views

### VBA Compare columns on two diff worksheets, find in 2nd and group on 2nd worksheet

Excel 2010
Hi. I have a 6,000 line spreadsheet and need to group the lines, based on identified roll up points in another spreadsheet (150 roll up points). I want to be able to see the summary ...

**2**

votes

**1**answer

27 views

### In Excel, can you create a cell that updates the number of another cell without having to hold the inputted value?

Since I can't create a form using VB or ACCESS here at work, I'm trying to figure out if I can use a cell as a makeshift form. I want to label one cell "Enter New Order Quantity." Next to it(next ...

**0**

votes

**2**answers

53 views

### Excel how to divide a time period into equal time periods

I would like to find a way of dividing a period of time into 4 hourly time zones. I.e. if a piece of equipment is unavailable from 0900hrs to 1700 hrs that is 8 hours but I need to show this in 4 ...

**-1**

votes

**2**answers

34 views

### Is there a formula to change the value of a call, depending on selection from drop down list?

I am trying to create a prices spredsheet.
I need one column where you can choose a product from a drop down list
The next column you enter the amount of units required
The next column (the tricky ...

**0**

votes

**3**answers

27 views

### How can I modify a lot of values easily in Excel?

I have a big file of numerical data with 600 columns and 4000 rows. I would like to be able to change the data of about 3/4 of the columns by multiplying them with 1.02. For example, let's say I have ...

**0**

votes

**0**answers

13 views

### Excel 2010 separating registers with the same name on dynamic tables

I have a series of registers in the form of:
Name Value Other Field
AAA 112 …
AAA 8127 …
AAA … …
BBB … …
BBB … …
CCC … …
… … …
...

**0**

votes

**0**answers

10 views

### Excel workbook contains a userform which opens up black on 8.1 office 2010

The userform within the worksheet opens black on windows 8.1 office 2010, yet it opens fine on XP with office 2010.
It's a excel 79 to 2003 xls file.
We checked trust centre on 8.1 but no joy, ...

**0**

votes

**1**answer

21 views

### Embedding hundreds, even thousands of pdf files in excel?

Would it be possible and efficient to insert - object about 1000 PDF files to an excel document, or will it start running extremely slow/other problems?

**0**

votes

**0**answers

15 views

### Hyperlinks to documents have changed

I have several hundred links to documents in a folder on a network drive embedded in my excel so that if I click the link, the pdf document opens.
As of today, a lot of these documents do not open ...

**0**

votes

**1**answer

15 views

### Excel 2010 “sending the command to the program” error

Multiple domain users receive the following Excel 2010 (32-bit edition) error occasionally when opening random XLS files.
There was a problem sending the command to the program
...

**0**

votes

**0**answers

22 views

### EXCEL: I have a column of single-word strings and would like to see if any of these strings are contained in a column of multi-word cells

Example:
In column A I have a list of words "Apple, Banana, Orange, etc." each in their own cell.
In column C I have a column of multi-word strings like C1="I ate an apple", C2="Bananas are gross" ...

**0**

votes

**0**answers

16 views

### New items in drop down validation menu aren't showing in Excel 2010

In Excel version 14.4.2, I have a drop down validation menu and I have added more cells with new menu items.
However, these new items are not showing on the drop down menu on all the cells of the ...

**1**

vote

**0**answers

23 views

### How to recover some missing data in Excel?

I have two versions of an Excel file, one from before I did a lot of work on it and one from after. The after-version, despite a lot of productive work, also includes the results of a catastrophic ...

**1**

vote

**1**answer

56 views

### Excel: Different background colors on condition

The problem
I have a Excel sheet that contains a status column.
Number Status Name
-------------------------------------
1 not implemented feature 1
2 completed ...

**1**

vote

**1**answer

31 views

### How can retrieve cell address that match criteria?

In column A are various products (A2:A100), in column B are different numbers (B2:B100).
In cell G2 is criteria from column A.
With the formula {=MAX(IF($A$2:$A$100=G2;$B$2:$B$100))}, I can find ...

**1**

vote

**2**answers

27 views

### Apply VLOOKUP to multiple sheets and ignore blanks

I would like to do a VLOOKUP on multiple sheets (for which I am able to define a strict priority order) but where I want to ignore the answer when it is a blank. I have found this answer:
Apply ...

**0**

votes

**1**answer

21 views

### How to automatically delete rows that contain certain numbers in the ID column

I have a column of numbers in another workbook and I would like to use that set of numbers to delete rows in the main workbook. I will give an simplified example of what I'm talking about below. My ...

**1**

vote

**1**answer

24 views

### Unwanted space in URLS in Excel 2010

I have a list of 23000 URLs in an Excel sheet but these appear to have extra spaces in, therefore invalidating the urls.
I've tried a find and replace and excel doesn't recognise that there is an ...

**0**

votes

**1**answer

38 views

### Lookup with multiple criteria and priority

I am working with different excel files which contain a lot of data from different people. I would like to do a lookup (I know how to use the LOOKUP function) but based on multiple criteria. Let me ...

**0**

votes

**0**answers

14 views

### How to link quickly to various pdf files in Excel

I have an excel database with hundreds of products. Each products is assigned a specific security PDF sheet in a folder.
Is there a way to optimize my linking routine?
My way:
Click insert - link - ...

**0**

votes

**1**answer

29 views

### Microsoft Excel Custom Label Overlay on Line Graph

I have 2 tables identical.
One records the progression of projects as a percentage over dates until completion.
The other is a replica table but records the daily status of the projects on the ...

**0**

votes

**1**answer

25 views

### Excel Formula Issue Countif to Sumproduct

Having a nightmare at the moment with some formula's I've been asked to 'fix'. It would seem the users expected them to work with closed source spreadsheets but they don't. So they end up having to ...

**-1**

votes

**0**answers

23 views

### comparing 2 columns in excel and return the same result in a group

hi m new in excel function,
i have a problem like this. i have 2 lists of data
DATA I
NAME SCORE
----- -----
ANA 10
BUDI 20
TINA 30
DATA II
NAME SCORE
----- ...

**-1**

votes

**1**answer

23 views

### Excel formula: identifying highest weights

I need some help with the following assignment:
Task:
In the product Weight tab, you can see each product is weighted with a value per customer. Please create a Product Code for each customer based ...

**0**

votes

**1**answer

14 views

### Excel column entries modification

I have a big Excel file containing a column where I have entries of the type
A3F44
and I would like to transform them into
A3F4 - 4
in order to match them with the entries in another file. ...

**0**

votes

**1**answer

9 views

### I want a shortcut in Excel to cells I have Hyperlinked

I've built a Series of Cells which wnen concateneted = HyperLink to a remote server. Excel Wk Sheet 2010 (File name changes Daily with date function or Date User inputs)
On the same Sheet I want to ...

**0**

votes

**1**answer

22 views

### Embedded IF(OR(IF) statement

I have made a formula that basically looks for a string of text inside a cell and if it finds it puts it in another cell. I needed to check three cells so I did three separate formulas (because I'm ...