**0**

votes

**3**answers

5k views

### Excel: how to count number of distinct values in a range with condition?

I read and tested quite a lot, but I still not able to come up with a solution for my problem.
The close solution I found is the second one proposed in article below:
Excel: how to count number of ...

**4**

votes

**2**answers

16k views

### Add custom colors in Excel 2010

I'm working on a spreadsheet which was created in an earlier version of Excel (2003 I think), and it makes extensive use of color-coding for organization. Unfortunately, it was built using the ...

**0**

votes

**2**answers

1k views

### Change the color of a line with the change of values of X coordinate

I'm drawing a simple line graph with 3 different lines in the same graph with Microsoft Excel. What I want to do is to change the value of each of this line with the change of X coordinate value. For ...

**0**

votes

**1**answer

3k views

### Excel VBA Macro to Create Custom Lists From a Selection

Hi I was wondering if anyone could help me create a macro that will add a selection to excels custom List. Typically to do this I select a a series of rows in one column, then I got to file, options, ...

**4**

votes

**1**answer

74 views

### How to break a list of numbers into parallel blocks

I've 480 numbers all in the one column of an Excel file. In the same file I want to divide these numbers into 60 columns each of 8 numbers:
.. sequence... column 1-->1-8, column 2 --> 9-16, column ...

**-1**

votes

**2**answers

78 views

### How to total an Excel Formula [closed]

I would like to sum a column with it rounding up and or down in the same cell. Can this be done?

**-1**

votes

**3**answers

3k views

### Sum within date range (changing monthly)

I would like to have the sum for dates in an specific month. The problem (differs from other questions) is that certain orders take months to be finished, and when these finally are, they are posted ...

**-1**

votes

**2**answers

210 views

### Combining multiple rows into one

From input as below:
Last Name First Name Job Title Date Hired Description Field Name Value SSN/Fed ID
AL V Assistant 12/08/2008 Driver License Expiration Date 2/23/16 364
AL V ...

**1**

vote

**1**answer

244 views

### Map Page Up, Page Down and Num Lock just for Excel with Autohotkey

I would like to map these keys to the corresponding text:
Page Up (
Page Down )
Num Lock =
I want to do this with Autohotkey but I'm having a hard time figuring out the script.
I also only want ...

**4**

votes

**1**answer

9k views

### Multiple bar charts on one axis in excel

So I have a bunch of series laid out like this in excel:
I'd like to have them plotted all on one column chart but with the series separated (i.e. not clustered) so it basically is several column ...

**6**

votes

**2**answers

6k views

### How to disable keyboard shortcut animation in Office 2013?

