# Questions tagged [microsoft-excel-2010]

The 2010 version of Microsoft's spreadsheet application.

4,480
questions

**0**

votes

**0**answers

15 views

### Create a pivot table depending of two dates

I have an Excel table with statistics on issues handled by my team:
|Date opened|Date closed|Description|...|
|-----------|-----------|-----------|---|
|2020-03-05 |2020-04-23 | foo |...|
|2020-...

**0**

votes

**0**answers

9 views

### Microsoft Excel 2010 - how to mass find and replace parts of hyperlinks [closed]

I have hyperlinks to image files stored in an excel spreadsheet with the Text to Display set to a word not the actual link. Some links need the path replaced. Looking for a way to mass find and ...

**0**

votes

**1**answer

25 views

### Alternative to TEXTJOIN

Currently working on building an Excel form within Microsoft Teams, but it will eventually need to be downloaded to a user computer to be filled out. TEXTJOIN works online within Microsoft Teams, but ...

**0**

votes

**1**answer

62 views

### How can I open Excel 2010 showing no worksheet?

When I start Excel 2010, it comes up showing a blank spreadsheet. I often have no need for this, because I'm going to navigate to a specific directory and open a spreadsheet there. How can I start ...

**0**

votes

**2**answers

119 views

### Populate an array of table[column] names from a column of another table and return the max number

I have a table with a list of manufacturers (Manufacturer 1, Manufacturer 2, Manufacturer 3). Then for each manufacturer listed in that table there is a corresponding table that list all the items ...

**0**

votes

**1**answer

16 views

### SUMIFS formula doesn't work

This is a simplified example of my problem:
SUMIFs formula
I have two columns: category and hours. I want to find the sum of hours for A and C. The answer should be 5.1, but it shows 0. If I use ...

**2**

votes

**1**answer

53 views

### Excel - How to find a number exist in which sheet

I have 10 sheets in a excel file.
Sheet2 to Sheet10 are raw data, and every sheet A1 has that sheet name, like this
Sheet2
colA colB colC colD
row1 Sheet2
row2 ...

**0**

votes

**1**answer

128 views

### Logic based on a cell's background color

I am trying to build something that counts cells with a background color. I used Name Manager by having a 'Name'(GetColor) with something like "=GET.CELL(38,)". In the cell I have something like =...

**0**

votes

**0**answers

17 views

### Adding one more IF funcion does not work together with the previous IF functions, but it works when I test it alone

=IF(O23="Inactive",0,IF(OR(L23=$L$3,L23=$L$4)=TRUE,$U$1*0%,IF(S23>0,IF(S23<AI23,$U$1*50%,0),IF(AK23="Yes",U1*50%+U3,U1*50%))))
The last if functions work when they're used on their own, but ...

**1**

vote

**2**answers

42 views

### Q: Usage of Excel function called as EFFECT()

I am having a question regarding the usage of the EFFECT() function in Microsoft Excel.
I know the basic concept of the function, and I have no issue with it when there are pre-defined compounding ...

**0**

votes

**1**answer

26 views

### Excel: Find nearest lowest value above current row and return from another column

I've tried a few different examples with similar scenarios been have not yet had any luck.
I have a flat sitemap (450 pages), which is ordered by hierarchy, with each subsequent child page starting ...

**0**

votes

**1**answer

40 views

### Excel formula to calculate based on another field's contents

What I want to achieve is, to create a universal formula for Bob, George, Charles, to calculate
their balance based on "Affects balance" field.
So in the example below results would be following:
C3:...

**0**

votes

**2**answers

38 views

### Excel Large Data to Summary Table

In the attached excel workbook contains 2 sheets, First one is data and second one is Result.
In the Data sheet, "A" column contains the length (10 meter) and "B" column contains the type of pole to ...

**1**

vote

**1**answer

20 views

### How to make the sum of range to output at the top not the bottom?

I am adding values in many ranges, each range defined by a certain ID number. I need to know the total merchandise purchase for each registrant at an event together with the merchandise purchases for ...

**1**

vote

**1**answer

54 views

### Creating an excel formula to calculate returns

So I have a dataset of monthly stock returns from January 2000 until today for six different stock indices. At the bottom of the page, I want to show the yearly return for each year as a percentage ...

**0**

votes

**1**answer

16 views

### How to get the percentage change with intervals on Microsoft Excel?

So I have a dataset of monthly stock returns from January 2000 until today for six different stock indices. At the bottom of the page, I want to show the yearly return for each year as a percentage ...

