Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [microsoft-excel-2010]

The 2010 version of Microsoft's spreadsheet application.

0
votes
0answers
21 views

Comparing two excel files and highlight the difference [on hold]

I have limited working knowledge of Excel and I hope someone will be able to help me with my problem. I have two files (say F1 and F2) F_old Clint_Naem | Address | Postcode clint01 ...
0
votes
3answers
58 views

Sum rows based on criteria in columns

I'm stuck with a problem, I have two sets of data like below: How can I find if the sums of column "a" based on ID in Table 1 are equal to column "b" based on ID? I'm assuming i need a Sumif and ...
0
votes
1answer
17 views

Extract Unique Substring from Range of Excel

I have cell values with names that are fairly close to each other. I would like to extract a common sub-string. Here is an example. 1100_250_Jump_12HR_100MD_S_run1 1100_250_Jump_12HR_100MD_S_run2 ...
0
votes
0answers
11 views

KPI Scoring calculation [closed]

How do I calculate a score if the criteria are 150 units per month and the weighting is 25%. So we set a target of 150 units of oil per month and once you sell 150 or more there is a scoring ...
1
vote
1answer
22 views

Excel: Sum [range] if cell equals value of another cell

| A | B | 1 | Value | Input | 2 | 1000 | 1000 | 3 | 3000 | 3000 | 4 | 5000 | 150 | 5 | 10000 | | 6 | 15000 | 3000 | 7 | 20000 | 20000 | ----------------- I'd like to know if ...
0
votes
1answer
40 views

How to map excel keywords to their specific folders?

I have a list of supermarket items in excel say 6000 products for example. I run a software which takes one product name at a time and performs a google search, and then downloads the most relevant ...
0
votes
2answers
88 views

Keep only one copy of the duplicated data

I am trying to clear out a list of content that appears 2,3,4 or more times repeatedly. I have two columns and I would like to eliminate the whole row of any repeatedly entry of column B. My ...
1
vote
1answer
44 views

Cell conditional formatting, based on the format of the same row's cells of another column

I've highlighted my duplicate text in column B, using Conditional Formating. No I want to highlight the same field on column A (and afterwards delete all non highlighted texts), but I am not sure how ...
-1
votes
0answers
52 views

Adding or Subtracting based on 3 variables

This may be simple but I'm new to formulae in Excel. I've got two sets of data that both have Dates in one sheet. One set has repeated dates for every Type and every State because it's a cumulative ...
0
votes
0answers
16 views

Lock Cells Based on Conditionally Formatted Interior Color

I am working on a project that requires locked cells based on how the cells are conditionally formatted. In this instance the conditionally formatted cells have interior color 15. This is the rule ...
0
votes
0answers
40 views

Excel how to SUM a column based on critea Yes's and No's

f6 has a calculated sum £10,000 in G6 i have a conditional formated cell that if i enter 1 IN g6 instead of it being 1 its Yes and if i enter 0 in g6 its No. what i want to do is if g6 has Yes ...
1
vote
1answer
49 views

How can Excel dates default to short-date format when the year isn't typed?

When typing dates into unformatted (General format) cells, Excel will change the format to a custom date format, but I'd rather it just stick to either the short or long format. Examples: 11/28 ...
1
vote
1answer
13 views

Referencing sheets by cells with their names

I have four sheets each with its own name which corresponds to the left cells. I want to reference those sheets by only stating the left cells. For example, instead of having ='SIN PLANIFICACIÓN'!E118 ...
0
votes
1answer
21 views

Extracting Data from one Excel Doc to another

I don't have the exact verbiage here to use, so please bare with me. I cannot do screenshots due to proprietary information being in the data set. Here is what I am trying to do and I am looking for ...
0
votes
2answers
51 views

linux command line for large data set?

the problem: I a large excel file of data, there are over 1000 columns and over 40,000 rows. I have to identify where a given row has a value of >199 in any given cell. If any row does not have >199 ...
0
votes
0answers
46 views

Excel 2010: How to create pivot table using multiple tables [on hold]

I have three tables each with three column headings: Table 1 column headings: "Name", "Permission", "Inv" --- Table 2 column headings: "Name", "Permission", "lim" --- Table 3 column headings: "Name", ...
0
votes
0answers
21 views