I am looking for a way to disable the animations for keyboard shortcut selection in Office 2013, especially Excel 2013. When you select a keyboard shortcut using Alt and a key sequence (e.g. ...

**1**

vote

**1**answer

2k views

### Excel - Finding all values in one column for unique values in another column

I have an Excel table that looks like this:
Code | Description
-------------------------
A | Desc1
A | Desc2
B | Desc3
C | Desc4
C | Desc5
C | Desc6
...
I need to find all the ...

**1**

vote

**2**answers

2k views

### Matching tables with unsorted data

I am trying to match the data from one table to another.
The primary table has two columns (an alpha item description in column A and a numeric value for that item in column B) in an unsorted order. ...

**1**

vote

**2**answers

975 views

### How do I change the color of a cell based on whether the previous cells are blank in Excel?

I have a spreadsheet with names in column A. I'm keeping attendance by placing an "X" in each subsequent column when the person is present (week by week).
I'd like for Excel to automatically change ...

**3**

votes

**1**answer

1k views

### Need to paste a column from Excel into Powerpoint- how to paste so they are individual slides, not one

I have a column of 50 in excel 2003. I want to paste it into powerpoint but it continues to paste as 1 whole text box. I need 50 individual text boxes.
Is this possible?

**-3**

votes

**1**answer

89 views

### How to open files when the sources are in a column of another file

I have a large three-column Excel file:
first column is "data (Excel file) name"
second column is the "data source(of that Excel file's data)" and
third column is "remarks"
See large image
...

**1**

vote

**3**answers

115 views

### Enhance display of positional encoding for debug purposes, perhaps using Excel one-character-per-cell

I have the following problem to solve: I work with positional-encoded files. These files show characters at certain positions in the string. Each row is a record, and the meaning of a character in a ...

**0**

votes

**1**answer

1k views

### Excel SUM or COUNT based on related fields from two Tables

I have two tables in Excel
The small table with 50 rows...tblGroups[#Headers]= Employee ID; Name; Group.
The second table with 3000+ rows...tblData[#Headers]= EventID; Date; Employee ID; ...

**4**

votes

**1**answer

171 views

### Formatting legend position in Excel?

I have a bar chart with four different data sets in Excel 2010 and made a nice little figure from it. However, I now want to format my chart's legend.
The legend has four entries in list format with ...

**0**

votes

**6**answers

1k views

### Excel how to count the number of same words/ strings in a excel file

I have an excel sheet with data in rows for example:
aa
aabbcc
aa, aa aa
aabbcc
dd, dd
ee
So I am looking for an output like : aa = 4, aabbcc = 2 , dd=2, ee=1 .

**0**

votes

**1**answer

32 views

### Questionnaire Restrictions in Excel

I have a 10 question questionnaire. I want to restrict the answer to one box chosen with an "X". I have already coded the "X" input restrictions via DATA VALIDATION. Now I need to restrict the # of ...

**5**

votes

**1**answer

14k views

### In Excel, how do you auto fill until next value?

currently I have a column looks like this:
A B ...
1 A
2
3
4 B
5
6
7 C
8
...
And I want to make it looks like this
A B ...
1 A
2 A
3 A
4 B
5 B
6 B
7 C
8 C
...
Is there a way to finish the ...

**3**

votes

**2**answers

2k views

### Working with “~” in excel

I have a data set that has names that contain ~ within them. Unfortunately, I cannot find a way to filter or incorporate these cells in a formula.
For example, I tried to use a text cell that had ~ ...

**0**

votes

**0**answers

49 views

### Disable printing with Excel Viewer

I would like our team to be able to view a shared network excel file without the ability to easily print it. The ideal solution would be to install Excel Viewer on each machine and have it open the ...

**0**

votes

**3**answers

328 views

### Convert time format 1w1d1h1m to number of hours in Excel

I have text in the format "1w1d1h1m" in an Excel workbook.
Is there any way that Excel can convert this time format into number of hours?

**-1**

votes

**4**answers

138 views

### Automatic sum function in Excel

I have three columns with 1500 rows in this form:
Name codenb area
X1 1 12
X2 1 8
X3 2 16
X5 3 2
X6 4 20
X7 5 5
... ... ..
Xn
Anyone have an ...

**2**

votes

**4**answers

7k views

### How to Unhide column A in Excel and Google Doc?

Let's say I hide column A in excel or in google doc, how can I unhide it (show column A again).
Column A is the most left column. I have column B,C and D etc...

**0**

votes

**1**answer

280 views

### Combine Excel worksheets despite adding new sheets

I have an Excel worksheet that works as template for a questionnaire. My aim was simply to copy the worksheet into a new one while preserving the formatting and other stuff, and I could then just fill ...

**1**

vote

**1**answer

710 views

### Excel data doesn't update after data injection from an access db

Description of the situation:
I have a access DB where I export data with the following command to an excel:
DoCmd.TransferSpreadsheet
The export works and the data is exported into an existing ...

**0**

votes

**1**answer

95 views

### Conditional formating not working if formula includes text

=IF(ISBLANK(H10)," ",SUM(H10-TODAY()))&" days to ship"
If I enter the above formula, the conditional formatting works fine. But when I enter any text, like "days to ship" in the formula the ...

**0**

votes

**2**answers

67 views

### Why am I getting a “name error” with this IF formula?

I'm trying to use this formula to output "Tie" when the result is a draw:
=IF(B6>C6,B6-C6,IF(C6>B6,C6-B6,”Tie”))
Instead of giving me what I want, it gives me a "name" error.
What am I ...

**1**

vote

**2**answers

1k views

### How can I use extremely large numbers in my spreadsheet programs?

If I try to calculate large exponents in LibreOffice Calc or OpenOffice.org Calc, the results come out to be erroneous. See these two examples where I calculate 13^18,
Using LibreOffice Calc
Using ...

**2**

votes

**2**answers

8k views

### How to do a “great circle” calculation in MS Excel or LibreOffice?

I got two columns with latitude and longitude values. I need to calculate the distance between the points in every row. I'm trying to use the haversine formula as seen here:
That's the so called ...

**0**

votes

**2**answers

2k views

### Excel 2007 Stacked Column Chart Display Subvalues

So I have the following set of values in my excel sheet:
The values on the first column (very low, low, medium, high) are simply socio-economic layer indicators.
As you can see, everything is ...

**1**

vote

**2**answers

121 views

### Transform numbers into hyperlinks - Excel

I try copy different links from Firefox into Excel but links-numbers are formatted like text and not like hyperlinks.
Paste links from Firefox into Word - numbers-links are recognized:
Paste links ...

**1**

vote

**1**answer

2k views

### Insert arithmetic series in excel

I'm making a budgeting for renting equipment at a shop. Their pricing is as follow.
Day 1 costs 40
Day 2 costs day1+day1/2
Day 3 costs day2+day1/2
etc.
I want to put this in excel but I have no ...

**0**

votes

**0**answers

408 views

### Is it possible to save or print a website (google search) via MS Excel (vba coding) as a pdf?

Is it possible to save or print a website (google search) via MS Excel (vba coding) as a pdf?
I have a set of data in which I want to do specific google searches on. Instead of manually doing this ...

**1**

vote

**1**answer

3k views

### Convert latitude and longitude coordinates in excel

I have about 10,000 coordinates I need to convert. The coordinates are in this format:
-116.6412722 34.7459017 -116.8066783 34.7734247
I need a way to convert them into this format, preferably in ...

**0**

votes

**1**answer

514 views

### How to change preset values of a row by selecting from a dropdown list

I am pretty new to Excel but need to make an Excel sheet where I can select the item name so when the selected item changes so do all the values (price) of the column. Once this changes the value when ...

**0**

votes

**0**answers

34 views

### I need help writing a macro that will check a condition, and then paste a value into a different cell [duplicate]

I want to have a macro that will check to see if a specific value exists in a data range, and if that value does exist in that data range, then I want to past a line of text in a different cell. Could ...

**0**

votes

**2**answers

71k views

### How do you write an Excel formula that will paste a specific value in a different cell?

So basically I want to write a formula that will check a condition, and if that condition is met, then I want to paste a specific line of text in a different cell. I should note that I do not want the ...

**0**

votes

**2**answers

61 views

### Manually populate a Pivot Table

This is really a stupid question because I am supposed to know the answer.
I have a data file that looks like this:
Tech || Workdate || Fail || Manual
Joe || 2013-05-23 || 6 || 1
Joe ...

**4**

votes

**2**answers

12k views

### Multiple Y-axis labels in Excel 2010 line chart

I have a table containing cycling data. Date, distance, time, calories burned, max heart rate and average heart rate. They all have different value ranges. Excel scales the chart to show the calories ...

**2**

votes

**1**answer

80 views

### Using a custom format to parse numeric strings

I want to know how to take numbers that are 12 digits long 123456789012 and have them display as 123 456 789 012. I apologize If that is explained in the Microsoft custom formats article but I ...

**-1**

votes

**2**answers

106 views

### How can I avoid having the sheetname included in a formula

The question is best illustrated with an example. Say I have:
Sheet1!A1=1; Sheet2!A1=2
I want a formula in Sheet1!A2 to be 2-1=1. If I enter the formula as normal with mouse clicks I would have ...

**2**

votes

**1**answer

714 views

### Excel Conditional Formatting cell's value that has number suffix, like 99th, 23rd, or 1st

So I am filling a cell with Blue, Green, Yellow, or Red based on a Percentile Rank that is returned, that is numbers like ( >=90th=Blue, >=60th=Green, >=30th=Yellow, <30th=Red )
Currently ...

**0**

votes

**2**answers

1k views

### Conditional format cells that are duplicated in every column

I have a table in which every column describes a product and every row is responsible for one attribute of the product. I want to highlight cells which are duplicated in every column.
I have for ...

**49**

votes

**7**answers

381k views

### In Excel, how do I check if a cell is in a list of values (a range of cells)

I've got a range (A3:A10) that contains names, and I'd like to check if the contents of another cell (D1) matches one of the names in my list.
I've named the range A3:A10 'some_names', and I'd like ...

**0**

votes

**4**answers

427 views

### How to extract the exact digits 1234 from 1234:00:00 in Excel

I have a series of IDs that are represented in a column with the [h]:mm:ss format in excel. I want to extract the [h] portion that precedes the colon and have it stored as a number. The problem I run ...

**0**

votes

**1**answer

1k views

### adding 'weight' to a value

I work in customer service center where we monitor calls and grade them.
We have an excel sheet where we score these calls, and my question is, we want to give a greater weight fro 10 points an agent ...