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
0answers
10 views

Get a value from the most recent previous record where some text appears in either of two columns

I'm trying to more fully automate the calculation of values and summary data in a spreadsheet I keep about the results of matches in a pool league. I have a table with lots of information about each ...
0
votes
0answers
9 views

How to make a counter on the number of time a file using a certain template has been used?

I would like to make an external counter that counts the number of time I've created a file using a given template. I would like to be able to reset this counter automatically every new month. This ...
0
votes
1answer
23 views

Extract data from more than 100 hyperlinks of web page

I am using this website which has hyperlink for a number of companies. I want to extract the details of the companies. When I click the company, there is a hyperlink "Certificate" which has the name, ...
1
vote
2answers
23 views

Excel - Find ID-related Value and fill in another workbook

I'm working in a small hospital in India having following problem: For a special drug we're having a list with DATE,ID,DOSE,DURATION,NEXT VISIT which we us as a daily working list (workbook 1), means ...
0
votes
1answer
14 views

Excel 2007. I can't enable macro when I open document for second time

The document work perfectly on my computer with office 365, windows 7. But when I copy it to another computer with office 2007 and windows 7, it start normally ( I enable macro and it make everything ...
0
votes
1answer
25 views

how to separate long text data of cell into two columns

I have Name and Address two details in one cell: NKG JAYANTI COFFEE PVT. LTD. 501 QUEENS CORNER, "A" 3 QUEENS ROAD, BANGALORE -560 001.KARNATAKA STATE. ALLANASONS LIMITED, CHANCO RESIDENCY NO.1/2 ...
0
votes
0answers
12 views

Excel- find match between to columns but copy a different cell

I would like to be able to find matches between two columns in Excel. Lets say Column A and Column C. However Column A's values are linked to Column B. When a match is found in A, can it copy the ...
-1
votes
0answers
24 views

Excel VBA to color cell based on text from another cell on another sheet? [on hold]

I am looking for a VBA that can color a cell in say Column A(Data) or B(Other Data) where the values are pulled from Column A in another sheet containing different Text selected from a drop down box. ...
0
votes
1answer
15 views

XPath Data Scraping From Online Community Using Excel

I recently read this article on how to scrape the Inbound.org community members profile using Excel. And you can watch the video here if you prefer it that way. Since the release of this tutorial, ...
-1
votes
4answers
26 views

Excel sort maintaining equal values in different columns in the same position

Imagine I have the following set of data A B AnthonyMorgan EvelynThomas JoePatterson RussellRobinson JohnAnderson ChristopherMiller CarolynMorris RyanStewart DorisKing ...
2
votes
3answers
39 views

Dynamic monthly excel calendar

I want to create a monthly calendar (1 month per sheet) where only the year could change (and so the date). My template of the calendar is already created. All I want is to add a formula that change ...
0
votes
1answer
24 views

Excel Adding multiple values

How do I sum the "1"s separate from the "2"s when they are in the same column? 1 2    1    1    1    1    2    1    1    1    1    1    1    1 1    1    1    1    2    1    2    1    2    2    1    1 ...
0
votes
2answers
24 views

Excel 2010 formula to delete repeated content based on value (instead of second highest the lowest)

I've read a Question topic about picking the second highest value. I need the same but a bit different: Excel 2010 formula to delete repeated content based on value Maybe it is a bit rude, but I ...
0
votes
0answers
19 views

How to update a third column from a column when two other columns match? [on hold]

Maybe the heading confuses. But this is what I want to achieve: Let's say I have a column, Col1. I have got Col2 that has got some of the items from Col1 and a corresponding Col3. I want to lookup ...
2
votes
4answers
45 views

How to identify duplicates within text in two columns in Excel

I have a worksheet where column A has various names in varying formats: A1   John Smith A2   Jones, Mary A3   Sally Gomez A4   The Gonzalez family Column B has similar data: B1 ...
0
votes
1answer
10 views

Find multiple cells with the same value in col A then search col C for a particular number

Say I have multiple cells in column A with the same value (e.g the number 22). I want to identify those rows then search for the existence of a particular number in column B (e.g. the number 10); ...
1
vote
1answer
23 views

Add an area to a scatter plot in Excel

I'm desperately trying to layer an area chart on top of a a scatter plot in Excel 2013. The scatter plot has been successfully used to visualize the deviation from the mean of different Key ...
-1
votes
0answers
7 views

How do I link other workbooks to a master file?

I want to know how to link different workbooks, which have similar names. For example, I have one master file, which needs to get populated from various other workbooks (from different worksheets). ...
0
votes
1answer
20 views

How can I return a count of a specific criteria in a range of duplicated items?

I have two sheets (tabs) in an excel document, Sheet 1 and 2. As can be seen below Sheet 1 has 3 columns [1 row], and Sheet 2 has 2 columns [5 rows]. I am looking for a formula that will return the ...
2
votes
3answers
50 views

How to round off an hour value?

I need to round some hour value in excel at the first quarter after): 9:01 ==> 9:15 9:10 ==> 9:15 9:15 ==> 9:15 9:16 ==> 9:30 and so on
0
votes
2answers
13 views