VLOOKUP getting value instead of 0 from blank cell

Having hard time using the below formula, running a VLOOKUP from pivot table and incremental the values when I drag the formula, even working fine however where the cell is blank result is still being ...
0
votes
0answers
17 views

How to change a color of text in a column based off of another column's text?

I'm building a Excel spreadsheet for my expenses. And I'm doing a copy and paste method from my online banking expenses. The trouble I'm having is based off a column, named "Payment", it shows the ...
0
votes
3answers
37 views

How can I get Excel to choose the highest grade credits on my course and display my final grade?

I'm in my final year of university and my final grade is calculated by (0.2*second year grade) + (0.8*final year's 90 best credits). I study one course worth 30 credits and 6 courses worth 15 credits ...
0
votes
0answers
22 views

Find the sum of values that meet certain conditions based on an index

I have been stumped on this one for a while. I am trying to have U5 look at the store name in Column A (A5), use the value in A5 to find all employees at that location on my index sheet (Screenshot #2)...
-1
votes
2answers
89 views

Looking for formula to search for particular pattern in Excel

I am looking for formula to search for "words" with a particular letter pattern, like INNSA1 or INMAA4 or INPTPB, where the word starts with IN and ends with 4, 1, 6, or B. The words are always ...
0
votes
1answer
27 views

Returning row and column value in a large chart if column is in a range

This is for a wastewater oxygen saturation chart used in determining Biochemical Oxygen Demand values. I want to find the intersection value returned to a cell of my choosing. But the catch is that ...
0
votes
1answer
21 views

Power Query with Additional Column

I am using a power query to read rows indexes by an item number from one file I receive to one file I am maintaining. I need to add some columns that are editable by me (cell editing), in a way that ...
0
votes
1answer
27 views

Keeping a fixed constant (like letter “M”) and a variable (like a number “100”) in the same cell in excel but I only need to type the variable?

In excel, is there a method where a constant term can be fixed in the cell and I only need to input the variable term. (this is difficult to put in words) example: So, I have different values, like ...
0
votes
0answers
30 views

Is there a way to merge two formulas in excel?

I have a long list of unique formulas, with each one just referencing another cell in another workbook (i.e. ='[Other_Workbook.xlsx]Sheet'!$A$1). The issue I am having is that I want to make sure that ...
0
votes
1answer
21 views

Splitting Workbook using filter and creating new file in column name

Suppose I have Workbook(Report.xlsx) and in that workbook I have different worksheet. In every sheet I have a column name B_Code. Using filter in B_Code I want a separate workbook with every sheet in ...
1
vote
1answer
19 views

How to do an Arrhenius plot AKA How to do a reciporcal secondary axis in Excel 2010?

An Arrhenius plot show the logarithm of a property that is thermally acitavted versus the reciprocal temperature aka 1/T. Now is 1/T something that most people are not used to. This is why most of the ...
0
votes
0answers
39 views

Splitting Workbook using filter

Suppose I have Workbook(Report.xlsx) and in that workbook I have different worksheet. In every sheet I have a column name B_Code. Using filter in B_Code I want a separate workbook with every sheet in ...
0
votes
1answer
50 views

How do I create a self-updating line graph when new information is input every week in Excel table without including the total?

I have a line graph with the performance of two employees.  How do I get Excel to automatically show only the last five weeks’ numbers without me having to select the data manually and without the "...
0
votes
0answers
37 views

How to replace a column of numbers with a numbered column?

I got our new timetable for the new course, the thing is that it's actually two excel spreadsheets; one with the number of the lecture and the time, the other is the title of the lecture. So if want ...
0
votes
1answer
18 views

Additional (search) window in MS Word?

There is an additional window opening, when the advanced search finds an entry in the header/footer within a Word document (in my case it's MS Word 2010). Is it possible to open this "window" ...
0
votes
0answers
10 views

Column total is returning a value double what it should be

I have a spreadsheet that transfers a value in one column to another column based on an If/then formula. I am totaling the column with the transferred values with a simple SUM formula. The problem is ...
0
votes
0answers
17 views

Is it possible to save conditional formatting in a profile?

I wonder if it would be possible to save Excel conditional formatting to a profile of some sort without VBA. I am able to make multiple entries into the conditional format area and do what I want it ...
0
votes
0answers
29 views

Populate a column in excel based on another column (non-numeric data)

I have two excel sheets - one contains a list of all our clients who we want to classify as 'active', and one with all clients. I want to generate a column in the complete client list and populate it ...
0
votes
1answer
27 views

Word 2010 mail merge: state a repeated field only once when populating results

I have this Excel file: exel file As you can see it's simple, only three columns: city, customer and paid. I need to create a Word file from this Excel using mail merge in the format I show in the ...
0
votes
1answer
64 views

Excel - Compare the value of two fields and change color depending on results

I am trying to compare two fields in an Excel Spreadsheet and if a number is higher then change the background of that cell and if it is lower change it also. For a further explanation I have created ...
0
votes
0answers
26 views

Filter entry if contains specific value in Pivot table

I have table with similar structure to this: Values in the first column can be duplicated, values in the second column are all unique and values in the third column are either Yes or No. I have ...
0
votes
1answer
34 views

Determine Multiple values exist in column for same values in other column

I am hoping someone can help me with a formula for the following: Excel hard data My goal is to have an addition column return a yes or a no. Yes if there are different values in column B for the ...
0
votes
3answers
97 views

Excel =TIME() with values over 24 hours displays incorrectly

I'm trying to display times over 24 hours in Excel by using =TIME() but when the values get over 24 hours they display incorrectly. For example I have =TIME(27;42,81;49) which should be displaying 24:...
0
votes
1answer
49 views

How to write this Excel formula

I'm just a beginner and I am struggling to get this to work. Any help would be greatly appreciated! =IF(B2="","",COUNTIF($C:$C,$D2)=0,"No Penalty","Penalty")
0
votes
1answer
22 views

Excel: check multiple cells for specified values, name the ones that do not match

Ok, so I've tried writing my own formula to make this doable but am drawing a blank. I want to check multiple columns in a row to see if they contain a specifief value, let's say "V". Then in the ...
0
votes
1answer
62 views

How to multiply a row of values to a table with the same number of fields?

I have a row of value from A2:H2 and then I have a table of values from B7:E8 (both the table and row have 8 data points). How do I go about multiplying them? Please see the bellow illustration: +---...
0
votes
1answer
28 views

Excel 2010: Create a column chart that groups items and then charts them by year

I am having no end of angst trying to build what I thought would be a simple column chart. My data are in three columns: Player in Column "A", Year (from 2005-17) in "B", Points for each year in "C". ...
0
votes
2answers
85 views

Excel Conditional Format: Highlight duplicate values in a column based on the contents of another cell (same row different column)

I have a dropdown box in column A. Lets say I'm working row 10. I select "Highlight" in cell A10. When I do that, I would like a conditional format that highlights any cells in column B that match ...
0
votes
0answers
11 views

2010 Excel #REF when referencing table in same workbook

Excel - 2010: I have formulas referencing a table on a sheet in the same workbook. Every time I close the file and reopen it, I get a #NAME? in the cells. Inside the formula I have a #REF error for ...
0
votes
1answer
30 views

How does Excel determine default cell formula when a new line is added to a table?

It appears as though a certain column in my table has established a default formula that I can't seem to reset. When I add a new row to the table, the cell in that column always puts this default ...
1
vote
1answer
25 views

Turn result based on column with date

I have a column with dates. Those dates I want to assign to new columns "attended" and "upcoming", based on past 5 working days and upcoming 5 working days. I want to have following results shown: ...
0
votes
2answers
60 views

Is there a quick way to do a common date-time format in Excel?

Can someone please help me find, built into Excel (any version) a ready-made format for Date/Time like: MM/dd/yyyy hh:mm AM/PM I can't imagine this is not a common format? 10/05/2018 05:03 PM I like ...
1
vote
0answers
14 views

Separate old files with date information stored in excel

I have approximately 2000 files, of which I need to separate any files before a specific date (say, 2015). These are currently separated into subfolders for each categories of file (Say, projecttype1,...
0
votes
1answer
36 views

Excel Autofill with defined steps

Disclaimer: I think similar questions have been asked before, but the answers were all quite complicated, involving special cases or index functions etc. Is it possible to autofill a formula were the ...