**0**

votes

**1**answer

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

**0**answers

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

**1**answer

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

**2**answers

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

**1**answer

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

**0**answers

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

**2**answers

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

**1**answer

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

**0**answers

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

**0**answers

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

**2**answers

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

**1**answer

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

**2**answers

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**0**answers

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

**0**answers

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

**2**answers

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

**1**answer

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

**0**answers

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

**0**answers

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

**1**answer

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

**0**answers

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

**1**answer

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

**1**answer

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

**2**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**2**answers

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**2**answers

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

**0**answers

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

**0**answers

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

**2**answers

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

**1**answer

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

**2**answers

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

**0**answers

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

**3**answers

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

**1**answer

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

**1**answer

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

**0**answers

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

**2**answers

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

**1**answer

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

**1**answer

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