The 2010 version of Microsoft's spreadsheet application.

**0**

votes

**0**answers

3 views

### How do i calculate 'TRUE' values across multiple pages of workbook in Excel?

I have devised Audit workbooks with up to 21 pages with Yes/No tick boxes for each question. I have linked each tick box with the Yes/No cell for each question (very time consuming) but I need to now ...

**0**

votes

**0**answers

17 views

### NTFS - allow a user to read, write and save an .xlsx file but not delete it or create new files and folders

I would like to allow a user to work with an already created Excel workbook -say A.xlsx- in a folder. It would be able to open, modify it and save it. It can not rename /delete it or other files nor ...

**0**

votes

**0**answers

24 views

### EXCEL. An array that displays the most recent set of data(based on date) of a customer

I'm looking to pull data from one sheet into another sheet where I pick the most recent date of information on a person. So I may have 50 entries for Bob, but on sheet 2 I just want to post the most ...

**1**

vote

**0**answers

25 views

### Conditional formatting with several conditions depending on different cells

I currently have a table in excel that looks like
.
The table shows four projects, each with three stages with each having an expected and actual start date for that stage.
I want to create a ...

**-1**

votes

**0**answers

9 views

### Parse Excel to xml using vba using Excel column data as XML attributes

I have an Excel table with data in column1 and id's to this data in column2.
column1;column2
dataCol1Row1;dataCol2Row1
dataCol1Row2;dataCol2Row2
Using any of the VB examples given in Parse Excel ...

**0**

votes

**1**answer

13 views

### Advice making a multi line chart with daily count data

This is what my raw data looks like.....
raw data image
I would like to use this data to create a chart that display's Install date in the X axis, a daily sum of records for each installed by name in ...

**0**

votes

**1**answer

15 views

### Excel Convert Time with units

If I have a cell with time data formatted as "1m 11s", how can I convert this to something excel can understand?

**0**

votes

**0**answers

9 views

### How do I assign a dollar value to a word in a specific cell?

I am trying to assign a dollar value to a cell titled "internal bridge." Cell B4 (Internal Bridge) should equal $500. In cells B5 - B18, I intend to use number values (1-50) to represent the number ...

**0**

votes

**0**answers

13 views

### How to tell which labels have been changed in a pivot table?

I'm working in Excel 2010 with a few pivot tables where I think some wrong edits were made on row labels. I need to find the edited labels, check them for mistakes and correct the wrong ones.
The ...

**0**

votes

**0**answers

12 views

### Excel: Add new rows to a table with a subtotal row, when data added to a specific column on the last row

How do I get an Excel table (with a subtotal row) to automatically add a new row when I enter data in column C of the last row?
At the bottom-right of the table I have 3 cells with basic SUM formulae,...

**0**

votes

**1**answer

11 views

### Creating a For All function in Excel

This might be hard to explain, but I am trying to create implement a formula that compares a bunch of values of "TRUE" or "FALSE" and then displays an output a corresponding cell that states if at ...

**0**

votes

**0**answers

39 views

### Getting data from same row as matched cell on separate sheet

I need to match A2 with Sheet2!A:A, but the value I need is a cell on Sheet2 in the same row as the match.
Let's say A2 matches Sheet2!A20. I need the formula to return what's in Sheet2!E20.
I ...

**0**

votes

**0**answers

14 views

### Defining a range in excel for index/match

I'm trying to return a "best" value, but there are two criteria for a threading calc. One column has stress, which just has to be higher than a given value, and the other would be where you want the ...

**-3**

votes

**0**answers

15 views

### Get data in MS Excel from Active Directory

I want search data in activer directory from a value excel cell, like I have user ID in excel sheet want to retrive frist name and last name of that user ID. Can someone help me to resolve this? Using ...

**0**

votes

**1**answer

26 views

### cannot find any saved .csv files

I did search through many of the .csv realated topics that the search returned so I hope this is an appropriate new question...
I am trying to setup an excel spreadsheet using a .csv file as the data ...

**-1**

votes

**1**answer

212 views

### Excel, No longer receive the option to open files in a different format

I have a web app that saves files as .xls but are actually well formatted .html. The files have always opened with excel producing the following warning:
The file you are trying to open 'file.xls', ...

**-2**

votes

**0**answers

11 views

### Excel pivot table grouping

I'm using excel 2010 and I want to create a pivot table that shows times between breakdowns in groups of 1 hour. The problem is that no matter what I try I get the cannot group selection error. I ...

