# Tagged Questions

**0**

votes

**2**answers

24 views

### Excel: Applying Condittional formatting to every other row

I would like to apply a specific conditional format to every second row in my spreadsheet. In my specific case I have regression results, where the first row indicates the beta coefficient and the ...

**1**

vote

**1**answer

12 views

### Microsoft Excel lookup match without sorting data

Have a value list and need to insert points by looking up the data table. Data table has value for points in 1000 increments. Actual value that I lookup will not be rounded to 1000 so I tried using ...

**2**

votes

**1**answer

30 views

### Excel 2010 Pivot Formatting - Can't indent and wrap fields?

When working with pivot tables in Excel 2010, I want to show my pivot in compact form, with each field being indented as you move through the data, like so:
However, some of my data strings are ...

**0**

votes

**2**answers

23 views

### Find last instance of a character in string and keep anything that comes before

I have the following data and I need to get rid of the numbers. This means I will have to find that last occurence of the character " " and keep everything that comes before however I dont know how to ...

**0**

votes

**2**answers

19 views

### Excel 2010 - how to prepend a “0” to make an 8 digit number 9 digits

I'm running Excel 2010 using a output file from our database software that exports a list of our affiliate stores. The affiliate stores have a 9 digit code and a number of these codes start with "0".
...

**1**

vote

**1**answer

28 views

### How do I create a dynamically-growing graph which ignores empty tail cells?

I have a table on an Excel 2010 Worksheet 'Consolidated Data' where:
Column A is filled with arbitrary dates sorted by increasing age
Column F has numeric data relevant to this question
Row 1 is the ...

**0**

votes

**2**answers

29 views

### Graphing patient data, multiple dates, multiple patients

In Excel, is there a way to graph multiple series from one column of data? I have lab values for patients. Column A is date, column B is patient identifier, and column C contains all the lab values. ...

**0**

votes

**2**answers

27 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?
...

**1**

vote

**2**answers

21 views

### How can I stop Excel From Updating Links When Copy and Pasting Cells Linked to Other Workbooks?

Summary of the problem: I would like excel NOT to link to the spreadsheets links I'm copy and pasting until I have the entire spreadsheet setup.
Overview: I have a worksheet that acts to aggregate a ...

**1**

vote

**1**answer

34 views

### When pasting, how can I ignore hidden columns in the destination range?

I have two worksheets s1 and s2.
Data on s1 looks like:
+---+-----------+--------+------+
| | A | B | C |
+---+-----------+--------+------+
| 1 | scarecrow | tinman | lion |
...

**0**

votes

**2**answers

25 views

### Excel: DD/MM/YYYY stored as text…need to convert to Date format

I have a slight problem. It would be easier to post an image but I can't because I don't have 10 reputation. Anyway I have a column with the heading "Birth Date", and dates entered in DD/MM/YYYY ...

**2**

votes

**0**answers

38 views

### Automatic scatter plot in Excel 2010

I have two quite large data sets of which I want to plot every line in one plot.
The pattern is the following:
x-axis: Set one (Colonne 1-6)
y-axis: Set two (Colonne 1-6)
Now I want such a plot for ...

**0**

votes

**1**answer

20 views

### How to load above 2 million data from SQL Server to CSV/Excel using SSIS 2008R2 package?

How to load above 2 million data from SQL Server to CSV/Excel using SSIS 2008R2 package?
The Package needs to create new excel/csv file automatically once the first file is filled with maximum number ...

**1**

vote

**2**answers

50 views

### Excel Lookup adds double quotes to string

I'm using this formula to get value form a table
=LOOKUP(C11;Alias[A];Alias[B])
where C11 = 12354567
But when I use
=LOOKUP(LEFT(C11,7);Alias[A];Alias[B])
where C11 = 12345678, the formula does ...

**0**

votes

**1**answer

36 views

### Compare two spreadsheets in a workbook, find the differences and record the differences on the first spreadsheet

I need a way to compare two spreadsheets in a workbook, find the differences, then write those differences on the spreadsheet in sequential order in the same column below the existing numbers.
Sheet1 ...

**1**

vote

**2**answers

45 views

### Using Excel to make a grid in millimeters

Trying to figure out a way to make a grid in Excel that will print out in with spacing of mm's. Haven't figured out a way to do this yet though.
I'm doing some work with Nanoblocks (which a single ...

**1**

vote

**0**answers

29 views

