# Questions tagged [microsoft-excel-2010]

The 2010 version of Microsoft's spreadsheet application.

4,501
questions

**0**

votes

**0**answers

13 views

### If VLookup Function that add corresponding cells if 1 range matches another

If B4 matches a # in column A I need the formula to return the # in column C and then add...
For example: Since B4 matches A1, I need C1 (90) +E1 (3) + F4 (0) and return the value in C4.
I tried this, ...

**0**

votes

**2**answers

35 views

### Excel: How to graph a multiple line chart by date and country

I have the following dataset that I would like to graph in excel.Dataset
The data is from OurWorldInData.org if you need the full dataset. It has a country, date, and new cases columns. I would like ...

**0**

votes

**1**answer

23 views

### Excel Formula To Get Last Non Zero or Not Blank Value in Column And Return Value

I already saw a few related questions on here about finding the last item but my question is a bit different because I'm trying to find the last not blank or non zero value in a column and either ...

**0**

votes

**1**answer

19 views

### Find if cells in multiple cell ranges in Excel are blank or filled

I've got a template which others need to fill in. There are some cells which are required, and I'd like to find a way of showing in another column whether the cells have been filled in or not.
Let's ...

**-1**

votes

**2**answers

45 views

### FUNCTION INDEX + MATCH alternate solution

I hope you can help me with the following query. I am performing a search in the matrix located in the range A2: G481 to bring me the values corresponding to the columns F and G, according to the ...

**0**

votes

**0**answers

32 views

### Excel: Merge financial data with different discrete dates

Suppose I have two sets of data, each is two columns (Date and amount). The thing is the dates do NOT lie on the same exact days, and in the end, I want a single set (Date column and amount column), ...

**0**

votes

**1**answer

39 views

### How to increase the lookup value by 1 row after I drag down the formula 23 rows?

hope you guys can help. I have an old table from which I need to build a database. As you see, "Position 1" needs to be repeated 3 times, and then to move on with "Position" 2 of &...

**0**

votes

**1**answer

14 views

### Average range only if another range is blank

I am wondering how to write a formula that will do the following.
Average A1 and B1, if A1 is not blank.
If it is blank, average E1 and B1.
If it is also blank, average K1 and B1.
Is there any way to ...

**0**

votes

**3**answers

46 views

### Excel VLOOKUP for range of dates

I have been struggling with VLOOKUP for sometime. I want to use VLOOKUP for a range of dates using the two tables I have given. I want to get which Term each row belongs to. Basically I want to check ...

**0**

votes

**1**answer

18 views

### Dynamic table modification using drop down lists

I need to allow a user to make modifications to a matrix. In order to do these modifications, the user should be able to show each row using a options in drop down lists.
Below is a simple example to ...

**0**

votes

**1**answer

19 views

### Excel - Macro - Data copying with values

I have a macro where it copies a range from a sheet and pastes it into another sheet.
Sheet name - MAIN
Range - C4 - D26
Date sheet - DATA
Then when you enter new data and use the macro, it copies the ...

**1**

vote

**1**answer

19 views

### How do I highlight cells in column A that match text in column B?

I'm looking for duplicates. I am trying to highlight all the cells in column A that match text in column B. Cells in column A can be repeated, but B will always have unique text in each cell.

**1**

vote

**2**answers

32 views

### How to calculate average and standard deviation from the same range in excel

I have an excel sheet in which there are there are groups of 4 values in column H. So H7 to H10 contain 4 values relating to one sample. H11 to H14 contain 4 values relating to another sample.
In ...

**0**

votes

**2**answers

49 views

### How to select a specific range based on user input

In the attached image, I want to sum up C2 to C14 in D column of sheet 1. This number '14' will be selected by user in other sheet, lets say in sheet 2, R4 cell. The next row in C column will be C3:...

**0**

votes

**0**answers

16 views

### Compile a LIST in one worksheet using data entry from another sheet on same workbook

In an effort to not have the list of all persons in full view due to some wanting to keep information confidential, I wish to create a separate sheet where either using macros or formulas values ...

**1**

vote

**2**answers

12 views

### Disable automatic VBA window opening while opening an Excel document

I have an excel document and I added some vb script to find the password of the protected file. I took this script from some internet forum. After that, whenever I open this excel sheet the vba window ...

**0**

votes

**1**answer

44 views

### OFFSET function in Excel

I'm having some trouble with the OFFSET function in Excel. I'm modifying a file created by someone else, the code was not written by me.
So in one sheet of the file, in the cells it applies the ...

