The 2010 version of Microsoft's spreadsheet application.

learn more… | top users | synonyms (1)

0
votes
1answer
39 views

excel 2010 Vba, looping through named ranges, Run-time error '1004':

I am assigning the same Macro to several OptionButtons. I try to determine in which named Range the cklicked OButton is located. So I get the Cell of the Button and loop through all named Ranges in my ...
0
votes
1answer
24 views

Excel Daily Average Profit

I have a table that looks like this..Just two column..Date and Profit: Date--------------Profit 24 - March------25.00 24 - March------19.85 25 - March------5.25 26 - March------6.36 26 - ...
0
votes
2answers
26 views

Finding a value in one colunm that matches another column then putting that value in a third column (excel 2010)

All of the values are texts since the are usernames that are from two different systems. so one column has: Column A Column B smit19108 Fred99015 Fred99015 Smit1908 ...
1
vote
1answer
23 views

How can I assign Excel keyboard shortcuts for macros that use keys other than Ctrl + {alpha character}

I would like to assign keyboard shortcuts to Excel macros that use keys other than the standard Ctrl + {alpha character}. Based on this post it sounds like it is possible but I am not sure how: ...
1
vote
1answer
42 views

Excel formula to show FORMULA

Ok, guys. I am 100% sure that a few days ago I saw and tested a real built-in Excel formula for showing a formula as text in any cell. Now, when I need it, I cannot find it!!! No VBA, no tricks. Just ...
0
votes
0answers
17 views

Excel formula If column B starts with… then columns D & E populate from a list

I'm working on a spread sheet where column B is filled with ID numbers. Column D and E correlate directly to the first few digits of the ID number. Example: B= 1.1.1 then D= Imaging and E= T.P. B= ...
0
votes
0answers
24 views

Multiple Values in one cell needing separate row in Pivot Table

I am looking for a solution on how to have a separate row in a pivot table for 2, 3 even 4 values in one cell. Example - Columns are as follows: Date, Job Name, $ Value, Distributor Quoted, ...
1
vote
0answers
25 views

Cell Formatting, 0.00 where blank value

I have some cells that are formatted as hours and minutes i.e. [h]:mm. If no value exists in a cell I want the cell to show 0:00 without having to manually type. It needs to be user friendly, so if ...
1
vote
0answers
12 views

How to extract contour lines from a surface plot in Excel

I have several surface plots. I would like to combine one contour line from each plot into a single plot. Is there a way to extract the contour line that excel generates?
0
votes
1answer
18 views

Excel VBA: How to use a unique username or save location for an export pdf macro

I have a macro that prints a uses the internal Excel method ExportAsFixedFormat to print a worksheet as a pdf and save the document to the desktop using a unique file name structure. ...
0
votes
0answers
14 views

How do I copy data to new sheet for a Log and then clear data entered?

I have created a sheet in Excel 2010 to fill in data for Purchasing. Once data is entered in the INPUT sheet, I would like to push a button to log the information into a separate sheet ("LOG" sheet) ...
0
votes
2answers
14 views

Weird Calculated Field behavior in a Pivot table in Excel

Intro: I wanted to add an index to a pivot table I wanted to add an index number (1, 2, 3, ...) to the rows of my pivot table. After some experimenting, I ended up adding a column to my source table ...
1
vote
2answers
46 views

Excel: How to connect to a sqlserver localDB

I have created a LocalDB that I can work with in MS sqlserver management studio 2014, linqpad, and visual studio 2013. Here is the part of the "connection property" dialog in SSMS which shows the ...
0
votes
1answer
31 views

when criteria does not match do nothing excel vba macro

I am implementing a macro that checks column E for dates that are 7 days away from current date. If cell date - current date = 7 then an email containing the row that has the matching cell, is sent ...
0
votes
1answer
37 views

Excel Issue in Conditional formatting

I need numbers to be assigned to variables and do conditional formatting. Eg: 1a will be 1, 1b will be 2, 1c will be 3 etc.. So, in the whole excel sheet, wherever I type 1a, the value of that ...
-1
votes
0answers
33 views

Office 2013 Data Extraction from multiple workbooks [closed]

