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)

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
26 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
30 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
35 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
59 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
63 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? ...
-1
votes
1answer
24 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 ...
-3
votes
0answers
14 views

Excel - Delete rows

I see several examples that are close to what I need but I need help with what would be the inner loop. For a given repeating value (variable number of rows) in column B if none of the rows for that ...
0
votes
0answers
14 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
1answer
37 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
1answer
19 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
2answers
27 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
1answer
31 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
1answer
26 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 ...
-2
votes
0answers
16 views

Excel Formula Query

How can you do a lookup to move data on multiple rows to a single row. E.g If a person has 5 rows of information (a line for each subject qualification) how can you lookup info on that person only and ...
1
vote
1answer
36 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
1answer
19 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
1answer
16 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
2answers
44 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
0answers
22 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
0answers
7 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
2answers
73 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
1answer
27 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
0answers
33 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
1answer
25 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
3answers
93 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
1answer
12 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 ...
0
votes
1answer
43 views

Sort & Ranking Functions in Excel for Time AND Number Values in one Column

I have a spreadsheet that is being used to track and score a fitness competition, each workout has a time cap, so athletes that complete the workout under the time cut off are given a time as their ...
1
vote
1answer
35 views

Excell formula for multiple pasts without repeating previous cells

I have a data set for 12 years of 4,380 days. I want to take the sum of each week. when I make a formula {=SUM(A1:A7)} and drag to drop button to the next cell it shows {=SUM(A2:A8)}. This is not what ...
0
votes
2answers
25 views

Hide a column when auto filter is active

I have read this Show Excel column filter information in cells and it basically does what it is supposed to. But I want to hide and unhide column A when a filter is active. So I put in the following ...
0
votes
0answers
19 views

How do I keep the 'text to column' function from removing decimal points?

After text to column (separated by comma), one column looks like this: -0.03 -149117279052734.00 -0.05 -0.10 170105123519897.00 253522491455078.00 17897253036499.00 14870138168335.00 although they ...
2
votes
1answer
27 views

Pivot table with two headers in MS Excel

I'd soo appreciate if someone could help. My initial table looks like this: Brand Period_1 Period_1 Period_2 Period_2 ------------------------------------------------------ ...
1
vote
1answer
42 views

Given multiple start dates, how to assign counts to relative date values?

I'm trying to create a before-and-after graph in Excel, lining up multiple milestone dates at month zero, and assigning relative month numbers to months prior and subsequent to milestone month. My ...
-1
votes
2answers
41 views

From date of last event, calculate number of days until next regularly scheduled event

I need to calculate the number of days since last occurrence. For example, I have to go to doctors every 90 days. My last doctor visit was on 1/9/14. I need a formula to tell me how many days until ...
0
votes
1answer
43 views

Have Pivot Chart show only some columns in pivot table

I have a data table. In the table I have some dollar amounts. I also have formulas that use lookups to group these dollar amounts into groups in the data itself. I then have a pivot table where my ...
2
votes
0answers
19 views

How can I publish excel workbook with data populated using PowerQuery to SharePoint or website and have the data refresh on the site?

I have an Excel Workbook that gets data from an API using PowerQuery, to populate the tables. There are also filters and slicers in the workbook. Is it possible to publish this workbook to ...
0
votes
0answers
16 views

Format of file lost in Excel 2013

I had Windows XP and Excel 2008. Now my machine was upgraded to Excel 2013. I lost all the formats from previously saved files used to import info into my accounting package. How do I get the old ...
0
votes
1answer
50 views

Make formula impossible to find / read

I have developed a spreadsheet for performing various calculations which our employees will complete and then distribute to clients / competitors. To protect the "intellectual property" of the ...