**0**

votes

**1**answer

59 views

### Macro to create Line graph for each row in my table?

I've got a monthly spend table with almost 800 rows (one row per customer), and I'd like a line graph, with trend, for each customer. Is there a Macro that will help me do this for every line, and ...

**1**

vote

**3**answers

99 views

### Selecting the first row in excel where a column value equals a certain value

I have a excel sheet which displays the status of various products on my website throughout the day, along with the timestamp of the status as so:
| Timestamp | Product 1 | Product 2 | ...

**0**

votes

**1**answer

40 views

### Microsoft Excel formula to sum some data if they meet the requirement

I want to get the sum of profit for each specific month. the only possible way i think right now is to check if the month is match, example
if I need January details, the formula can sum all item ...

**0**

votes

**1**answer

22 views

### Countifs in a cell if certain conditions are met in another

I need to count the number of times certain conditions are met in a series of cells within a column when other conditions are met in cells in adjacent columns. Here is a simple example. I need to ...

**0**

votes

**2**answers

34 views

### excel - group sheets by columns

I have a bunch of .csv files with the same structure, but it's not guaranteed that they are in same order row-wise. I would like to group them all in a single spreadsheet. The following image draws ...

**0**

votes

**1**answer

22 views

### Excel 2010 how do you save a graph as an image?

I can't find a way to save my graphs as images in Excel 2010. I don't see any option under File -> Save As
And theres no export to image either...
Does any one know how to do this ?

**0**

votes

**1**answer

27 views

### Excel: Simulating multiple recalculations (F9) and then pasting outcome into a table

TL;DR: Want to recalculate a model based on random variables and take the result and put it in a table. What's best way to do that?
Longer Explanation:
I have a model that is built upon multiple ...

**3**

votes

**1**answer

98 views

### How to add columns from different sheets in excel?

I have such data in 35 excel sheets ( Sheet 1 to sheet 35) at the same position
I want to add all the second columns and get total Range combining all files. So if there are two such files and in ...

**0**

votes

**1**answer

31 views

### Excel: change formulas based on value in drop down list

I would like to be able to quickly check my paycheck in Excel. I wrote some numbers from my paycheck to rows based on the according month.
Because it is easier to read, I made the calculation not ...

**0**

votes

**0**answers

22 views

### Excel Formula for Scoring System

I'm trying to build a scoring system for a data set of several variables for customers (ie revenue, market share, industry sales, etc). Some variables are in currency (revenue) and others are ...

**0**

votes

**1**answer

25 views

### Excel transpose function returns a 0, multiple worksheets

I do have two worksheets.
In worksheet 1 I do have the following values horizontal listed:
A1 = 2010
B1 = 2011
C1 = 2012
In worksheet 2 I would like to list the values (2010, 2011, 2012) vertically. ...

**0**

votes

**1**answer

30 views

### Create multicategory timeline chart in Excel

I'd like to create an Excel chart showing on the x axis the dates from 1943 to 2021 and on the y axis the relevant category which follows a specific timeframe.
I.e. from 1/1/1943 to 18/01/1943 ...

**0**

votes

**0**answers

40 views

### I need to compare a previous cell value to the current cell value after refresh. Then, I need to run a Sub

I have an excel spreadsheet that updates its values automatically every 3 seconds or so. I want to compare a cell value to the previous cell value (same cell).
Here's the step out:
Get and store cell ...

**0**

votes

**0**answers

22 views

### How to identify duplicate values on find which sheet it’s on

I have 5 sheets. I am using it to find duplicate values across the 5 sheets. I would like like to mark an “x” next to the duplicate and identify which sheets it appears on.

**0**

votes

**0**answers

24 views

### How to create an hourly graph

I have a worksheet in excel of times that tickets were submitted to a certain vendor.
Have a combined date/time field that looks like this:
1/1/2021 9:41
all in one field. (It is in 24-hour time).
I ...

**0**

votes

**0**answers

32 views

### Extracting data from a CSV file

One of my tasks at my job is to take readings from the floor PDUs and compile the data into a masterfile. There's 32 CSV files by the time I'm done gathering them all. I recorded some macros to make ...

**0**

votes

**2**answers

23 views

### Populate cell with value from 3 possible cells

I want to populate one cell based on the text value of one cell out of 5 possible choices. The other four cells will not have any values. Only one of the 5 will have a value I want to populate in the ...

**0**

votes

