**-1**

votes

**1**answer

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

**1**answer

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

**2**answers

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

**2**answers

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

**1**answer

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

**2**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**2**answers

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

**0**answers

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

**0**answers

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

**0**answers

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

**2**answers

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

**1**answer

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

**0**answers

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

**1**answer

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

**0**answers

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

**1**answer

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

**1**answer

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

**3**answers

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

**4**answers

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

**1**answer

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

**2**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**2**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**2**answers

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

**1**answer

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

**2**answers

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

**2**answers

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

**3**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**2**answers

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

**0**answers

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