A spreadsheet application by Microsoft. Use this tag along with [vba] if your question involves programming Excel in VBA, and with [worksheet-function] if it involves an Excel formula or worksheet function.

learn more… | top users | synonyms (2)

0
votes
1answer
23 views

Need help creating an Excel formula involving dates

I have a list of 18 varied dates which as they pass, I need to know how many of the 18 dates are left. Can I do this with an excel formula?
0
votes
1answer
17 views

Excel 2010 Conditional Formatting - cell/text colours based on value

I have a query regarding conditional formatting in Excel 2010. I have a date in cell P2. The function I would like is: In cell Q2 if a date is entered that is 7+ days after the date in cell P2, the ...
0
votes
1answer
11 views

Excel auto Text formatting based on values within a range of cells

Need help finding a way to auto format a text response based on values in another set of cells. There are 3 values in Column B,C, and D and depending on the highest value of the three, the adjacent ...
0
votes
1answer
43 views

Create graph of values, mean per day, grouped by variable

I have a spreadsheet containing the following values (slightly simplified): Date - day in number - Temperature - Windspeed - Hours of sun. Data example: 01-09-2000 - 01 - 20 - 15 - 9 02-09-2000 - 02 -...
1
vote
0answers
14 views

Need to select only one classification out of multiple values

I have a list of clients, products and their classifications in a Pivot Table (Client Number) (Products) (Classifications) --------1-----------------A---------------High --------2------...
0
votes
1answer
25 views

Execute batch file on computerA to open excel file and trigger macro on computerB

So basically, the reason why I need this is because we can't install excel in the server, so we will have to use another server(computerB) to host all our excel files and macro. Current process is ...
-1
votes
1answer
32 views

How to change the fill color of a shape using an excel 2013 button in vba?

I'm trying to develop an excel version of a baseball scorecard with diamonds representing first through third base and a pentagon for home plate. Currently I'm working with just the first players ...
0
votes
0answers
23 views

Get distinct count based on different parameters

I need to get the distinct count (how many times does a unique value occur) based on a few parameters. The table looks similar to this: Getting the Amount is not a problem, I use SUMIFS() with a ...
0
votes
1answer
32 views

Excel function: How to convert text data into numbers?

I have a paragraph of words that I want to filter and rank them in numbers accordingly. For instance, in one cell I have this: "Apple; banana; orange; pineapple; watermelon". And in return, I want to ...
1
vote
1answer
24 views

excel create a custom vba function?

Can anyone help me create a vba function to execute the following? In Sheet1 I have 3 columns A(product) and B(price) which are populated with 3000 items and 3rd column C(quantity) which is not ...
1
vote
1answer
14 views

How to prevent duplicated data in multiple Excel documents?

I am running company stats in multiple Excel sheets, such as budget, expenses, personnel data, subsidy data, etc. I have separated them in order to prevent having zillions sheets in 1 document. I ...
0
votes
0answers
66 views

Microsoft Office VERY Slow Opening Files on Network Shares

I manage several computers running Windows 7 with Microsoft Office 2010 and Microsoft Office 2013. Our users store and access many of the Microsoft Office files on a network share. For a typical file ...
0
votes
1answer
35 views

How to add prefix or suffix to range of cells in Excel?

I have cell A in excel full of images name without the extension I want to add ".jpg" as a suffix to these ranges of cells however I need to skip non text cells by not adding anything. Any help to ...
0
votes
0answers
13 views

In Excel 2013 PowerPivot, Table Properties button is grayed out. Why?

I have created 3 demonstration tables in Excel Pro Plus 2013: Items, Sales, SPerson. I have added each table to a data model, so they appear in PowerPivot. I have created 2 one-to-many relationships ...
0
votes
1answer
39 views

Formula for Ascending Sequence

I am trying to help someone generate a formula to return a simple sequential series of values. For example in cell C6 we inserted the formula: =ROW(A1) and in cell D6 we inserted the formula: =...
-1
votes
1answer
44 views

Change number in a word to a letter in Excel cell

Is there a formula that can make the number in a word in the cell change to a letter in a word in excel? For example:    P0rcupine → Porcupine.    Parr0t →...
1
vote
1answer
33 views

How to generate an excel chart that includes aggregating and grouping

