Questions tagged [microsoft-excel-2010]

The 2010 version of Microsoft's spreadsheet application.

Filter by
Sorted by
Tagged with
0
votes
0answers
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
0answers
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
1answer
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
1answer
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
2answers
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
1answer
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
1answer
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
1answer
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
0answers
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
2answers
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
1answer
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
1answer
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
2answers
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
1answer
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
1answer
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
1answer
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
1answer
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
0answers
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
2answers
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
0answers
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
1answer
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
1answer
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
1answer
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
0answers
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
1answer
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
0answers
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
1answer
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
2answers
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
2answers
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
2answers
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
1answer
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
0answers
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
0answers
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
1answer
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
0answers
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
1answer
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
0answers
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
0answers
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
2answers
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
0answers
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
0answers
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
1answer
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
0answers
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
0answers
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
0answers
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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(...

1
2 3 4 5
90