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
2answers
3k views

How to format Excel cells to show duration in years and months?

I can't figure out how to do custom formatting that would format input "1/5" as "1 year, 5 months", or "5,0" as "5 years". I do want the cell to retain original input of "1/5" but visually display "1 ...
0
votes
0answers
6 views

Excel drop down with google drive

I made an excelworkbook with several worksheets. On each worksheet I have drop down menues. When i open it on another computer, thers the last arrow from the drop down stil there, but it does not ...
0
votes
3answers
3k views

Find column based on header, search it for value, and return row number of found value

I'm trying to write an excel formula that can get the value of a cell based on the value in a corresponding cell in the same row. Here's what I have so far: =INDIRECT(ADDRESS({Need to figure this ...
0
votes
0answers
6 views

Hide user form on non active workbook?

I have a user form that when a workbook is opened, will show a user form with command buttons. I want to be able to open another workbook and not see that userform on the other workbook. I only want ...
1
vote
1answer
21 views

AVERAGEIFS values that are not NA

I have the following AVERAGEIFS that averages column I grouped by the values in column B = AVERAGEIFS(B:B, A:A, A:A) Problem is, sometimes, the column B sometimes contains an NA() error. How do I ...
1
vote
1answer
23 views

Excel Vlookup Error for Some of My Text

I have an Excel report with web page titles that I am trying to match corresponding page views to using VLOOKUP. The lookup table is a separate Excel file exported from Google Analytics. When I ...
1
vote
2answers
3k views

Format Change Event for Excel VBA

I'm trying to prevent people from modifying (most) of my spreadsheet while still alowing them to use the sort function of the AutoFilter. What I've done so far is used the Worksheet_Change event and ...
2
votes
2answers
3k views

VBA to move specific data from one column to another

I've tried requesting help with this before but have received no helpful responses. I need a Macro/VBA that moves any word in red from column A into column C as a list. However if the same word is ...
0
votes
2answers
20 views

Excel - How to return the first number only string that is between 7-10 characters long in a large body of text? (preferably Formulas only)

I'm trying to extract some numbers from a few cells that each have a large body of text. The number strings are accompanied by certain words that precede the number string I'm trying to extract. ...
-3
votes
0answers
12 views

How can I delete duplicates in one column, based on dates in a second column?

There may be no duplicates in column A, there may be many. Column C contains creation dates and I want to delete all rows except the most recent. If it can be done in VBA that would be good, otherwise ...
1
vote
2answers
1k views

Chart Series name referencing cell address Excel 2010 VBA

I am using Excel 2010. I have a XY scatter chart built and formatted the way I like. I reuse this chart many times, so I just copy and paste the chart into a new worksheet containing the new data ...
-1
votes
1answer
19 views

Excel formula where the outcome remains unchanged when values change in future

A B C 1 Area constant Land value 2 0.2500 200,000 50,000.00 3 0.3650 200,000 73,000.00 4 1.2540 200,000 250,800.00 5 0.2580 ...
3
votes
2answers
8k views

Excel subtracting dates does not work, see description below

I have two dates for eg. 12/02/2001 and 22/04/2001. I want to get the difference between the two in days. But when I try = A2-A1 is gives me #VALUE! On the other hand, =A1+1 works by adding 1 day. ...
0
votes
0answers
27 views

How do I make form fill out to different sheets based on the month?

I have an exercise and diet log that I fill out every other day and I want the data to move to another sheet. Sheet 1 looks like a worksheet and I want it to move (I think the best way to do this is ...
0
votes
2answers
15 views

How to find the number of rows that have date time fields between 5 and 6 PM

I have a phone log that I want to report some data off of. All of the solutions out there that I have looked up seem to assume I only have a time value and that they don't include an actual date. I ...
2
votes
3answers
170k views

How to Merge Data From Multiple Excel Files into a Single Excel File or Access Database?

I have a few dozen excel files which are all of the same format (i.e. 4 worksheets per Excel file). I need to combine all the files into 1 master file which must have just 2 of the 4 worksheets. The ...
1
vote
2answers
21 views

Mailing multiple mailto: links in an Excel spreadsheet

I have an Excel spreadsheet that has a list of mailto: hyperlinks in one of the columns. I'd like to be able to send an email to a selection of them, but clicking on one- even as part of a selection- ...
6
votes
4answers
89k views

How to combine values from multiple rows into a single row in Excel?

I have a data dump in Excel that consists of annual customer data for two different values. The data was provided with a separate row for value for every year and customer. I.e. it looks like this: ...
1
vote
3answers
22 views

How to combine values from multiple rows into a single row? Have a module, but need the variables explaining

I'm completely new to VBA and trying to implement the excellent looking solution here by Raystafarian How to combine values from multiple rows into a single row in Excel? (the revisited version). ...
0
votes
1answer
14 views

Lock Drop Down Cells and Enable Use - Excel 2013

I would like a drop down list in a cell. I would like to lock the cell so it cannot be moved or altered but changes other than selecting from the drop down menu.
2
votes
3answers
34 views

Excel Formula-Return Value based on looking at two separate values (either/or)

I am using this formula to return a value from table below: =IF(ISNA(VLOOKUP(A2,USUB,1,FALSE)),"No Fruit Found",VLOOKUP(A2,USUB,2,FALSE)) USUB table has this data: Fruit Fruit Code ...
3
votes
1answer
508 views

Replace contents of Excel column with realtional data from another column/sheet?

I have two excel sheets that have been exported from MySQL, with relational data in them, and I need to replace the reference ID's with the actual data from the relative column. For example, in one ...
2
votes
2answers
22 views

EXCEL HELP in transposing the columns to rows

Input : MACK 113 445 25 JACK 345 PIKER 30 23 I want the output to be : MACK 113 MACK 445 MACK 25 JACK 345 PIKER 30 PIKER 23 Can anyone please help me out . ...
0
votes
1answer
21 views

If < formula is not working on all my cells

I need to determine if my players play slots or tables based on if they have higher slot or table points.I typed in the formula =IF(D2
0
votes
0answers
115 views

How to use my custom icon in the MS Office 2016 Quick access toolbar?

Is there a way to use custom icon for the Quick access toolbar in Microsoft Excel, Outlook, etc. It looks like Microsoft doesn't allow to use custom icons anymore. If so, maybe there is to create an ...
0
votes
2answers
3k views

How can I graph survey results in Excel?

I would like to graph my survey results with the numerical values of the responses listed on the vertical axis and the questions listed on the horizontal axis. For example, I imagine the questions ...
0
votes
1answer
293 views

What causes Excel to raise an error about one or more formula references?

Upon saving my Excel sheet, I obtain following error message: We found a problem with one or more formula references in this worksheet. Check that all the cell references, range names, ...
1
vote
1answer
3k views

Excel Workbook Desktop Shortcut with Auto password?

I've got a bunch of password-protected Excel workbooks on my secured LAN (no wan) computer. Is it possible to parse the password into a shortcut so it would automatically open a workbook as long as ...
0
votes
1answer
21 views

Keep command button visible while scrolling down worksheet?

Is there anyway to keep a command button visible and while you are scolling down a long worksheet, you can still see the button scroll with your worksheet? I know there is the freeze pane but I would ...
0
votes
2answers
49 views

How do I graph this on excel?

Is it possible to have an x-axis with subgroups? For example, I need to graph Categories: Greeting (1.1, 1.2, 1.3), Call Reason (2.1, 2.2, 2.3, 2.4), Conclusion (3.1, 3.2, 3.3) , Accuracy (4.1, 4.2, ...
7
votes
4answers
17k views

Can you pull Excel data from an external (and dynamic) .csv file?

I've got a script that outputs a number of performance metrics for a computer into a .csv. The Excel does a basic stats check for standard deviation, etc. I realize you can import .csv files into ...
0
votes
3answers
18 views

Variable sliding window in Excel

I am using Excel 2010, but I presume this would be solved the same in any version of Excel. I have data that I would like to sum - essentially providing a sliding cumulative value. For example, on a ...
0
votes
0answers
16 views

How to embed a file in an excel spreadsheet in a compact manor

Wanted: Embed the file in the spreadsheet (no links to external files) No image or a text only image. When you embed a file w/ `Insert > Object > Create from File`, it inserts it w/ a large image. ...
0
votes
0answers
16 views

Matching postcodes on 2 worksheets. Looking up corresponding data and recording alongside postcode

Two tabs in an Excel 2013 spreadsheet. One tab is named Homes Data and the other tab is named Ratings Data. Column O in the Homes Data tab is a list of postal codes and column G in the Ratings Data ...
0
votes
1answer
16 views

Count specific assets (one column) which belongs to unique users (depending on another column)

To get the total of In Stock. I used this formula and it works. but this formula works for specific text. =SUMPRODUCT((A2:A6="In Stock")*(B2:B6="Laptop")) I need simpler formula to count rest ...
1
vote
2answers
17 views

Total value based on column conditional

In the following image, how could I get the values for cells C9, C10, C11? In case it's not clear, what I need is for a function that will return the value of a cell in column C, depending on the ...
-2
votes
0answers
22 views

Excel 2010 and VBA

I'm having trouble setting up a VBA script to successfully run in Excel 2010 page set-up. I was hoping to automate adding a repetitive Header Title, top right page x of x, and LFooter stacked ...
0
votes
0answers
22 views

Windows 7 Professional Taskbar Grouping Disappears (Not using Aero Theme)

I like using the grouping function with Windows 7, yes our company is still on Windows 7. However, when using Outlook 2007, ("yes 2007") and excel 2007 when I have multiple emails or excel files open ...
0
votes
0answers
11 views

Create table out of existing table matching a condition

I want to create a table in Excel that extracts the part of a table that matches a certain condition. If possible without using macros. Here is a plot: A B C 0 1 6 2 12 3 18 ...
1
vote
1answer
7k views

Windows 7 can't open Excel 2010 .xlsm files?

I just reinstalled Windows 7. When I installed Office 2010 I deselected some components to save disk space. Now, I can't open xlsm files. I would like to know which components in the Office ...
-2
votes
0answers
35 views

Compare two Columns and delete the gap Using Macro

I have an Excel file and i want to compare the date in columns A and D and delete the gap between them. For example based on this picture: Time in column A start at 15:25:15 and in D at 15:23:52. ...
4
votes
2answers
2k views

How can I write “use this cell or, if blank, use this other cell” in Excel 2007?

I am trying to show the Days between NOW() and the dates (dd/mm/yy) in either Column B or Column C - depending which one is not blank. A B C 29/03/10 01/04/10 29/03/10 ...
5
votes
8answers
54k views

Microsoft Excel returns the error 'Document not saved' after generating a 2GB temporary file

Summary Saving an Excel workbook sometimes runs very slowly; A huge temp file is created; You get a 'Document not saved' error; Your current Excel session cannot save the file, no matter what you ...
0
votes
2answers
25 views

How to permanently color a column in Excel

How do you set a column or row to always be a certain color even when adding rows or columns? If you shade/color a column normally, when you add a row or copy paste another cell into that column it ...
0
votes
0answers
13 views

Screen changes randomly while entering data in cell

The screen changes up or down as I enter the data in a cell, once I press enter the screen moves back to the selected cell. I have the same problem while using Word.
-1
votes
1answer
25 views

Controlling formatting when importing data into excel spreadsheet

At my company, we use an electronic visitor sign-in/out system via an app titled Envoy. The data from the application can be exported to Excel from the admin interface on the host-site by clicking a ...
11
votes
5answers
109k views

Excel: If statement with #N/A

I have over 6000 records and half of them are formulas that are missing a variable so they result in #N/A on the spreadsheet, what i want to do is if the cell is #N/A then leave the cell blank, ...
0
votes
0answers
19 views

Ctrl + or Ctrl- works only once in Excel 2007

I would like to use ctrl + or ctrl - several times in Excel 2007. It used to work properly but recently, after the first row the cursor returns to a cell instead of to the number of the row and pops ...
0
votes
1answer
17 views

Quickest Way to Extract Data from Doc or Pdf to Spreadsheet [on hold]

I have an influx of reports coming at me, and I need to extract some of the data and put it into a better format(an excel worksheet.) The reports come in docx or pdf and look something like this. ...
0
votes
1answer
72 views

Same Bookmark for Multiple Locations MS-Word

I am feeding Excel data into a Word document with Excel VBA. When doing this, I have many bookmarks in Word. Sometimes I need to pull the same value from Excel and feed it to multiple bookmarks in the ...