**0**

votes

**1**answer

24 views

### Extract randomly located word with certain number of characters from sentence

I want to extract a 4 characters word from sentences in every cell. This word unfortunately is located in random position in the data.
I have these sets of data:
A2: WKDOASPD A4IT LKALOASPDO
A3: ...

**0**

votes

**0**answers

19 views

### Copying a multi-line formula excel

I have a very large spreadsheet that helps me track inventory. I wanted to add the ability to change the monthly projection factor from one central location and have it change that month for each item....

**0**

votes

**2**answers

73 views

### How to extract only the Country name from the Complete address in Excel

Look for suggestions on the below concern:
The country should be extracted from the complete address, the address might vary in 4-6 cells in Excel. I rather need only country in new cell. Screenshot ...

**0**

votes

**0**answers

28 views

### Nested If function to create Concatenate solution

Hi I need to concatenate two columns but it needs to look at 3 columns and if the criteria does not fit then look at another column, It is looking at a pivot and one columns has a mixture of text and ...

**1**

vote

**1**answer

79 views

### Unable to Edit Chart Data in Powerpoint 2010 64 bit

when I create a powerpoint presentation and add a chart, I can edit the data in the excel window that opens initially. However once I close that excel window, I am unable to bring it back up if i want ...

**0**

votes

**1**answer

27 views

### Invoice data copy to another sheet but not the formulas

I see a lot of questions here on this site but not sure if mine has been answered. I found a macro and made it work for what i need except for one thing. When it copies my data over from sheet 1 to ...

**1**

vote

**1**answer

27 views

### How to count the highest value in every column in Excel 2010?

I play games with my friends and I created a spreadsheet to record results. I am trying to create a formula which count how many times a person won.
To summarize, here is how the layout of the table ...

**0**

votes

**0**answers

35 views

### Writing a macro for excel and I am having trouble with syntax. Can anyone help me?

Could someone please help with the syntax error I am getting with this macro? It will not run and I am getting the following lines in red:
What do I have to change to correct the syntax error?
I ...

**0**

votes

**1**answer

84 views

### Automatically producing names of images in Excel

As described here, Excel introduces generic filenames of images loaded into a spreadsheet. I wonder if it is possible to create a VBA script, or something else, that would book-keep these names in ...

**0**

votes

**0**answers

31 views

### How to read as float from floating point represented number in excel?

I am working in Embedded domain. I am analysing an Issue produced in customer's place. I have taken the Configuration values stored in EEPROM(let's call it NVM) and Analyzing. One of the value stored ...

**2**

votes

**1**answer

41 views

### Keeping track the filenames of images loaded into an Excel spreadsheet

It is quite easy to extract images from an Excel spreadsheet. For example, one can change the extension from xlsx to zip and go to a relevant subfolder.
However, the filenames therein are generic ...

**2**

votes

**2**answers

55 views

### matching all highlighted dates in one column to those of another column

I'm currently stuck on this step of my project. image of my document My ultimate objective is to highlight all highlighted dates in column P in column M. I was wondering if there was a formula so that ...

**0**

votes

**2**answers

61 views

### SumProduct Multiple columns using name for column index Vlookup across multiple sheets

I am trying to sum multiple columns from a table on a separate sheet using vlookup and matching the column index number with a name instead of the column number. I can return a single result but can ...

**1**

vote

**2**answers

36 views

### Copy a table from excel to word, keeping the word table formatting

I have a word document with a table designed to be printed to make name cards - rows and columns are different sizes and the font size varies also. I want to copy various tables with students' names ...

**1**

vote

**1**answer

31 views

### Excel count numbers, with taking day of today in account

I have an Excel sheet that looks like this:
In the column "Total" I have the total amount of minutes that need to be executed.
In the days after the "Todo" column I have the number of minutes that ...

**0**

votes

**0**answers

9 views

### Changing Text and highlight based on data in a row

I'm trying to build some excel based activities for my students but I can't seem to get my head around the formulae.
What I would like is for my students to enter the correct answers and then the ...

**1**

vote

**0**answers

27 views

### excel formula search to calculate the below if possible

Iāve got a query if someone can help.
An accumulation of 20 points equals one 1 credit.
If there is one person with 10 points another with 5 and another with an additional 5. The total of the 3 ...

**0**

votes

**1**answer

86 views

### Specific x-axis gaps or bounds

I need help with this specific situation. I have a table with values between 0 - 115 and i want to display them with a chart like in the picture below.
Picture1
The thing is that on chart i want the ...