Month by Month Pivot Table

I have a list of dates and data that go back a year. In Excel, I made a pivot table that shows all these dates. In the columns label under data filters I see a lot of weekly, monthly, yearly ...
0
votes
0answers
22 views

Parse .docx, Put data into excel? [on hold]

I already have an idea on how to do this (using python-docx and openpyxl), but I wanted to see if there are any other more efficient / faster / easier ways to do this. I am using LiClipse as my ...
0
votes
2answers
26 views

Excel - Dynamic Cell Update using multiple criterias

I would like to know if there is a way in Excel to create a cell that will display a value using a formula that will calculate the latest entry by date and campaign. If I have 3 columns DATE | ...
0
votes
1answer
21 views

How to create a reference table in MS Excel?

I would like to create a reference table in Excel like this: So everywhere in my workbook or worksheet I type X111, Excel shows the value of 2400. How could I do that?
0
votes
1answer
26 views

How to search in column A for specific data and place an answer in column B (“Yes” or “No”) [on hold]

Using Excel for Mac 2008. Column A has a long list of comma-separated data in no good order. I want to find one specific set of words (set off by commas, such as "Level 2 Supporter") in each row and ...
1
vote
2answers
23 views

Find information about range of Excel data. Is it constantly growing or cyclical?

I am (short-term) monitoring the sizes of several UNIX files and can easily export the numbers to an Excel spreadsheet. The files will eventually be indexed by Splunk and that team wants to know the ...
0
votes
2answers
57 views

How to convert text to date in MM-YYYY format

I have a column in Excel with the following entries in text format: 7.2013 7.2014 8.2013 8.2014 9.2013 9.2014 10.2013 10.2014 11.2013 11.2014 12.2013 12.2014 1.2015 How can I convert this ...
0
votes
1answer
31 views

Chart created from range of dates includes dates not in source data

I have a chart and its source data is read from a range which contains dates. When I plot it out into a chart, the x-axis includes dates that are not included in the range. How do I avoid this? For ...
1
vote
1answer
16 views

how do i just copy excel to txt with space and '\n' as delimiter

When I copy excel to txt, the I can't get the delimiter for different columns as space, ' ' and the delimiter for different rows as '\n'. Is there someway for me achieve that? Because I am building a ...
0
votes
0answers
34 views

Excel colon in function

I am learning excel functions and modeling from Google and trial and errors so just want to clarify the following point to get my fundamental understanding correct: When it comes to colon in excel, I ...
0
votes
1answer
26 views

Excel changes my settings for column width and row height

I select the entire Column right click and select "Column width" enter 2.54mm hit enter When I check the column width, it is 2.38mm. Similar issue with row height. I try to set it to 2.49mm; ...
-1
votes
0answers
18 views

How to control date range for the powerpivot chart? [on hold]

Is there any way to control date range for the powerpivot chart by entering those dates on the excel sheet? When you draw the chart with the data source from PowerPivot. It will have X axis and Y ...
0
votes
0answers
19 views

How to get selected slicer or timeline value in the powerpivot? [on hold]

Is there any way to get the selected value from slicer or timeline in powerpivot data model?
1
vote
1answer
42 views

Looking for an excel formula to match credit card purchases to batch payments reflected on bank statement for account reconciliation [on hold]

