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
votes
1answer
15 views

How can I merge contents of 2 cells into 1 and shift the remaining columns in Excel?

I'm trying to merge cells in excel that are in the same row into 1 cell and then shift the remaining cells to the left. Example: Content | Sample | More | More2 So I want to merge "Content" ...
0
votes
1answer
46 views

Converting a mmm-yy date in string format to date format

I have an excel document that lists dates in mmm-yy format as a string (they've been copied in from a pdf). I need to be able to determine the number of days between these dates, however excel ...
0
votes
2answers
66 views

Enhanced Vlookup Excel Formula

I am looking for an excel formula that I can use to automatically fill E2 in the screenshot below. The intention is to find Marc's age from column B, ie E2 should be 20. Any ideas please? I have tried ...
0
votes
2answers
76 views

Why is pasting text into Excel splitting it into multiple cells?

When I am copying partial text from one cell and pasting into another what I am pasting is separating into multiple cells. Example: Copying "June 15th" from a cell containing "Little Timmy's ...
1
vote
1answer
26 views

Find all Excel files linked

I have an Excel file that is the source of data for several other Excel files (they are linked to this one). Is there a way to find a list of all of those files? To explain another way, this post ...
1
vote
2answers
22 views

Selecting a button control in Excel 2013 without clicking it

I want to change the name of a button control in Excel 2013. I have my properties window open ready to go. However, I can't for the life of me figure out how to select the button without clicking it ...
0
votes
1answer
38 views

Copy reference instead of value/formula in Excel?

I have some cells from one table I which I want to reproduce in another table, initially in the same order (but later, I'll mess this order up by moving cells around). For the sake of discussion ...
0
votes
1answer
19 views

named ranges in Excel

I have a list of items in excel and I would like to name the range "Account Payments". It works for ranges with one word names but not with 2 or more words. how do I do this? thanks for your help
0
votes
1answer
29 views

Align header with cells whose text is oriented at an angle

Is there a smart way to align horizontal-text "header" cells with other cells below whose text is oriented at an angle? This is what I tried. Obviously this looks awful. The "Benefits" and "Caution" ...
1
vote
1answer
31 views

How to efficiently reference an entire row in Excel?

I am working on a budget spreadsheet in which I have to pull in cell data from another external spreadsheet. I have to do this for several different sheets with massive amounts of data in the sheets, ...
1
vote
1answer
21 views

highlighting monthly due dates in excel for the entire year

In excel, is there a formula that can help highlight a reoccuring monthly due date and once that bill is paid for that month it changes back the color? EXAMPLE Vendor Due Jan ...
0
votes
2answers
34 views

Create an “inverse” pivot table

I have data in the following format Project Person1 Person2 Person3 A Joe Alice Bob B Bob Tom Joe C Alex Alice Tom D Bob Doug Susan How can I ...
1
vote
0answers
24 views

Embed an Excel spreadsheet into the body of an email

I want to embed an Excel spreadsheet or some other kind of calendar into the body of an email. I am making the calendar and using hyperlinks. Is it possible to put this in the email with the ...
-2
votes
0answers
26 views

VBA Help Please, or Direct me to a good resource

I am new at this VBA Thing and learning as I go, could someone look at the code below and explain why the out put is only one line and it is pasting to Row 39? Sub AllFiles() Dim FolderPath As String ...
0
votes
0answers
30 views

Area Under Curves in Excel

Are there add-ins for Excel that allow the user to get the percentage of values that lie less than or equal to some value x? Basically I'm looking for an add-in that takes the continuous valued chart ...
-1
votes
2answers
26 views

Excel create reference to whole column throught a formula

I have a spreadsheet where I need a reference to a whole column, catch is that I don't know which column ahead of the time, so I use MATCH function to find that out. Once I find the right column I ...
0
votes
1answer
56 views

Excel 365 slow keyboard shortcuts

I'm an experienced Microsoft Excel user and I've always loved the software in the past, when I used Excel 2007. One of the best things I liked about Excel 2007 was how I could do everything on the ...
0
votes
0answers
31 views

Consolidating data from multiple sheets into a single sheet based on specific criteria

I have over 300 excel sheets all having stock data over a year. This data is date wise. However I want to group this data based on stock name, i.e., if I have stock A in all my sheets, then all data ...
2
votes
1answer
32 views

Excel Continuous Pagination

I have the Excel worksheet as shown below on the picture. The data are on the yellow-marked pages. I only need to print the yellow marked pages with continuous pagination. So the result should be: 3 ...
0
votes
0answers
80 views

vba excel macro runtime error 1004

Dim lastC As Long lastC = wb2.Worksheets(2).Cells(1, Columns.Count).End(xlToLeft).Column 'highlighted in debug SourceRange.Copy wb2.Worksheets(2).Cells(1, lastC + 1).PasteSpecial Paste:=xlPasteValues, ...
0
votes
1answer
23 views

Comparing 2 Cells and then based on their values Multiply another cell

I have a spreadsheet for my insurance business. I want to have a spreadsheet to determine my commission on a monthly basis. So I have one column for Line of Business (Auto, Home, etc) and then another ...
0
votes
1answer
66 views

modify Excel macro to reference list of text rather than hard code

I’m trying to get some help with the last step of an Excel Macro I’ve been working on. I’ve set up a Macro that will take data from sheets from two different workbooks, and paste them into a third ...
-1
votes
3answers
44 views

How to automaticaly convert text to url

I have a list with names and I want to make an other colum with http://name.jpg is this possible in excel? and if my original name was 2 words or more can I have auto underscores in the url instead ...
1
vote
4answers
91 views

How to construct a conditional COUNTIF formula

I have a worksheet where in D I have time (0600,1800,2400) and in R I have disposition e.g (accomplished, pending etc). What I want is a formula to count the disposition in column R as per the time ...
1
vote
1answer
53 views

How to combine data from two sheets and conditionally format rows based on sheet of origin

I have 3 sheets in Excel "Open", "New", "Combine" "Open" Sheet (Old list) Ticket ID | Priority | Department | Status 36009 | 1 | Finance | 01-Open 34781 ...
-1
votes
2answers
46 views

Excel possible to fill two cells with one if-formula

I have searched on the internet to look if this is possible : IF(logical test ; true value ; false value ) This is what i try to make for example A2 =IF( B2 = 20 ; "True" & give C2 value ...
0
votes
1answer
25 views

Unable to expand cells in Microsoft Excel

I have an odd issue that I need your help with. Within my spreadsheet there are many cells that although contain data, do not respond when I try to automatically resize them. I've tried auto-fit, ...
0
votes
1answer
12 views

In Excel increasing the digit value

I'm trying to get Excel to increase a number by 1 digit when an alpha character is part of the "number". Example: HH-floor2-roomOPE-VSP1 increase to HH-floor2-roomOPE-VSP50. Is there a way for this ...
0
votes
1answer
30 views

how to send a pdf or ms excel/word file while it's open?

Upon viewing a pdf, ms excel/word file, i often want to send to my colleague for viewing, and after sending, i will still need to keep it open to use it further. While each time I have to close it and ...
0
votes
1answer
41 views

Can't get VLOOKUP working with roster spreadsheet

I have an Excel spreadsheet set up as a roster. The way the roster is setup is for the ease of the person creating the rotation. This roster is not easy to read for the staff. Mon ...
0
votes
1answer
34 views

How to bring to front a series in a scattered chart

This question is almost stupid but, since I'm working late at night in this part of the world, I'm too confused that I can't find the easiest command. I have a scattered graphs with many series. Some ...
1
vote
1answer
32 views

Excel lookup() always returns last value

I am using Excel on a larger table (3148 col) and I am doing a lookup. I've tried it with just 10 columns and it worked as expected but when I do my lookup with all the entries it just fails by ...
0
votes
2answers
31 views

How to use different formula in case of en error?

I want to run the following formulas on a cell, in this order, in case the previous formula returns an error. =MID(P2,SEARCH("q=",P2)+2,SEARCH("&",P2)-SEARCH("q=",P2)-2) ...
0
votes
1answer
21 views

Excel: How to strip search terms from a cell (referring URL)

I have cells that contain a referring URL of visitors who entered my websites. this URL always has a different lenght, but it's constant format is such that the search term always shows up between p= ...
1
vote
1answer
28 views

Managing different currencies in Excel budget sheet

I need to enter the values as I write cheques (ie $100 USD and $100CDN, not $111.55 USD and $100CDN) otherwise it will be a nightmare for me to match entries to invoices. I could create a column for ...
0
votes
1answer
20 views

Can we set Excel to append cell text on key press instead to delete the current text?

I am using Excel a lot for accounting. It happens a lot of time that I calculate multiple values into the same cell. So my cell may look like =12+345+23+88. Now, the default Excel behavior is to ...
0
votes
1answer
16 views

Cell colours depending on value

I have a column of cells where each cell contains one of the following text values Optimal Normal High-Normal Mild Moderate Severe I would like the cell colour to be a set depending on what the ...
-1
votes
1answer
23 views

How to apply formula in specific condition in excel

I am trying to use flags to use in formulas 1 ,0 . I want excel to put 1 every specific number of months (3,6,...) . so if 1 applies in Sep ,then I want another 1 to be after (3,6,...) months. the ...
0
votes
0answers
35 views

How do I use the Phonetic() function in Excel 2013?

I am trying to use the Phonetic() function with some Japanese vocabulary words, however, it doesn't seem to be working. I assume it needs the furigana (ruby text) above the Japanese words, but Excel ...
0
votes
1answer
16 views

Page Break lines won't stay off for a shared Excel document

I have a shared Excel document on my NAS, and in Excel I go to options and disable Page Break lines. However, when someone else opens the document, the page breaks reappear. When I reopen the ...
1
vote
2answers
30 views

Code iterating slowly

I have a simple macro that gets creates 16 different versions of a template, updating by getting values from another open workbook. It is taking over a minute to iterate only 16 times and was ...
0
votes
1answer
18 views

Excel Values Require Enter within Cell to recognize as number

I have a worksheet where I am getting direct output from STATA that has a weird character format that included " =[ number ]". I put in a new column to strip the characters and leave the numbers. ...
0
votes
2answers
37 views

Importing multiple CSV files

I have to run a daily stock analysis where I pull multiple .csv files, and then have to go through an annoying task of deleting unnecessary fields from the .csv's. Only then can I start compiling the ...
2
votes
2answers
33 views

How to find the last value in a column in excel?

I am tracking rooms booked in a hotel on a daily basis in Excel. Every day I input the number of rooms booked in a column to show a trend of pick up over a period. I'd like to return the value of ...
0
votes
3answers
62 views

Unable to get Excel to recognise date in column

I constantly have problems working with dates in Excel, I must be doing something wrong but I don't understand what. I have a spreadsheet, exported from our exchange server, that contains a column ...
0
votes
1answer
24 views

Count Row and Column in Pivot Table

Hi I have a sheet that collects the following ++++++++++++++++++++++++++++++++++++++++++++++++++++ + Name + Address + Borough + Postcode + Date Added + ...
0
votes
1answer
69 views

VBA: How to replace entire Excel cell value basing on its content?

I have an Excel Spreadsheet with some names in a cells. There can be as one name per cell as multiple names in one cell. For example: Cell A5 contains "Joe", cell BD54 contains "Joe;Harry;Molly", ...
0
votes
1answer
24 views

Excel: identify the column with a specific value

I have an excel file with a table of the following format, there are about 50 columns A B C D E id 1 0 0 0 0 1 0 1 0 0 0 2 0 0 0 0 1 3 It is guaranteed that one row will have exactly 1 value ...
0
votes
2answers
18 views

extract date from string in excel

How can I extract date from such strings in excel? female in 1 2014-07-15T16:26:34.2343442+01:00 PointEvent I have this data and in the end I want to have: female in 1; and in another cell : ...
0
votes
0answers
14 views

Google Sheets: Count the number of consecutive blank cells in a row and alert if it matches a set number

In the attached sheet, I would like to return a red coloured cell as an alert in column B if there are 3 or more consecutive blank cells across the row.Is this possible? ...