The 2010 version of Microsoft's spreadsheet application.

learn more… | top users | synonyms (1)

0
votes
0answers
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
0answers
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
0answers
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
0answers
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
0answers
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
1answer
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
1answer
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
0answers
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
0answers
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
0answers
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
1answer
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
0answers
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
0answers
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
0answers
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
1answer
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
1answer
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
0answers
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
1answer
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
0answers
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
1answer
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
1answer
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
0answers
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
0answers
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
1answer
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
3answers
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
1answer
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
0answers
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
1answer
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
0answers
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
0answers
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
0answers
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
0answers
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
0answers
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
0answers
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
0answers
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
0answers
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
2answers
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
1answer
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
1answer
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
0answers
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
2answers
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
0answers
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
0answers
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 ...