**0**

votes

**0**answers

45 views

### count the number of times a cell has dependents in excel VBA

In the picture, you see I have 3 columns.
I have written the VBA code to show the count of dependents in C column.
Here is code.
sub countdep()
ActiveCell.Offset(0, 1).Value = ActiveCell.Dependents....

**1**

vote

**1**answer

29 views

### Creating Unique Dropdown In Excel Based on existing data

I have a table in Excel 2010 with transaction data dating many years.
I would like to create an in-cell drop-down of the unique years in the POSTDATE column and populate those right above that ...

**0**

votes

**0**answers

22 views

### Graphing correlation between two cells which contain functions

I have created an excel table and I want to see the changes in a graph.
in the picture A3 has no function but H3 is changing according to various functions.
So I am interested in what happens to H3 ...

**0**

votes

**0**answers

28 views

### Excel (2010) saving as PDF issue (wanting to save output file to version 1.5 PDF -and not 1.4- without luck so far)

I'm facing an issue that seems to be the same as the one described here:
https://www.excelforum.com/excel-general/718364-excel-2007-adobe-pdf-rendering-issue.html
Using MS Excel 2010 and saving xsl(...

**0**

votes

**2**answers

52 views

### MS Excel - Add / Subtracting time in 0000 format

I am trying to subtract time on Excel.
My company uses a 24hr time format (0500,0600, 1250, 1300 etc.)
I'm trying to calculate the time difference between 2 cells:
| A1 | B1 |
|------|------|
| ...

**0**

votes

**0**answers

8 views

### Year-wise count based on specific text

I am trying to prepare a formula in Excel which brings me back a year-wise count based on specific text. A column contains dates in the years 2019 and 2020 and column B has a few text values. I need ...

**0**

votes

**0**answers

15 views

### Select All Charts in Excel Workbook?

I have a workbook that has 25 tabs with each worksheet containing about 2-5 graphs. What is the best way select all the graphs in the different tabs at once?
I've tried selecting all of them via F5 ...

**0**

votes

**1**answer

32 views

### Excel to return matched value in rows from a column array

Super stumped, I am trying to return the values of column based on the value of a cell found in a number of columns. I have attached an image to better describe what I mean. Table So, I'd like to ...

**0**

votes

**0**answers

31 views

### Formula for unique values ā numbers and text

Iām using Excel 2010 and have the following formula:
=SUM(--(FREQUENCY(H2:H58, H2:H58)>0))
to count unique ID numbers in H2:H58.Ā
This worked when the numbers were numbers, e.g., 42, 83, 17, 42, ...

**1**

vote

**0**answers

27 views

### How do I format a number in Excel so the decimal appears in a specific spot?

I have two sets of numbers that correspond to the minimum and maximum values of an interval. In the database that I am pulling this data from, the numbers are formatted without decimal places, like ...

**0**

votes

**0**answers

93 views

### Strike through text of an entire row in Excel if a certain cell has value

I need to track lieu days earned for weekend days worked. Here is what the current Excel file looks like:
Column D is currently using conditional formatting to keep track of how close I am to losing ...

**0**

votes

**1**answer

71 views

### Show defined table content based on cell value

I have a problem not sure how to solve it. I want to create a formula which will display the content of the table based on cell value.
I have for e.g two tables Box1, Box2
Box1 Box2
Name1 ...

**1**

vote

**1**answer

16 views

### How do I flip a bar chart?

In excel, I have a set of percentages and a set of text labels. When I create a bar graph going horizontally, I see "label 5" at the top and "label 1" at the bottom. There doesn't seem to be a way ...

**-1**

votes

**1**answer

34 views

### How to automatically update all the relevant cells in Excel when a new row is added

So I have a spreadsheet used for calculating let's say the taxes on something which I purchased. It has a column with the sales tax calculation, state tax, etc. and all each of these columns reference ...

**0**

votes

**1**answer

16 views

### referencing cell based on specific data in excel

I want to get the cell address (column number and Row number) based on the data it has.
Example: Cell A1 has value 8 and column B has number 1 to 100 in random order (no value repeating twice). I ...

**0**

votes

**1**answer

136 views

### How to sum values in excel until they reach a specified sum

I want to have a threshold value in one cell (A1) and take it as a reference for adding cells.
Suppose I have
A1 - 10
A2 - 4
A3 - 2
A4 - 3
A5 - 4
A6 - 6
I want to add cells based on A1(...