**2**

votes

**2**answers

60 views

### A blank cell not registering as zero in excel

I am running a complex IF equation in Excel 2003 (yes, the computers at work are that old too) and it is important to the equation that blank cells are valued at zero, which is, I understand, how ...

**-3**

votes

**0**answers

58 views

### I want to compare two different columns and get a value from another workbook using VLOOKUP

I want a value from the workbook(2) by comparing two different columns from workbook(1) using VLOOKUP.
I want a VLOOKUP coding like, if WorkBook(1)columns A matches with workbook(2) columns A then it ...

**-2**

votes

**1**answer

53 views

### Excel, using cell text references as input for formula

First of all thanks for your help. I have a problem regarding the use of text into formulas. I am working on a huge dataset of stocks of several years. The stock are not correctly grouped. I used an ...

**0**

votes

**1**answer

27 views

### Massive number of obsolete defined names in Excel = huge file

At my current job I discovered that many Excel files were unnecessarily large, a file with a single worksheet and simple table can be more than 2 MB and Excel seems to be very sluggish at times. After ...

**-1**

votes

**1**answer

25 views

### How to specify a month in cell A1 and have all the dates that fall in that month appear automatically in row B?

I have a question about Excel. I am using Excel 2010 and I want to be able to create a table that will auto populate the dates within the month that is specified in cell eg A1 into a row in B for ...

**1**

vote

**1**answer

29 views

### Excel 2007 formula to find out date from year and week number?

I'm trying to make my work hour notekeeping a bit easier. I note my hours by project so that Monday - Friday are in their own columns. I report my hours based on this weekly, so each worksheet has one ...

**1**

vote

**1**answer

11 views

### Graph Excel data based on 2 groupings

How would I use excel to graph based on 2 different segmentations? For example, consider the data:
Time Group Col1 Col2
1pm A 15 20
1pm B 20 30
2pm A 10 ...

**0**

votes

**2**answers

50 views

### Sync Google Form Spreadsheet with MS Excel

Is there some way to pull the responses from a Google form that is on a Google Spreadsheets into MS Excel?

**-1**

votes

**1**answer

33 views

### Excel Average by excluding top and bottom 5 values

Trying to get the average by looking up a text and excluding the top and bottom 5 dates based on worst and best values. I am currently using this formula which gets me the all but excluding the top ...

**0**

votes

**0**answers

22 views

### How can I check that a filter applied to a listobject column with vba is legal?

Filtering a listobject(excel table) with a value that doesn't exit results
all rows instead of none
can I get no rows?
can I get list of optional legal parameters?
example
listobject with col A
...

**0**

votes

**0**answers

25 views

### Why Excel autofills only from T1 to T4?

I have the text T1 in a cell. If I select it and drag the fill handle over multiple rows, then it fills in T2, T3, T4, and then resets back to T1, T2 and so on.
With other text like A1, W1, or Q1, it ...

**0**

votes

**1**answer

51 views

### How to reformulate Excel formula with too many levels of nesting

I need to be able to use the following formula in Excel to choose a formula used on a different sheet based on the values in drop-down menus in cells D2 and D3. The only problem is that the formula ...

**-1**

votes

**1**answer

15 views

### How can I extract total time used by an employee from a record mainted in a different tab

How can I add the time used by an employee for different taks and keep track for the total time used in a particular week? Staff will flight out a few times per week with each flight date and time ...

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

78 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

39 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

30 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

57 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

32 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

82 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

95 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

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