Tagged Questions

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.

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...