I generate numerous time sheets for my client on a daily basis (varies from 6-12 daily) and usually work is performed at least 6 days a week. I need to populate the total number of hours (ST and OT) ...
0
votes
0answers
18 views

Excel hangs when trying to save a shared file

I have a fairly large spreadsheet (~ 5MB) shared between several users. While some users have no problems, some see Excel hang when they try to save their changes. It can happen when they are the only ...
0
votes
1answer
19 views

How to get latest date (most recent date) in Excel?

I have two dates in one column. I want get last date (large date or the most recent date) so when I use =MAX(A1:A10) it returns a value (42343) like this or similar. How to get the latest date by ...
0
votes
1answer
35 views

Excel VBA: Is there a command for printing to PDF (doPDF ver 7)

As the title suggests... I'm looking to expand my automating to include directly printing to PDF. The macro(s) I have written already formats the print area and page setup as I need it. But when I go ...
0
votes
0answers
8 views

Auto fill series in groups/sets in excel [duplicate]

I want to fill up a column of values such that the index is incremented after a group is indexed. So, for eg. if the group size is, let's say, 4; the indexing will be: 1 1 1 1 2 2 2 2 3 3 3 3 . . . ...
0
votes
1answer
12 views

Excel pivot table breaking up for whole number items

I couldn't think of a better title. Please bear with me! I have the data as the following image shows: I create a pivot table using the range 'Sheet1'!$A$1:$E$33. The table displayed is as ...
0
votes
0answers
42 views

Referencing a cell from another sheet [closed]

I've got a sheet named 'No.of Mails Data'! where the data is and i want to use my formula on another sheet =OFFSET(INDIRECT((CONCATENATE("B",(COUNTIF($B:$B,"*")-6)*6+2))),,,30,1) this is the ...
0
votes
1answer
16 views

How to look up multiple values

I have an excel document that I am using to sign out hand held scanners to users in a department. I have set this up so that I can scan the employees ID into column A and then scan the bar code on the ...
0
votes
1answer
19 views

Color fill cells if it contains a certain value [duplicate]

I have a list of cells that contain 1 of 12 values. I have 4 different colors that I want the the cell filled depending on the cell value. How do I do this? We are running Excel Professional 2010 Del ...
0
votes
1answer
23 views

How to fix a database after sorting only a few columns when other columns were hidden

I have sorted a giant database with lots of information when several columns were hidden. One of the columns was sorted by date and when I unhid all the columns, half of all the information in the ...
0
votes
0answers
15 views

Memory limits in Excel (functions lookup)

can I obtain an advice how many Excel files with what size can I have opened at the same and link with functions (lookup) in Excel 2010 32 bit system? Is there a way to predict how fast the ...
0
votes
0answers
17 views

Combine table in Excel

I want to do a training matrix in Excel and track its completion. My fist table represents all the documents on which we should (or not!) be trained related to job title. Doc Name | For all ...
1
vote
2answers
38 views

Multiple IF Statement

I have a question about IF statements. I wanted to use VBA, but the other guy I am working with doesn't know how to do it, so I am trying to only use worksheet formulas. So, I figured the best way ...
0
votes
0answers
14 views

Sumif specific colour in a row

How do I sumif the value of cells in a row which have a specific color. I have a large spreadsheet and need to sum the values in rows of data, but only if they are NOT an exception and show as a ...
0
votes
0answers
23 views

Excel LINEST returns #REF error when using non-rectangular array

I'm trying to use the LINEST() function on a named range. The function seems to work fine when the named ranges are typical rectangular arrays. However, if the named arrays are irregularly shaped, the ...
1
vote
3answers
38 views

I want to compare two columns in excel having 500000 records

I have two columns in excel file having almost 500000 records in each col. I want to check how many records from col 1 are present in col 2. I'm using below formula: ...
0
votes
0answers
16 views

Stop Org Charts Forming Over Multiple Pages in Visio

I'm new to Visio and trying to make an organisational chart using unique identifiers for the employees and their managers. I can get it do display all the right information, but when the org chart ...
0
votes
1answer
24 views

Multiple tables in one worksheet - how do I gather important info onto another worksheet?