**1**

vote

**1**answer

20 views

### Excel: Compare multiple columns to see if less than value in another column for all rows

I am trying to compare data across multiple columns to see if each cell is less than a value in a single cell on the same row.
Column B contains the mean across all employees for the variable in ...

**-2**

votes

**0**answers

14 views

### How to automatically transfer Excel data with no fixed cell reference to a new worksheet or workbook with specified fields

How do I AUTOMATICALLY transfer mixed data to go to specific fields in a new worksheet or workbook.
All the Excel data are on separate worksheets.
The columns and rows are not similar.
The lables ...

**0**

votes

**1**answer

36 views

### Separating Names In Excel

I have a list of 60K names. I need to separate them into different worksheets based on their length.
I have been doing it using normal way using len() formula, filter them and copy paste them to ...

**0**

votes

**1**answer

15 views

### Mailmerge 2 spreadsheets

Can I mailmerge in Word 2010 using 2 Excel spreadsheets? Have found article that says Get Data and then click Data Source but cannot find this in Mailmerge Wizard as an option.

**0**

votes

**0**answers

44 views

### without iteration condition, =A1+C1 in C1 cell,

I've tried iteration condition, but it is not taking only the 'A1' value, if I put some value in some other cell, C1 is calculating like =A1+C1 in C1 cell,means
A1 value is 5, in C1 i put this farmula ...

**-2**

votes

**0**answers

38 views

### Excel - Auto Populate Break Schedule based on Weekly Schedule [on hold]

Ive been racking my brain trying to figure this out, ive searched and searched and I guess I just dont know enough about excel to be able to do this.
I have 8 sheets to work with, The first one is ...

**1**

vote

**1**answer

22 views

### Excel Get minimum value, and If two cells match from a row, return values from the consecutive 3 columns

Here's a simple explanation of what I'm having trouble with.
Get minimum value, and If two cells match from a row, return values from the consecutive 3 columns.
SUPPLIER A
F4: PRICES SUPPLIER A
...

**0**

votes

**3**answers

20 views

### How do i align multiple columns in excel by name and sales?

Please ref attached image.
I need to align sales for the agents in single row to match their names. The problem is that in Jan the number 1 agent may be on 5th spot and in 12th place in the third ...

**0**

votes

**1**answer

19 views

### How can I remove a cell from a range for a property lookup array

Lets say I have a value, A123456, in a column A, row 1, and i want to check if I have the same value in other rows of the same column, regardless of the length of the values as long as it has the same ...

**-1**

votes

**0**answers

10 views

### How using (office 2016) Excel VBA, Auto copy and/or save a web page image

EXCEL 2010. After navigating to a web page using Excel VBA I wish to copy an image into excel AND/OR save it to a documents folder IE:
<img alt="" src="/images/rp_251x251/Product/94031/...

**-1**

votes

**1**answer

31 views

### figuring Golf Handicap

