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)

0
votes
0answers
3 views

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

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 after pasting doesn't help, Excel still sees them as ...
0
votes
0answers
7 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
15 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
10 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
10 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
22 views

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

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
9 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 ...
0
votes
1answer
22 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
15 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
32 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
9 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
0answers
10 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
19 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

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
27 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
52 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
17 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
23 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
20 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 ...
0
votes
2answers
31 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
25 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
24 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
42 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
25 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
38 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
43 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
30 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 ...
0
votes
0answers
25 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, ...
2
votes
1answer
30 views

How to unselect Excel Cell using Keyboard Shortcut?

One can select multiple Excel cells (either contiguously or not) using the keyboard shortcut Ctrl+Click. How do you deselect one or more of these previously-selected cells?
1
vote
2answers
47 views

Excel: Sum a column of text excluding duplicates in another column of numbers

I am trying to figure out a formula. I need to know how many times a certain issue happens based on case numbers. Meaning there are multiple entries under a specific case number for that subject, but ...
0
votes
0answers
16 views

Import image from MS SQL Database into Excel

I have a MS SQL Database where images are stored as byte[]. Is it possible to import these byte[] into Excel and convert them back into images? I already have a connection to the database in my Excel ...
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 ...
0
votes
1answer
14 views

Return transposed list of all strings in a row in Excel

In my Excel (for Mac 2011) sheet, the range B2:2 contains mostly empty cells, but some cells contain strings. I would like to print these strings into a transposed list beginning at A12. This list ...
2
votes
1answer
26 views

Excel Formula - returning data

I have a spreadsheet that has four columns of data. I want column number four (D) to display the value of column three (C) IF the number next to it in column two (B) matches ANY number in column one ...
1
vote
1answer
28 views

Show increase in trendline by using Excel vba

I have data in c5:c12 (sales1) and I plotted a graph and a trendline of this data. I also have data in d5:d12 (sales2). I would like to show an increase, graphically, in my existing trendline by using ...
0
votes
1answer
27 views

Excel converts datetime to other format where days are low enough to be months

I live in europe and our datetime format is usually dd/MM/yyy I have an excel spreadsheet where I have ALOT of dates But for reasons I do not know, Excel converts where (dd < 12) to mm/dd/yyyy - ...
0
votes
1answer
17 views

run macros assigned to many excel sheets of a workbook, with one click

I have one workbook with 8 worksheets. I have a macro assigned to each worksheet. I want to run all 8 macros from one worksheet in one click(by clicking one button, to run all 8 macros). How can ...
0
votes
1answer
24 views

How to link drop down cells in 2 different worksheets?

I am trying to make a spreadsheet for my work and I want to create a drop down list which have to contain "Canceled","ordered","accepted".(I know how to create this drop down list). Now I want the ...