My data looks like this Date Time Person Logged in June 1 2PM John June 1 2PM Chris June 1 3PM John June 2 2PM Chris June 2 3PM Bill June 2 4PM Bill I want to ...
1
vote
0answers
27 views

How to change the background of a Row, based on a choice in the Row?

I am trying to make it so when a choice is selected from a list, it will change the color of the row, based on the choice made. I am using conditional formatting, using a formula to determine which ...
4
votes
2answers
47 views

Excel row sampling

I have an Excel table with a large number of rows. I would like to take a random sample of say 100 rows and hide the rest, say display 1 row per 500 rows or completely random selection of the entire ...
1
vote
1answer
29 views

Excel replace multiple text options within one cell with other text

How can I replace one set of text options with another? I was thinking that an Index/Match combination might work, but I cant figure it out. Perhaps a VLookup function? For example: My report output ...
0
votes
2answers
23 views

Pasting Spreadsheet from Excel to Outlook, chart gets distorted

I have been able to copy a full workbook in the past and simply paste it into outlook to send the data set that I need to send. I recently updated the data set and included more data and now when I ...
1
vote
1answer
27 views

Excel, assigning text a number and summing them

I am making a recipe spreadsheet. What I have is an amount column and a measurements column. For example an amount of 1 and a measurement of cup (for a 1 cup measurement), an amount of 4 and a ...
0
votes
2answers
31 views

How do I compare a cell value with a range of values on 2 dirrerent sheets and return a Text I specify

In Excel I have 3 sheets in the same workbook. I want to compare column A on "Sheet 1" with Column B on "Sheet 2" and Column b on "Sheet 3". If I find an exact match on anywhere in column B "Sheet ...
-3
votes
0answers
32 views

Excel/Word Table Relationship

I am trying to provide greater efficiency for coworkers with regards to writing reports involving unemployment data and as of right now we take monthly updates from pdfs and manually input them into ...
0
votes
0answers
42 views

How to create stacked bars with timeline in Excel?

Here is the data: I want to make timeline in Excel with stacked bars so that each stack within a single bar corresponds to a given time period. As such, instead of having separate bars for all the ...
0
votes
1answer
24 views

For 2 columns of data (wlog A, B), make a third column with entries that appear in both A and B

Apologies if this has been asked before. Suppose we have 2 columns of data, without loss of generality A and B. I would like to be able to produce a column C which contains entries that appear in ...
0
votes
1answer
24 views

Remove space in cells that is creating a new paragraph within the cell

I have few cells in my .csv file that has space between lines that is creating a new paragraph within the cell. So when I click on that cell only the first line of the cell is displayed in the formula ...
-2
votes
0answers
14 views

Comparing two tables with one column of each containing some common values and some different

Given two tables, whose second columns data's value changes periodically. Also new entries of first columns data happen and their deletion also. I want to compare these two tables. If possible I ...
0
votes
1answer
55 views

Make a formula that has specific-cell-references change every n'th row in Excel

I have a big Dataset it is structured in such a way that always 16 rows belong to the same group. (e.g.: A1, A2, A3, A4, A5, A6, …A16 -> Group1; A17, A18, A19, A20,…,A32 -> Group2..etc.) I would like ...
4
votes
1answer
66 views

Make dropdown list show hyperlinks

I have a collection of all the different part numbers for different versions of a single part, and each of them is hyperlinked to their specific different drawing in pdf form. I would like to put them ...
0
votes
1answer
51 views

Why does Excel give me a false value? [duplicate]

2,5+4,5=7, right? I didn't understand why Excel is giving me a false value in this case. I'm sorry my Excel is in Portuguese.
0
votes
0answers
17 views

Macro to Split data by filtering 2 columns [closed]

I want a macro to split data by filtering 2 columns and paste it to New sheet one after the other with Header. In the above example I want to first filter column 3 for 1 value and then column 6 for ...
1
vote
1answer
66 views

Deriving elegant or 'nice' axis values on graphs using Excel - lookup function or formula

I am trying to automatically calculate the most elegant y-axis scale (maximum, and division value) for some bar charts. I'm using Excel integrated with a dashboard tool (SAP Dashboards) to display two ...
0
votes
0answers
24 views

Excel Data Organization In Single Column

