Microsoft Excel is a commercial spreadsheet application written and distributed by Microsoft for Microsoft Windows and Mac OS X. If your question is about programming Excel in VBA then also tag it excel-vba. If it is about an Excel formula or worksheet function, then also tag it worksheet-function.

learn more… | top users | synonyms (2)

1
vote
1answer
17 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
1answer
12 views

Excel carrying information between tabs

My excel spreadsheet carried information from one tab to another. When I add information on one tab the same information appears on other pages. I opened it yesterday and some dates were changed to ...
1
vote
1answer
11 views

Counting the Cells in a Named Range without VBA

I have a disjoint set of 9 cells: A1,B3,C5,D7,E11,F13,G17,H19,I23. I have assigned a Name to these cells: MyPicksI have a simple formula to pick the value in one of these cells at random: ...
0
votes
1answer
8 views

How to autocomplete columns when going down one row in Excel 2013?

In my excel sheet I have values that could be automatically filled upon going down to an empty row. My excel sheet has this structure: If I go from Row 3 down to Row 4 i would have to insert the ...
1
vote
1answer
16 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
1answer
15 views

Count values in column B based on criteria in column D in Google Spreadsheet

I would like to count all the values in a column (Column B in this case) based on a criteria measured against another column (Column D) in the same row. So, going down the Column B, I should count the ...
0
votes
0answers
13 views

Setting Excel 2013 default theme

I want to change the default theme for Excel, so that when I open a new blank document, the right fonts and colors are in place. I've come so far as to make a theme and set it as default, but for some ...
0
votes
1answer
10 views

Setup powerpivot on a server?

I have a client that uses PowerPivot. They save the Power Pivot inside Excel files and have pivottable reports in the same Excel files. They feel that this puts to much strain on their computers. ...
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
1answer
19 views

Excel 2013 VBA programming

I'll start off my saying I'm trying to save time for a family member who is doing this program manually. Sheet 1 Column A is a start date Column B is a projected start date Column E is a Task Name. ...
0
votes
0answers
15 views

Powerpoint Excel Slideshow

Wondering if anyone has an idea of how to do this. A client of mine has a slideshow setup, on a continuously running screen, pulling in an excel sheet and updating it on every refresh to manage job ...
0
votes
1answer
33 views

Pasting mm:ss into excel - gets mistakenly formatted as hh:mm [duplicate]

If I paste a dataset including times in mm:ss format into excel, how can I prevent it from interpreting them as hh:mm? Changing the number format before or after pasting doesn't help, Excel still ...
0
votes
0answers
18 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
24 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
0answers
15 views

create an excel sheet to schedule employee annual planner

I want to create an excel sheet to schedule employee annual planner. If anyone submits leave application, while entering i need to find anyone applied for these date range. And also compared it with ...
0
votes
0answers
15 views

How to paste the data only in blank cells in ms excel from some other program using autohotkey?

Myvar:=5 F1:: xl:=comobjactive("excel.application") xl.range("i"myvar).select() myvar++ Send, {CTRLDOWN}v{CTRLUP} return In the above script, when I press F1 key it selects I5 cell automatically and ...
-5
votes
0answers
27 views

Excel: Can anybody help me to take-off quantities of loose furniture in the best and fastest way? [on hold]

Can anybody help me to take-off quantities of loose furniture in the best and fastest way? Information as follow: There are about 2000 different types of rooms and 300 sets of different furniture ...
0
votes
0answers
11 views

Changing cell style groups

I was sent here from stakoverflow When I create a new cell style in Excel, it goes in a group called Custom. The standard groups include Good, Bad and Normal, Data and Model, Title and Headings, and ...
1
vote
1answer
26 views

Round up or down to nearest multiple of .05 in Excel

Example, I have 221.52, 195.97, and 138.88. Now I want it to automatically round up or round down to the nearest multiple of .05, producing 221.50, 195.95, and 138.90. Is there a formula for this?
0
votes
0answers
21 views

Extracting HTML from Excel to enter in MySQL/Wordpress site

I have a WordPress site and an Excel document. I'm not familiar with Excel formulas so forgive me. The document contains a lot of names, email addresses and telephone numbers. I want to create a ...
0
votes
2answers
38 views

Excel Graph with 2 X-Axis Non-Linear Mapping

I have the following problem someone might be able to help with. I have two risk scales, one from 1 to 11 (old) and one from 1 to 21 (new), where the mapping is non-linear, i.e. old scale->new scale ...
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 ...
1
vote
1answer
10 views

Summing multiple cells that match row AND column criteria?

I've been given a file with 2 years worth of dates as column headers and sales info below. There's also a column that contains Year data. I'm trying to sort by both Year and Day of the Week. I'm ...
0
votes
0answers
29 views

Pairing Numbers in Excel

I have a list of congressman (and some of them repeat) and I’m looking for something that will fill in the matching distract number in the corresponding cell, so I can eliminate the risk of the human ...
0
votes
0answers
11 views

Access 2013 How to prevent from saving a record

I had created a form in access 2013 to add records to a table but I'd noticed that if I close the form without saving the record access still saves it to the table anyway. I would like to know how to ...
1
vote
1answer
19 views

Excel pivot table: Show values instead of summaries