How can I match credit card batch payments from bank statement to credit card purchases in a spreadsheet? CC Purchases Batch Payments 1 0.05 A 1,913.91 2 ...
0
votes
2answers
44 views

How to renumber a sorted column to start from zero in Excel

I have 2 columns of numbers in excel. After sorting them, I want to convert the numbers to sorted numbers from zero, which the minimum number converts to 0, second number converts to 1 and ... . For ...
0
votes
0answers
9 views

Group dates as MM-YYYY on Pivot Table

I'm using Excel 2011 for Mac. I have a sheet with dates that I have grouped into a Pivot table. The data spans across months of 2013 and 2014. I want to chart the trends over a month of a year, but ...
-1
votes
0answers
28 views

Excel OR function with several criteria, how to make better?

I'm making an Excel document (for Mac 2011, ver. 14.0.0) with a drinks list, and right now I'm making a sheet where you can enter what ingredients you feel like using (up to four) and the sheet will ...
0
votes
1answer
29 views

How to highlight a cell when I double click on another cell?

Friends I am using MS Excel 2010 and I want when I double click on a cell say a1 it should highlight c1 cell. Similarly when I double click on a2 cell it should highlight c2 cell. It is possible by ...
1
vote
0answers
20 views

Excel Charting - How to edit the X axes for positive value on both sides?

I have a stacked chart, with the X axes at bottom. So there are two bars protruding along the y axes from each category. to get an idea of the X axes, it's something like this How to plot positive ...
1
vote
0answers
20 views

How do I enable macros on an external harddrive

I have an external harddrive that I have mapped locally to the e:\ drive. There is a subfolder that contains excel sheets with macros that I am unable to run. In File->Options->Trust ...
0
votes
2answers
26 views

1 A, 2 A, 3 A automatically becoming 1:00 AM, 2:00 AM, 3:00 AM in Excel 2010 [duplicate]

I use MS Office 2010. While using Excel, whenever I type 1 A, 2 A, 3 A up to 12 A and move to next cell by hitting Tab or Enter key it automatically becomes 1:00 AM, 2:00 AM.....12:00 AM. This problem ...
-3
votes
2answers
31 views

How can I scrape only word data from a website? [duplicate]

I want to download all the word content from a particular website. Save the results in MS Word, Excel or Notepad and check which words are repeated most often and how many times.
1
vote
2answers
27 views

How to use validation to make sure cell value starts with specific word

I need to check if the value of a cell starts with the term superuser. The entered value then should, for example, look like this: superuser template If the user enters super user template (with a ...
-1
votes
0answers
21 views

Excel 2000 - barcode scanning error [closed]

Using a well developed barcode scanning control panel that was made by another employee at work. Problem is, we get an error in situations where there are multiple barcodes on a box and the wrong ...
0
votes
1answer
33 views

Is there a limit on the number of rows a sum function can calculate in Excel 2007?

I am trying to sum a column of 50938 values in Excel 2007 but keep receiving a "#VALUE!" error. The cells in the column do contain formulas. I also tried to sum the column after copying and pasting ...
0
votes
2answers
31 views

Combine first letter and last word in excel

I have a spreadsheet of usernames. First and last name are in the same cell. Is there a formula to take the first letter of the first word and the whole second word? For example; Cell A1 has Jon ...
-2
votes
0answers
13 views

Shortcut for expanding the Year,Month.Day in pivot [closed]

I'd like to know if there is any shortcut for expanding Year, Month and Day in a Pivot table
0
votes
1answer
32 views

Finding Clustered/Consecutive Values in Excel

I am trying to find values in an Excel spread sheet where numbers greater than 0 will be highlighted. However, those highlighted must be clustered, consecutive numbers which should be (at least) three ...
0
votes
1answer
24 views

Excel formula - is it possible to return a value adjacent to a list of values, depending if that list of values matches another list?

In Sheet 1, I have a list of document numbers (alphanumeric) in Column A, which have a corresponding title listed in Column B. I need to compare another list of document numbers (alphanumeric), ...
0
votes
1answer
21 views

Sorting cells in rows to match respective column headers

I'm trying to sort the cell value in multiple rows to match the value of a column headers. What it looks like: A B C D E --------- D A C C E B D E E What I want it to look like: A B C D E ...