**3**answers

80 views

### Excel MAX IF Function To Ingore Zero Date (1/0/00)

=MAX(IF('[YTD -2021.xlsx]OB'!$H$2:$H$23967=$C5,IF('[YTD -2021.xlsx]OB'!$J$2:$J$23967=$B$1,'[YTD -2021.xlsx]OB'!$A$2:$A$23967)))
I want to ignore Zero date and result should give me 0 or blank instead ...

**0**

votes

**0**answers

14 views

### Mark rows in Excel that were used in a Mailmerge in Word

I'm printing new receipts (=a row in an excel sheet where the column "print date" is empty) with word using the mailmerge-functionality. After that, when that it's printed, I want to set &...

**0**

votes

**1**answer

13 views

### PivotTable showing data which I can't find in the data sheet table

I've got a pivot table running off a table in one of my sheets which is showing a value that does not come up as a selection on the filtered column. I've tried selecting all and unhiding rows and ...

**0**

votes

**1**answer

20 views

### I need to have the “year” convert to this calendar year 2021 while maintaining the day and month

Eg. 09/25/2003 would need to reflect 09/25/2021. Each cell has a different date associated with a "policy" so I'd like a formula that will change just the "year" to reflect this ...

**0**

votes

**1**answer

41 views

### Sum of Sum gives Zero

In Excel I want to SUM a few numbers. Everything works until I add a cell that is a sum itself, then I get 0.
For example:
=SUM(A1) => 15
=SUM(A2) => 23
=SUM(A1:A2) => 38
=SUM(A1,A2,A3) ...

**1**

vote

**1**answer

57 views

### I want to combine multiple Excel files

I need assistance with the issue that I have multiple Excel files which are being updated on daily basis but for the analysis part I have to combine them all; and then perform the analysis.
Is there ...

**0**

votes

**1**answer

19 views

### Sum first values of non-unique data in different category

I have a table consisting of 3 types of costs and each type of these costs has several cost IDs, as below:
Cost ID
Amount
Cost Type
IT01
100
Direct cost
IT03
300
Indirect cost
IT04
400
Indirect ...

**0**

votes

**0**answers

19 views

### How do you get an Excel Table to accept a dynamic formula to determine size?

I need to have an Excel table to resize dynamically. This is needed because all values in all the columns in the table are determined by a formula in the first row of each. If the table size is at the ...

**0**

votes

**0**answers

16 views

### Excel Copy Line Down functionality

In VSCode, we have the Copy Line Down functionality, where the editor adds a new line below with the contents of the selected line. Something like if the cursor was in the first line of this example:
...

**0**

votes

**2**answers

40 views

### Excel 2019. I have a fee in column A that depends on a balance in column B

I have a fee in column A that depends on a balance in column B. But the fee is worked out on several different number ranges. E.g., if the balance in column B is between 7K and 14K then the fee is 25%....

**0**

votes

**0**answers

13 views

### How to conditionally format an entire column based on the value of the first cell of the column?

I am trying to manage a task list across the year and track it via conditional formatting. The rule for the colour is that if the first cell of the column is equal to or less than today then it should ...

**0**

votes

**0**answers

19 views

### Get data from the cell of next row in a table, if a cell is found empty

I have to create a formula based table on the next sheet (e.g. Sheet-B), based on the data/table on "Sheet-A".
My 'Sheet-A' data has 100+ rows and 30+ columns, where 'Column-A' has text data ...

**0**

votes

**1**answer

17 views

### How to show a column name in excel if a condition is met (eliminating the blank ones)

I have the following table:
I need the Result row to show the name of Fruits if their value is greater than 1. I have the following function for R18, it gets dynamic when stretched to the succeeding ...

**0**

votes

**0**answers

23 views

### Multiple conditions, if/or statement ask

I need to write a formula based on multiple conditions, that calculates what percentage of data is completed for each entity. I have created an example dataset below. The condition that will change ...

**0**

votes

**0**answers

19 views

### Formula for “If not empty OR is not equal to zero”

What formula can I use to write a if condition to say if a cell isn't empty OR isn't equal to zero.
This is the formula I have right now:
=IF(INDEX(7:7,COLUMN()-1) <> "", (INDEX(7:7,...

**0**

votes

**1**answer

25 views

### Get count of categories present in a column in separate columns in pivot table in excel

I have a pivot table which looks like
Now I want to get count of each category in State column in a separate column. Something like this.
I tried creating a pivot table, but the format is not what I ...