Hope this doesn't sound too confusing: I have an Excel workbook consisting of 5 worksheets. First 4 worksheets contain data that has been manually entered over the last 4 years. The 5th worksheet ...
0
votes
0answers
33 views

Why is VLOOKUP returning wrong cells as data is refreshed?

I am creating a spread sheet which works out my material requirements based on future order forecast. I have live data in the workbook which represents the material on stock and they're location. I ...
0
votes
0answers
39 views

IF Function Combined with Median date range check across multiple sheets

I am trying to create a formula that checks if a single cell date falls between a beginning and end date using the median function, and if so returns a value. I have multiple sheets I would like the ...
-1
votes
0answers
22 views

Pictures in Comment disappear when I send this file via email

I have an excel file, where I put the comments in as pictures. See here for how I did it. However, when I send this file, the pictures disappear. How I can keep the pictures in the comments for ...
3
votes
1answer
75 views

How to plot multiple actual vs target in a chart? Up down arrows? And how to show cumulative?

I have Actual vs Target data for 5 teams. Subset of data table below. I want to show: Variance target vs actual Cumulative progress towards total target What is the best way to plot this data? ...
0
votes
1answer
16 views

How can I get Excel to display a long number in full?

I have already went through all previous questions but didn't find an answer to my question. I need to display this number 4935320154684405 but there's no way Excel let me do it. It displays ...
0
votes
2answers
41 views

Is it possible to have an excel workbook automatically save as macro-enabled if macro is added to the workbook?

Currently, in Excel 2010, when I try to save a workbook that I have created as a .xlsx file but added a VBA function or subroutine to, Excel gives a prompt asking (in a round-about way) if I want to ...
2
votes
1answer
41 views

How to turn a “many” row-based relation into a “one” column based layout

Pardon my English. I am looking for a method of transforming data for a set of products. The data set I have is a relationship where attributes are listed out in rows, and I want these attributes to ...
0
votes
0answers
20 views

Get original data source of pivottable

I have been sent a workbook containing a pivot table. The connection/source data used is an external database. I am aware that double clicking on a row will drill-down into the data, but I wish to ...
0
votes
1answer
32 views

Excel 2010 - VLookup -

I have two identities associated with one unique value in the table. I need to pull both the values in another sheet using vlookup - is that possible. Here is the example: Id Owner Name A1 Owner 1 ...
1
vote
0answers
27 views

Excel 2010 - Merge multiple connections into single worksheet

I have an Excel workbook containing several worksheets. Each worksheet has an external connection to a unique .csv file that is updated several times a day from different PCs. This is done so that ...
0
votes
1answer
15 views

Pivot table filter

Below is a simple representation of a huge data and its pivot table Data +------+------+ | Proj | Data | +------+------+ | ABC | S | | ABC | U | | ABC | S | | ABC | U | | ABC | U ...
0
votes
2answers
29 views

Adding a Scrollable Directory to a website built in Word 2010

First off, yes, I do know that Microsoft Word is not ideal for building a website. But my client is insisting on it since they want to be able to edit it later on their own and this is the software ...
1
vote
2answers
38 views

Show timestamp when cell is changed

I need to know how to show a timestamp in a cell in column D when a cell changes in that same row in column B. I edited this screenshot in paint to show what I mean more easily: The image I have a ...
0
votes
1answer
24 views

How to make a Custom List with sheet cross reference?

At the end of the month i get a excel file with a variable number of sheets. Every sheet has a value in the same cell: A1 I want to create a new sheet and display all the values of A1 on every sheet ...
0
votes
0answers
16 views

Formulas speed when opening/save the file

I have a file with many formulas, when i open the file or save it takes a lot of time before of the formulas, is thee a way to avoid that?
1
vote
2answers
34 views

Excel table not formatting new rows appropriately - where does formatting come from?

I have an excel table and all rows are formatted the same. When I add a new row, the formatting does not match the rows above - so every time I add a row I have to select the above row and copy/paste ...
-2
votes
1answer
41 views

try to fix my Excel formula

I have similar tables in sheet1 and sheet2. I want rows, with new names, to be added automatically to table in sheet2 if I manually add them to sheet1. Example: If I add a row with the name "Jane" in ...