Presently we use the following formula and it works great:
=IF(COUNTIF(D4:AB4,">0")<3,C4,IF((((SUM(D4:AB4)-(COUNTIF(D4:AB4,">0")*36))/COUNTIF(D4:AB4,">0")))*0.9>20,20,(((SUM(D4:AB4)-(...

**0**

votes

**0**answers

15 views

### How can I create a cell that only allows 1 character to be entered in Excel 2010 and then automatically goes to the next cell

I'm using Excel 2010 and would like to create a cell that only allows 1 character to be entered and then automatically goes to the next cell to enter another single character?

**-3**

votes

**0**answers

19 views

### please help me to put a formula in this cell?

the calculation in the cell E is based on the net change in F and G. For example "when i enter an amount in the cell F3, then it should add up with the amount entered in the cell D3. and likewise when ...

**0**

votes

**0**answers

23 views

### How to *display* a complete HTML table structure inside a single Excell cell?

Can anyone suggest a way that I could accomplish the following?
I am fairly skilled with VBA and I am willing to call/use a 3rd party approach (like maybe the WKHTMLTOPDF utility or something) if ...

**0**

votes

**0**answers

9 views

### How to remove “cannot empty clipboard” prompt with Excel 2010 — no add-ins active

I keep getting the message prompt from Excel 2010 "Clipboard cannot be emptied" every other time I copy a cell while there is a previous cell that was selected as being copied.
The prompt would also ...

**0**

votes

**0**answers

6 views

### adjusting groups and transposing values

In order to convert table values into one column I used a nice formula, which you can see at the top of this picture. Now I have done this, I want Column A to be adjusted in column F, like I have done ...

**-1**

votes

**0**answers

14 views

### How do I transfer data values from a chart to a table on Excel?

I have data that is listed in a chart, for example
Hello1
World2
Biscuit3
I would like to transfer this to a data table, but the numbers follow a specific pattern. For example, the table would be:
...

**0**

votes

**0**answers

13 views

### Excel, Populating a cell based on what in types in another cell

I am currently working with excel and I am having a bit of difficulty.
I will try to say basically what I am doing and what I would like to do.
I am making a sheet that I would like to be able to ...

**-1**

votes

**0**answers

33 views

### Excel External Referencing Across Work Network

I've invested a large amount of my time over the past week to building a list of document types and descriptions into a series of Excel workbooks which rely heavily on external referencing (to each ...

**0**

votes

**2**answers

18 views

### Using Excel VBA to find last matching row

I have a spreadsheet that includes a date and an ActionCode column. I'm using the Worksheet_Change event to run some code after the user enters an ActionCode. I'd like to have a procedure that (when ...

**0**

votes

**1**answer

33 views

### Excel: How to highlight highest value cell where duplicate in another column

I have a report containing a log of members details and any actions carried out on their account.
As it is a log, there are duplicate membership_numbers in column A. Column B is the action on account ...

**0**

votes

**1**answer

20 views

### Open separate instances of workbooks excel 2010

I've seen a few questions of this, but most were really old. However it seems I have an interesting twist.
The basic question is how to open two workbooks in two different monitors in Excel 2010. ...

**0**

votes

**0**answers

15 views

### Pivot table with head and sub groups

This is an easy example of the task I have to perform. I need to create a pivot table from a data table that looks like this one:
But there are two challenges:
Empty cell at the left top of the ...

**0**

votes

**1**answer

27 views

### Replicate cell from above in blank rows in Excel

I have a data frame like this (including spaces):
1/4/2015 2 CREDT CARD SETTLEMENT
1/4/2015 3 Cash
1/4/2015 4 Cash
1/4/2015 5 Cash
1/4/2015 6 Cash
1/4/2015 7 ...

**0**

votes

**1**answer

19 views

### Excel 2010 hangs when entering data direct into a cell but allows pasting

I have a couple of largish (20Meg) workbooks with multiple sheets. On one sheet in each work book attempting to add data to the bottom of a list of cells causes the system to hang and leaves no option ...

**0**

votes

**1**answer

18 views

### If then statement with a referenced date range?

Is it possible to create an if then statement with a cell referenced date range? For example, currently the formula is working like this, but I don't want to have to update the date in the formula ...

**0**

votes

**1**answer

50 views

### Excel 2010 formula?

I need help with a formula for the following:
L6 needs to show a date which is the date in K6 + the value (days) in J6. However if there is no data or only text in either K6 or J6, cell L6 should be ...

**-2**

votes

**1**answer

13 views

### how to find and highlight similar texts in Excel 2010

I am not pro in Excel. I have an excel table that I need to find similar values and highlight the the remaining texts.
I have read some questions here but it was not helpful in my case.
I would ...

**1**

vote

**1**answer

34 views

### Excel - List data from 4 columns

I have an excel sheet where I want to make a list based on data in 3 columns. See the image for how the basic things looks currently.
I have names in column A and then in column B,C and D is a ...

**0**

votes

**1**answer

16 views

### Need formula to add enough zeros to total 10 characters

I need to tweak the below formula, so that instead of always adding 5 zeros, it adds enough zeros to equal 10 values (characters). I'm using this in a system (iCIMS), and the result (depending on the ...

**2**

votes

**2**answers

36 views

### Searching an array from bottom to top

I have a table array $E$14:$G$851. Column E just contains unique identifiers, lets say a/b/c/d etc, column F contains hundreds of numbers all less than or equal to 20 and column G contains the values ...

**0**

votes

**0**answers

26 views

### How do I add multiple date values? [on hold]

I already used the function
=IF(AG2<(TODAY()+2),"DELIVERY DATE",IF(AG2<(TODAY()-1),"DONE","ON GOING"))
but the value of "DONE" is not working. Please help me out.
This is the criteria:
if ...

**0**

votes

**0**answers

20 views

### Separating two runs of data

I am taking data measurements on a machine (measuring laser power) It runs at 10% power, then 25%, 50, 75, and 100 with cooldowns in between for two separate optics. Each run is not a constant length ...