I am working in Excel 2016 and I have a list of data that is all in one column. There are 17,000 rows and I can't take the time to go through and manually edit and reorganise the data line by line. ...
0
votes
1answer
23 views

Editing CSV file in Excel always converts number column to scientific notation [duplicate]

I have a CSV file that I'm editing in Excel 2013. In the file there is a column that contains numbers e.g 688087123456789. Everytime I open the CSV file in Excel, it converts the number to scientific ...
0
votes
1answer
23 views

Excel Spreadsheet data movement

I have copied data from a main list on one tab on to another list on the next tab of the same sheet. I have done this by copying each cell across individually. Now, when I sort the original sheet (...
0
votes
0answers
16 views

Excel reconcile encodings

This question is more tricky than other questions related to encodings The story is, a csv was exported without the utf8 BOM, and opened in Excel. The data was not recognized as utf8, and accents ...
0
votes
1answer
11 views

How do I add a data point to an already existing line graph?

I have an already existing line graph with monthly data from an excel worksheet. How to I add the next month's data to the worksheet?
0
votes
0answers
12 views

How to avoid obligatory scrolling difficulties when filtering large amounts of data in Excel 2016 for Mac?

Here's a hypothetical scenario in which filtering works well in almost every other spreadsheet software, but not Excel 2016 for Mac: You have a large set of data (let's say 1000 rows), you scroll ...
0
votes
1answer
37 views

How to copy multiple lines from MS word and paste them into Multiple lines in Excel?

I have a MS word file containing names and emails each name and email is in a separate line, I want to copy it into excel, is there any way that I can copy the whole page and have it pasted into ...
-3
votes
2answers
44 views

Using the syntax IF THEN ELSE, to calculate Tax charge

1) If the total amount to be subjected to tax is 30,000.00 2) The first 2,200.00 to 3,000.00 is taxed at 25%. 3) The second 3,000.01 to 5,900.00 is taxed at 30% 4) The remaining amount is taxed at 35% ...
1
vote
0answers
33 views

Excel - copy text from url to cell

I've got an excelsheet containing url's like so: | column A | column B | --------------------------------------------------- | www.example.com/page1 | | www.example.com/...
-1
votes
1answer
65 views

Division formula in excel

I have 2 column Price, % of Total Price how do I get the value of % of total price using VBA. I notice that there is no divide function for excel WorksheetFunction.Divide so how do I loop thru my ...
0
votes
1answer
35 views

How do I set up a macro where it will do the following actions each time

I'm a complete newbie here and am stuck with a task I have to repeat over the next few days. I would very much appreciate your kind help. Thanks so much in advance. Setup: There are 2 sheets. ...
0
votes
1answer
23 views

How to find what causes the privacy warning in Excel?

There is this Excel file I made, it has no macros or any such things, it's just all formulas, and I copied some data into it from various sources (ERP Excel export, copy-pasting from web applications.....
0
votes
0answers
17 views

How to count each value occurrence within group of arrays in Microsoft Excel 2010?

I have a network related spreadsheet, and the part I need to work on is multiple groups of arrays that contain values (port numbers). I'm trying to figure out a way to make a pivot-table that counts ...
-1
votes
1answer
44 views

vlookup - Is it possible to use vlookup to pull specific info like this?

I am trying to pull the following from each group of Numbers - CHG000509443 05-16-2016 22:48:41 for the Requested CHG000509443 05-17-2016 13:14:35 for the Approved Note 1 - It is always the first ...
-1
votes
1answer
21 views

How can I combine the contents of two cells in excel? [duplicate]

I'd like to combine the contents of A1 "Hello," with the contents of B1 "It's Me" in the cell C1 so it will read "Hello, It's Me." I know I can do it manually, but I have to repeat the process ...
0
votes
0answers
18 views

PERSONAL.xlsb not opening automatically

For some reason, my PERSONAL.xlsb file is no longer opening automatically. I've checked the Trust Center and the file location (C:\Users[user]\AppData\Roaming\Microsoft\Excel\XLSTART) is a Trusted ...
0
votes
1answer
21 views

Auto refresh Excel worksheet after changed by external application?

I have a question similar to this one but I'm just using an Excel file, no CSV involved: Open a .csv file in Excel and have it update whenever .csv file changes I have an Excel file that I ...