### How to add custom columns to Pivot Table (similar to Grand Total)?

I have data which I pivot as Row Labels and Column Labels which gives me something like this:
And what I would like to do is add columns like Grand Total (i.e. which applies to all columns as a ...

**0**

votes

**1**answer

35 views

### How does Excel handle the h:mm:ss format?

I have the number 0.00082788917980126 which once converted to h:mm:ss format gives me 0:01:12, and I need to understand how as I need to perform similar formatting outside Excel, hence my question:
...

**0**

votes

**1**answer

32 views

### Defined Name to give text or date value instead of numeric value

I had been trying out Define Name in Excel. I defined a name for a cell in which I would put a text or date value or I may leave it blank.
But when I use this defined name in another cell, the second ...

**0**

votes

**1**answer

15 views

### Nesting multiple IFERRORS with Index and Match

I feel like a dummy. I basically need a column that says - If column a2=0 then index and match column C, if that returns an error index and match column e, else index and match column a
Current ...

**1**

vote

**2**answers

34 views

### Align Secondary Axis Origin with Primary

I am interested in aligning my secondary axis such that it lines up exactly with my primary axis.
To be more clear, I want the origins to both line up at 0 at the same place, each preserving their ...

**0**

votes

**1**answer

20 views

### Excel, how to subtract time to span before midnight

I am trying to subtract hours to a time that is close to midnight, but excel is outputting all hash (#) symbols complaining of the operation.
Adding time is easy and possible, as described by this ...

**2**

votes

**1**answer

40 views

### How to Make a PivotTable out of “hierarchical” Excel spreadsheet data

I would like to create a PivotTable out of "hierarchical" data contained in an Excel 2010 worksheet. The data is hierarchical in the sense of a parent/child relationship in a database where, ...

**0**

votes

**1**answer

42 views

### Excel: How to clear all renamed PivotTable labels

When using PivotTables in Excel, it's often useful to overtype certain PivotTable labels with new names.
If you have a long list of items you've relabelled, it can be easy to lose track of what the ...

**0**

votes

**1**answer

27 views

### Nesting the IF Function in Excel when there may be #Value! errors in the target cell

I'm trying to get some help to change a formula:
=IF(S4>8000,3,IF(S4>6000,2,IF(S4>4000,1,IF(S4<4000,0))))
So that it returns a value of 1.5 if the target cell contains an error value. ...

**0**

votes

**3**answers

36 views

### In Excel replacing a column with another column

I have a list of Variables in Column A > list of items
another list of variables in Column B > with corresponding Item Codes for >> column A
And in Column C > I have list of item codes randomly ...

**1**

vote

**1**answer

45 views

### Excel - Lookup to match varying criteria

I have a list of poles, some with more than one test result. I want to find the latest test result for each pole and then return the result. As we know, VLOOKUP only finds the first. I don't want ...

**0**

votes

**2**answers

28 views

### How do I limit Entry in a range of cells to be numeric (whole #) max length 9 chracters, no leading zeros and no duplicates?

How do I limit Entry in a range of cells to be numeric (whole #) max length 9 chracters, no leading zeros and no duplicates?
I also want to limit another range of cells to maximum 24 alpha and "-" ...

**0**

votes

**2**answers

31 views

### How to embed or link a text file in Excel?

I have a text file containing a memory dump from an embedded system, which I update after every run (the file is formatted in the Motorola SREC format, but this is not too important). I am using Excel ...

**0**

votes

**1**answer

23 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

**1**answer

34 views

### excel - if value grater than, use that value

I am having problems with my excel function. I want to:
if value 1 is greater than value 2, then write value 1 in a cell. If value 2 is greater than value 1, then write value 2 in the cell.
...

**0**

votes

**3**answers

46 views

### Excel freezes when copying a few cells multiple times

I have had a frequent problem in Excel 2013 and Excel 2010 on several different computers, where Excel would freeze for 10-20 seconds when I copied a few cells into 3 or more locations.
I frequently ...

**1**

vote

**1**answer

22 views

### Stubborn “Read-only” notification in Excel won't go away

I have a table in Excel that includes a set of cells copy-pasted from a TFS bulk edit worksheet. I'm usually careful and paste values only so that I don't get any of the data validation, etc. I'd like ...

**1**

vote

**1**answer

24 views

### Editing Excel cells with a different format while keeping the current format

Say I have cells in Excel with text in it in subscript format. When I want to add more text in the cells, it will appear in subscript format. To make them appear in normal format, I have to start ...

**2**

votes

**0**answers

26 views

### Excel 2010 clips top edge of content

In Excel 2010 on 2 different computers, the same file opens differently as follows:
Correct:
Incorrect:
The correct one is displayed first. This is a file exported from a SQL Server Report; when ...

**1**

vote

**3**answers

34 views

### Hiding an Excel formula untill the fields before are completed

I'm going crazy here trying to sort the below out.
I am trying to hide the "0" (J9) and the "Yes" (K9) until the dates have been filled in
The Formula in J9 is =DATEDIF(H13,I13,"d")
The Formula in ...

**2**

votes

**5**answers

66 views

### Sum over every second cell if neighboring cell is not empty

I have created a timesheet in Excel to keep track of my working times. It all works pretty good, but I have one small problem.
My sheet has the following layout (In=started working, Out=stopped ...

**2**

votes

**3**answers

61 views

### How can I change the number format of a cell in a database-imported table?

I have a sheet that looks like this -
A | B | C
----------------------
2 | Okay | 0
3 | Not okay | 0
Cell C3 has the green error pointer and says "The number in ...

**0**

votes

**2**answers

38 views

### Excel countifs criteria neither this nor that

Im trying to make a criteria for COUNTIFS such that the value of the cell is neither "pass" nor "fail" nor blank. How can I do this? I dont think "<>pass<>fail<>*" works
Since someone wanted ...

**0**

votes

**1**answer

35 views

### Excel count all rows that contain certain values for certain fields

I have a sheet with a couple hundred rows. Each row has an 'owner' and a pass/fail field. I am making a second sheet that has statistics for the users. So for each user it will count the number of ...

**0**

votes

**1**answer

22 views

### How to put conditional formatting in a cell from another excel worksheet

its hard to describe how i want, im not really familiar with excel condition terms but it is basically just like this
Worksheet= Dr. castro patient consultations
A B C D E
...

**0**

votes

**1**answer

47 views

### Can Excel's Find formula have multiple find_text criteria?

I have a list of names on a NAMES tab range A1:A100.
On another tab 'Data Export', in column A I have an export of thousands of comments where one of those names from the NAME tab can be found within ...

**0**

votes

**1**answer

33 views

### How to combine several excel workbooks into a single book

I have several, multi-sheet workbooks which I would like to combine so that I can search them all simultaneously. So, the merged workbook will contain tabs 1,2,3, of the first workbook, then tabs ...

**0**

votes

**2**answers

80 views

### Excel - column width differences in copied worksheet

I have a workbook that I created using Excel 2007. In Excel 2007 I can copy one of the worksheets to a different workbook with no problems. However, using Excel 2010 I'm getting odd behavior. I open ...

**0**

votes

**1**answer

16 views

### Excel assigning different dollar values and adding them

I am creating a spreadsheet and I want to assign different dollar values and add them together. For example I want B to represent 10.00 per hour for each hour I type in then I want C to represent ...

**1**

vote

**2**answers

46 views

### Excel: Reference Dropdown Cell in Countif Formula

I'm trying to substitute text in an excel formula with a cell reference to the text in a dropdown.
First formula that yields the correct answer is:
=(SUM(COUNTIFS('LP - All ...

**0**

votes

**1**answer

20 views

### How to sort spreadsheet based on partial matches

I have a spreadsheet of imported broken links as shown in screenshot below. I need to get rid of any rows where the domain names in column A and B are the same (such as in row 3 in the screenshot) and ...

**1**

vote

**1**answer

34 views

### How to sort this list in excel?

I've got a list of imported broken links. I need to sort the list based on column C (the error code) so I can find all links with error 404. However, I need to know the corresponding parent page ...

**1**

vote

**0**answers

47 views

### Excel busy CALCULATING for no reason

I have a problem with Excel and some of my spreadsheets whereby whatever action I make (even a basic =2+2):
the spreadsheets gets into CALCULATING mode for about 14 sec
for some tasks (e.g. =2+2), ...

**1**

vote

**3**answers

65 views

### Automatically hyperlink-ify large number cells containing URLs in Excel 2010

I have an Excel spreadsheet with around 900 cells each of which contains a URL, which I've pasted in from another program.
If I select a cell and hit F2, then hit Enter, Excel adds a hyperlink to the ...