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 "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
1answer
20 views

Excel help, formula for one cell looking at information in another

Excel, How do I get one cell to come up with "N/A" when "No" is selected from another cells drop down?
0
votes
0answers
15 views

Sorting and separating by category in creating a macros

I have spreadsheet with products by code, description, unit and category. i want to create a macro that will sort by category description then have 2 rows between separate categories place the the ...
1
vote
1answer
21 views

IF THEN statement to search and return information from column of options

I need a formula that says IF cell A1 = any of the content in any of the cells in column C, THEN cell B2 will be whatever content is in cell D of that same row as the matching C content. in my ...
1
vote
2answers
47 views

Speed difference between ISNUMBER() and COUNT() when searching for substrings within text

I'm trying to see which Excel formula is preferable - IF(ISNUMBER(SEARCH(A1,"myText"))=TRUE, doSomething) or IF(COUNT(SEARCH(A1,"myText"))=1, doSomething). Is there any sizable speed difference ...
1
vote
1answer
20 views

Paste as image adding extra padding inside image

So whenever I am doing a 'paste as image' from excel table to word or outlook, the table image is given extra padding both beneath and to the right. I used to be able to copy images flush with one ...
0
votes
0answers
23 views

Excel sheet freezes after adding custom add in [on hold]

I created a custom excel plugin that once it has been added to excel works as intended. The problem is the first time it is added to Excel the sheets of the current book lock up. I am still able to ...
0
votes
2answers
21 views

Adding components of formula (net vs. gross)

I would like to add the components of a formula across a range. We have one section that shows the net cash flows for specific items, and multiple specific items. For example =8+9-5 shows "12" ...
0
votes
1answer
19 views

Why is the MATCH function is not resolving my lookup array?

In Excel 2010, I am using two Excel tables. One table (ActiveDS) has a single column and contains a list of our active data sources. The other table (ApproverRole) has a number of columns, including a ...
1
vote
0answers
16 views

Excel - How to link Index/Matching formula with Indirect formula for dynamic column reference

I have a worksheet in which I am looking to utilize the Index/Matching formula to pull in exact values for the unique intersection of Department & Account values on a separate data sheet. However ...
0
votes
0answers
19 views

How do I use Data Validation to accept a value based on value in another cell on the same row?

As we can see from the image, I want to accept value in Column B based on the value in Column A. For example, if the value in cell A2 is "India" then cell B2 should accept only "Delhi". This is the ...
3
votes
2answers
46 views

COUNT all “P” from a row

I have a presence row in a sheet (Google or MS Excel, does not really matter), having values "A" or "P" for each name. I need to count how many "P" I have, to make the cell RED if there is any "P" in ...
1
vote
1answer
47 views

Extracting Text (Capital Letter)

I download bank transaction history and would like to extract the name of customers which is located at the end of the Description line. Some lines have one or two words preceding the names of the ...
3
votes
2answers
30 views

How can I how extract/parse variable info from the END of a string in Excel?

Example1: 01/28/14 Interest Earned 0.10 Example2: 12/27/13 CHECKCARD 1226 LIONHEART BOOKSTORE SEATTLE WA -25.13 In the two examples provided, my goal is to separate out the information ...
0
votes
1answer
12 views

How to Locate the source List in data validation?

In an excel file, there is a column with a data validation field. And it has too many dropdowns. When I looked at the data validation, it has a list criteria and a source =offices. My problem is I ...
0
votes
1answer
15 views

How to export each Excel sheet to each page on PDF?

I want to export specified Excel sheet to specified page on PDF. For example, Sheet1 from Excel to Page1 on PDF. Sheet2 from Excel to Page2 on PDF...so on. I know how to export whole Excel book to PDF ...
0
votes
0answers
19 views

How to calculate time differences with condition

I have a table with 2 columns consists of: TIME of order and CUSTOMER name. I need to find the time difference between orders for a specific customer. TIME CUSTOMER 12/30/2015 23:59:53 STY ...
0
votes
1answer
12 views

Keeping a specific filter applied when clicking 'Clear' in Sort & Filter in Excel 2013

