**0**

votes

**0**answers

180 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

91 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

263 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

53 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

461 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

98 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

181 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

42 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

20 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

35 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

69 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

2k 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

60 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

34 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

36 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

1k 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

52 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

19 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

50 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

155 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

63 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

47 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

69 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

100 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

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

**4**

votes

**6**answers

14k 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

61 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

1k 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

41 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

28 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

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

**-1**

votes

**1**answer

26 views

### I would like one cell to add within the same cell

I am trying to have one cell calculate over and over again multiple times.
Here is an example:
If I type 45 in cell d6. I want to be able to type 67 into the same cell d6 and it add both the previous ...

**0**

votes

**0**answers

20 views

### Copy a prepared Excel worksheet and retain the column widths and heights

All of the HELP info on this subject does not work in Excel 2013. I want to copy a worksheet to create a new copy, AND retain the column widths. The MOVE OR COPY command does not do this, nor does ...

**2**

votes

**1**answer

133 views

### How to apply conditional formatting only to cells that contain a subtotal formula

I have a list of values, I have to alternate color of each row (that works fine).
In that list I also have subtotals, calculated using the SUBTOTAL function.
How would I be able to give just the ...

**0**

votes

**1**answer

63 views

### Excel INDIRECT function worksheet names

So I have a series of worksheet in my workbook names A1-A4,B1-B4 etc. I'm trying to make an index page that pulls some of the data from each worksheet into a table but can't seem to get the INDIRECT ...

**0**

votes

**2**answers

46 views

### Adding of time in Excel gives a strange answer

I tried to add the following times:
4:28:31
and
17:51:13
and got:
46:19:44
using simply =firstCell+secondcell
all are in [h]:mm:ss format.
What could be the reason why the answer is wrong?
...

**1**

vote

**1**answer

47 views

### Create a non standard weekly date range autofill in excel

I am working on a monthly spreadsheet of our daily takings.
I need one line for a sunday, monday and tuesday but two lines for wednesday, thursday, friday and saturday. I can't seem to hit the magic ...

**1**

vote

**1**answer

115 views

### How to compare two sheets and get the common rows

I have a excel file which has two sheets and below is the first sheet and second sheet. I want to compare the two sheets (ex: each row of first sheet with with all the rows of second sheet ) and then ...

**1**

vote

**1**answer

670 views

### Embed Excel Chart with Drop-down control into powerpoint

I have an interactive Excel chart which runs on the basis of users selecting ranges using drop down menus via the form control and I want to move this into Powerpoint 2010 for presentation purposes. ...

**1**

vote

**1**answer

196 views

### Is there a way to do a partial text vlookup?

I am trying to vlookup partial text which will return a specific value if found within my data. I have a list of postcodes (zipcodes) and would like a vlookup to look up the first part of the postcode ...

**0**

votes

**1**answer

20 views

### Getting references from regular intervals at regular intervals

I have data as follows (simplified) in two worksheets on a document:
Sheet 1 data: A1=1 -- B1=(Blank) -- C1=(Blank) -- D1=2 -- E1=(Blank) -- F1=(Blank) -- G1=3
Sheet 2 data: is blank currently
...

**-1**

votes

**2**answers

50 views

### how to cancel the focus change of cells in excel 2007?

When I move the cursor in Excel 2007 from cell A1 to cell A2, so that cell A2 is highlighted instead of A1, sometimes I press the tab key too quickly, so I try to go back and highlight A1 again.
I ...

**0**

votes

**0**answers

109 views

### Excel VBA macro - i need to insert column and add a default value to all the cells in that column

I have created a macro but i could not insert columns in it and i could not add values to that coulmn.
I want to insert a column and the default value to that entire column should be CH. column ...

**0**

votes

**0**answers

8 views

### Excel 2010 opening data grouping when entering a formula

When I try to enter a formula in Excel 2010 all the columns that I have grouped/outlined open up. I do not want this to happen. When I open the same file on another computer it does not do this. Is ...

**0**

votes

**2**answers

1k views

### Exporting Attachment File Name + Email Metadata from Outlook to Excel

I am looking to do analysis on all of the file types that I have received in a folder in Outlook. I have tried using the Export functionality in Outlook, as well as importing Outlook directly into ...

**0**

votes

**1**answer

38 views

### AND logic IF statement in excel

=IF((=VLOOKUP(D1700,Cullpitsoriginal!B715:B5480,1,FALSE))+(ISNA(J1700)),"CHECK ME OUT","no")
By looking at the above formula, I want to return the string "CHECK ME OUT" if the VLOOKUP() returns a ...

**0**

votes

**0**answers

65 views

### How to combine an Excel spreadsheet with word documents using a field from the excel rows matching filename of word doc

I am trying to combine an excel spreadsheet with associated word documents. There is 1 word document per excel line.
I have the Excel spreadsheet with all the rows.
I have all the word docs in a ...

**1**

vote

**1**answer

30 views

### Appending Year to Excel Date

I have a pivot table arranged by day and year. Unfortunately, days come up as entries under 'year' headers. Is there a way to make it so that the year is included in the actual entries rather than ...

**1**

vote

**3**answers

356 views

### Microsoft Office 2010 Excel will not open two xls

I am using Windows 7 and Windows 8 and I see the following behavior with Microsoft Office 2010.
Create two Excel files, say a.xls and b.xls
Open a.xls by double clicking it.
After the file is ...

**0**

votes

**1**answer

26 views

### how to get the count of column data based on some condition

I have the excel with two columns like below
ID Address
GID1 address1
GID2 address2
GID1 address1
GID8 address1
GID2 address8
so i want to get , for all same ID's , count ...