I have a table of data like this: ID |Name |Brand |Model |License ------------------------------------ 1 |Foo |KOM |830 AC |A 1 |Foo |KOM |930 E |B 1 |Foo |CAT |980 H ...
0
votes
1answer
20 views

Excel Index/Match Sum

I have 2 worksheets in Excel. Both have data from a 2 different databases. The first tab has part numbers and costs (could be different day to day), the second has how many times that part number ...
-1
votes
0answers
10 views

Macro - Creates individual workbook based on template on sheet2 and data on sheet2 [on hold]

Option Explicit Sub CreateBooks() Dim rCl As Range, rRng As Range Set rRng = Sheet1.Range("A1").CurrentRegion.Offset(1) Application.ScreenUpdating = False For Each rCl In ...
0
votes
1answer
30 views

Excel: what makes .xlsx files use less space than .xls files?

I have some xls files without around 12 tabs containing data, links to other excel files, some data validation, and some conditional formatting. Saved as xls, they use around 1.2-1.5 mb each, but if ...
-1
votes
2answers
53 views

If one number then a different number

I have two columns of numbers on a data page, over 500 pairs. And I need a formula for the working page that will insert the second number in “column B” if the first number is in “column A”. So if my ...
0
votes
1answer
23 views

Schedule; want to check if everyone is present [on hold]

We're making a schedule in Google Docs / Excel We want to be sure we've got everyone in the schedule.... So we make an Excel per day we're everyone should be present in a day (row 6/7). I know I ...
0
votes
1answer
20 views

Run a Mail Merge using a Database from Excel [on hold]

I have an Excel database that lists all our employees and the training courses they have completed. Each course is listed on a separate line with the employee name. I would like to run a mail merge ...
0
votes
1answer
19 views

How to filter common values of two columns with advanced filter?

I have one column containing some common values that are in another column. I want to filter values from one column that are present in other column but without using VLOOKUP. How can i do it using ...
0
votes
0answers
24 views

How do I sum the last 4 cells in a column that have a value greater than 0 & contain only numbers in excel?

I have created a spreadsheet for working out the pay of our employees. The data starts in Row 14. Col A contains that week's pay date eg. 24/3/15 etc. Col B has the total hours the employee has worked ...
1
vote
1answer
21 views

Different colored columns in excel

I have data such as this: 1 | 2 | Y 2 | 4 | N 3 | 3 | N 4 | 2 | Y ... I need a bar graph that will display column 1 as the x-axis labels with column 2 as the y values. The color of each bar will be ...
-1
votes
2answers
39 views

Excel formula for average daily profit

I have a table that has just two columns, Date and Profit: Date Profit 24 - March 25.00 24 - March 19.85 25 - March 5.25 26 - March 6.36 26 - March 10.18 26 - ...
0
votes
3answers
26 views

Excel macro: Last non-empty cell in a column

This is a followup question to this one. The following formula can be used to find the value of the last non-empty cell in a column, in Microsoft Excel: =LOOKUP(2,1/(A:A<>""),A:A) My ...
-2
votes
1answer
15 views

How to transfer spreadsheet to downsized spreadsheet [on hold]

Can I copy an excel spreadsheet with 20 columns and paste into a template using only 8 of those columns with the column sizes slightly changed?
0
votes
1answer
15 views

How do I prompt a user with file “Save As” dialog using a macro?

I created an Excel macro to replace data from "Quote" to "Invoice", but after running the macro, I wish for the macro to continue to run and stop at: "Save As..." mode so that the user can provide a ...
0
votes
1answer
28 views

how to CONCATENATE array text?

Let the cell A1 has "abccba" Now I write a formula in the cell B1 =RIGHT(LEFT(A1,ROW(INDIRECT("1:"&LEN(A1))))) it gives value "a" or array string as{"a";"b";"c";"c";"b";"a"} Now when I concatenate ...
0
votes
1answer
21 views

Excel 2013, Vlookup - accessing different sheets.within a workbook

I Have a cell (lets say its A1) that specifies (from a drop-down list) a Sheet Name (AA BB CC DD etc) I want to pass that sheet name to a VLOOKUP Formula which would (if life were simple) be SOMETHING ...
0
votes
0answers
16 views

Hyperlink to file in TextMate

I use TextMate to edit LaTeX documents. Let's say I have the file foo.xlsx on my Desktop. In my .tex file how can I add a hyperlink to foo.xlsx, so that when I click on the link, the file is opened ...
1
vote
0answers
25 views

Office 2013 on Windows 8.1 gives out of memory error when opening files

We have the same error that has been posted here: Problems opening Excel attachments from Outlook Namely, when a user opens a file from the internet, the internal network or an outlook attachment ...
0
votes
1answer
44 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
33 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 - ...
1
vote
2answers
39 views

Microsoft Excel - comparing values of multiple columns against values of multiple other columns

I have a spreadsheet containing names. I have 5 columns of unique names, let's call the headers: Name A Name B Name C Name D Name E I also have 10 columns of other names (not necessarily unique), ...
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
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
44 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
32 views

setting upper and lower limit excel histogram

I am using the built-in data analysis tool to create a histogram for a column of numerical data in Excel. I'm doing the same thing for many different files, and they all need to have the same scale ...