In Excel 2013, under the Data ribbon, Sort & Filter section, the button "Clear" clears all filters. Is it possible to do something like "clear all filters but this one"? I frequently want to ...
0
votes
0answers
21 views

index or not with excel my code not working [closed]

i want to try to show result if site indexed in google .. as my coding if site indexed in google it will print url in result .. but my coding not work can any please help me in this ... here is my ...
1
vote
0answers
17 views

How to reorder chart legend in Excel 2016 (Mac OS X)?

In Excel 2016 for Mac OS X, how do I reorder the objects in the legend for a chart? For the example below, I want to change the order of the countries in the legend, e.g. alphabetically or by the ...
1
vote
2answers
68 views

Enter time without colons (hhmmss) and calculate time differences in Excel

I want to enter the time without colons as hhmmss and calculate the time differences with another cell. For example I enter the beginning time in one cell and the ending time in another. Then I need ...
0
votes
1answer
60 views

How do I calculate the difference between two dates?

I have a sheet that contains: column A: names column B: date of admission column C: date of leave column D: date of death column Z: date of birth I want to calculate the ...
-1
votes
0answers
42 views

Microsoft Excel - lots of scenarios

I have an excel spreadsheet that I am using to calculate the dissociation of combustion products in the combustion chamber of an ICE to form free oxygen molecules to allow formation of nitric oxides. ...
-1
votes
0answers
22 views

Abbreviations management [on hold]

I need to deal with a great number of abbreviations, so I would like to create a spreadsheet where all of them are automatically ordered as I enter each in a new cell. Also, the whole row ...
1
vote
1answer
32 views

Find the last data in a table with conditions

I want to get the latest END BALANCE of customer, when the STATUS is success. Picture of the table and result wanted is attached above.
0
votes
0answers
13 views

Excel Chart Title - how do I change font size when using cell reference?

I have a chart in Excel with the Title linked to a cell =REPORT_PAGE!$A$1 The formula in A1 looks like this: =ProductName & ": Project Performance" & CHAR(10) & "SPI: " & ...
0
votes
1answer
28 views

How to synchronize text in Excel in multiple sheets

I have Excel file with four sheets. How to make duplication using Excel built-in function using specific parameters? Example: Sheet 1 - Total: A B C 1 Iveco ...
0
votes
1answer
19 views

Excel TODAY() function

I have two tables in excel The first table is called Oranges, it shows where the oranges were produced and where they were exported to: The second table is supposed to show the total oranges ...
0
votes
2answers
29 views

Is it possible to have an =if equation involving text and math?

This is what I'm shooting for: =IF(LEFT(Q3,2)="By","see authorizing lab"&"-"&SUM(Q3-L3)) I'm trying to say IF Q3 says "By" the return "see authorizing lab" if not then subtract L3 from Q3 ...
0
votes
1answer
18 views

Find nearest value in column

Using Excel, in column A I have a list of numbers 2156 2029 1990 1975 1874 and in cell B1 I have the value 2001. How do I find the nearest value that matches it in column A? ie 1990 which is A3
0
votes
1answer
24 views

find urls indexed or not in google with excel [closed]

is their any sheet or code available online for my question .. my question given bellow .. I'm trying to make a sheet with a column of URLs and another column showing whether the URL is indexed in ...
3
votes
1answer
319 views

Omit weekends and/or holidays in days to complete formula

Is there a way to not include weekends and or holidays in an Excel formula involving dates? Example: =Q2-Q1 (a date in q2 minus a date in q1 = so many days) Excluding weekends & holidays?
2
votes
2answers
47 views

Creating an Invoice in Excel

I have only dabbled with Excel and not much in quite some time now. I have an Excel Invoice laid out so Column A is a name of a job and each row in column A can be a different job. Now column B ...
-2
votes
1answer
30 views

# of days in a month based and start and end dates

This question relates to Calculate Total Number Of Days Per Specific Month. If you look at the original question what IF you have a start and end date Jan - March and you need to know how many days ...
0
votes
1answer
20 views

Excel 2013: Substitute cell between certain number range

I have a HDI(Human Development Index) database from my country where it includes every city. In case you don't know, UNPD uses certain thresholds to rank countries between 0 and 1, ranking them like: ...
1
vote
0answers
17 views

