The 2010 version of Microsoft's spreadsheet application.

learn more… | top users | synonyms (1)

0
votes
0answers
5 views

updating cell values based on entries in identical sheets

i have a work book, with a design sheet and three identical data sheets- having the same template. i want the value in sheet A1 of the design(master sheet) to change whenever the value of the cells A1 ...
0
votes
0answers
39 views

IF Statement with VLOOKUP

I'm trying to get a value from the ADD Taxable which is column 10 in the Check (sheet). I only want the value from column 10 if the Earn Type on Timecard (Sheet) has BONUS in it. I'm using the TC Ref ...
0
votes
2answers
21 views

Why is Microsoft Excel 2010 Showing a file open by another user when it isn't?

I am trying to open a file which tell me that it is open by another user and offers as read only. However, no-one is accessing the file. Yes, the file is available to more than one user but IS NOT ...
1
vote
1answer
17 views

Make short key for searching filter in Excel 2010

Can one help me to make a short key for the following procedure in Excel 2010 (ALT+DownArrow then E) . this used to go directly to search box in filter excel like shown in photo and if some know ...
0
votes
0answers
10 views

Excel documents are opening as maximized

I reinstalled win8.1, Excel 2010 and now, every time I open a document, my workspace getting maximized. For example: When I open one worksheet... even if it appears in small window on big workspace, ...
0
votes
0answers
8 views

Excel - Indexing non-financial data

I have an index of Bates stamped (numerically stamped, similar to page numbers) documents in Excel. There may be a series of 50 or more documents that are related, and I am looking for a way to ...
0
votes
0answers
22 views

How can I calculate a percentage within a pivot table?

Within the pivot table, I have column B that represents a count with the column heading of Count of Status, and, I have column C that represents a count of something else with the column heading of ...
0
votes
0answers
19 views

Excel: Create a Collapsible Master-Detail View From Another Sheet?

I'm designing an excel template for importing data (into another DBMS). The problem is, the data will be separated (normalized) into several tables in my DBMS (master-detail model). Let's say I have ...
-1
votes
1answer
25 views

Can I split a spreadsheet into multiple files based on a Row in Excel 2013?

I have a spreadsheet in excel 2013 which have multiple column and rows. I need to send some columns to different people separate files. Please anyone can help me in this. Please try to use macros, or ...
0
votes
1answer
13 views

Excel Data Extraction Formula

I am trying to run a report to evaluate the downtime of devices in a network. The OpManagement report doesn't have any customization available for output reporting. So I am looking for a way to ...
0
votes
1answer
45 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
34 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
27 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
24 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
45 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
18 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
27 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
28 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
16 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
21 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
15 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
15 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
52 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
34 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
37 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
39 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
13 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
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
21 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
24 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
16 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
25 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
39 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
40 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
82 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
43 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 ...