# Questions tagged [microsoft-excel-2010]

The 2010 version of Microsoft's spreadsheet application.

**0**

votes

**0**answers

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

**3**answers

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

**1**answer

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

**0**answers

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

**1**answer

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

**1**answer

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

**2**answers

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

**1**answer

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

**0**answers

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

**0**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**2**answers

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

**0**answers

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

**0**answers

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

**0**answers

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

**3**answers

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

**0**answers

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

**2**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**0**answers

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

**1**answer

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

**0**answers

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

**0**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**3**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**2**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**2**answers

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

**0**answers

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

**1**answer

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 ...