Is it possible to maintain internal links when converting Excel workbook to PDF? [duplicate]

I'm trying to add a table of contents page to a report I make with Excel 2010, so that if I click on an item in the table, I will jump to the corresponding page / tab in the workbook. I'm able to do ...
1
vote
1answer
13 views

In Excel 2010, is it possible to desc order series on chart without changing the order of source data table?

I have a source table that looks like this: What i'd like to do is, for each period, create a separate column chart that displays Items by their values in desc order. There will be 5 charts in all. ...
0
votes
2answers
39 views

Adding or Replacing text within hyperlinks

I am very confused after trying to explore how this can be done. Its very simple but yet cant find a solution. What I wish to know is the following. I have three separate documents, all of which are ...
-1
votes
0answers
38 views

Check whether URLs are indexed or not in Google [closed]

I'm trying to make a sheet with a column of URLs and another column showing whether the URL is indexed in Google or not. How can I check these URLs in bulk using Excel? If this is possible in Excel, ...
0
votes
0answers
28 views

Excel formulas linking sheets in workbook

I am looking to automatically update a results sheet by moving down by one row every time I input a set of data in another linked sheet (raw data) in the same workbook. I will be overwriting the Raw ...
0
votes
2answers
30 views

Why does my IFNA (or ISNA) not working in a VBA module?

i have the following code: Sub TestNA2() IsThisNA = Sheets("sheet1").Range("D:D").Select 'Sheets("sheet1").Range("E:E").Select Range("E2").Formula = "=IF(ISNA(D1),""Delete"","""")" ...
1
vote
1answer
26 views

Restrict Duplicate entry in a column in Microsoft Excel

I have an Excel spreadsheet that contains two sheets.Suppose the names are sheet1 and sheet2. There are several data in column A in sheet1 and several data in column A in sheet2. How can I restrict ...
2
votes
2answers
58 views

How to remove linebreaks in Notepad++? in long text

I would like to know if is a method to remove linebreaks in Notepad++ aside from select and cntrl + J that is already explain here How to remove linebreaks in Notepad++? the Problem is ...
-4
votes
0answers
29 views

ANWSER for Enable smooth scrolling in Excel for large cells [closed]

I have anwser for question from "zmische" about smooth scrolling in Excel, sorry for adding extra Question, i couldn't anwser the other one because of reputation politics. I have used Win7. To solve ...
2
votes
3answers
30 views

alt + = not working in Excel 2010 on my HP laptop

I was using MS Office 2010 on My Lenovo laptop and now I have purchased a new HP laptop, also with MS Office 2010. I have a problem with Alt+= keys not working for Auto-sum in Excel. All other key ...
1
vote
1answer
20 views

Populate Spreadsheet with files within a folder

I need to manage a lot of files within folder related to a project, at the moment these files reside in Dropbox. So, I will like to find a way in which I can have a Spreadsheet populate itself with ...
0
votes
1answer
26 views

Drawing a chart on Excel [closed]

Is it possible to have a chart with left x axis top Y axis all on same chart? I tried switch the value of X and Y but it does not change the location of and y axises.
0
votes
0answers
14 views

Aggregate values by month in Excel [duplicate]

For each row, I need to aggregate values by month. Date Jun Jun Mar Jun Name1 10 11 14 12 Name2 2 34 4 7 Need Result Date Jun Mar Name1 33 14 Name2 43 4
1
vote
2answers
32 views

Need SumIf based in two Criteria

I Need Help I need a SUMIF, when name and date are match. Date Jun Jun Mar Jun Name1 10 11 14 12 Name2 2 34 4 7 Need Result Date Jun Mar Name1 33 14 Name2 43 4
0
votes
1answer
7 views

Display empty cell if referencing empty cell (formula)

I'm working on an excel spreadsheet, and im aiming for a clean interface with almost all cells filled with specific formula. Ex formula on column V : =IF(G1=" LNN ","PENDING", "N/A") What's ...
2
votes
1answer
33 views

Distribute values in Excel based on weight

I have a total number, 300,000. I want to distribute this number over a list of items, where each item has a weight between 1 and 3. The sum of all distributed values should add up back to 300,000. I ...