Questions tagged [microsoft-excel-2010]

The 2010 version of Microsoft's spreadsheet application.

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

1
2 3 4 5
91