**-1**

votes

**1**answer

23 views

### EXCEL: Can I get a count of a certain value from columns with certain headings, only from the columns with certain text?

A screenshot of the spreadsheet1
Hi
I am looking for a way (in the form of an Excel formula) that can do this
I need to count the number of "o" in columns with headings "Threat", for each row. For ...

**-1**

votes

**0**answers

40 views

### Excel Formula to show All dates in a range after today [on hold]

I am trying to build a spreadsheet that I am using the lookup feature to take data entered on sheet 1 to locate that data on sheet 3, I need it to then list all Dates after today for the current ...

**1**

vote

**1**answer

34 views

### In Excel, is text zero or what?

I have a column of numbers that also contains the letter T. If I use a simple IF(A1>0,..., the letter T is treated as greater than zero and produces the "true" result. However, if I use ...

**0**

votes

**0**answers

10 views

### Auto-Fill data between two spreadsheets, adding new row, keeping same column, when new val

So I have a list of items that need to be constantly added to a list for auditing purposes. Problem is, the item names constantly change and also on occasion, new items are added.
Essentially, I am ...

**0**

votes

**2**answers

22 views

### how can I see what TYPE of data is in my macro?

I have the following code that doesn't work inside a macro:
count = Application.Sheets.count
ans = type(count)
msgbox("count is " & ans)
but this doesn't work cause I think type is looking for ...

**1**

vote

**1**answer

22 views

### Excel make a list with a specific conditions

I work in a hospital, have a list of patients, with name, date of admission, date of dismiss, and diagnosis. I need a list with all data when date of dismiss is blank, if contain something must skip ...

**0**

votes

**0**answers

20 views

### Excel autocomplete/ suggestion list. Not a drop down

I am using Excel to record various data and some rows have more cells than others.
How can I make a list of words for Excel to use to autocomplete when I am entering data manually.
I don't need a ...

**0**

votes

**1**answer

28 views

### VBA warning when cells selected are not equal to 5 and contiguous

My Vb macro does the following:
I select 5 contiguous cells, run my macro and I get 5 static random numbers between 1 and 50;
It works perfectly;
I need a warning when the selected cells are not ...

**0**

votes

**0**answers

14 views

### Excel save relative formula for re-use

I need to go through a sheet, filtering on a series of fields and running a formula against the resulting columns.
However, typing the formula each time is slow and annoying.
How can I save the ...

**0**

votes

**2**answers

11 views

### Excel filtering all cells in column instead of those filtered

I am trying to add column value in a sheet with a filter applied.
The problem I have is that Excel is adding values for rows that have been filtered out rather than just those the filter is showing.
...

**0**

votes

**0**answers

13 views

### Advance Filter with multiple criteria

I have three worksheets
ConditionSheet : Having conditions value in cell E5 & E7
SourceSheet : Complete Data
TargetSheet : When I run macro New worksheet create with this name based on ...

**0**

votes

**1**answer

44 views

### Extract multiple substrings from Excel cell

I have a horribly formatted column where each cell can contain zero or one or more entries like the following (this one contains two):
ACTI-U-9754 - Some description MDCF-U-9791 - Some other ...

**0**

votes

**1**answer

11 views

### Unable to remove columns based on data-type using Power Query

I am trying to automate a load process and want to know if it is possible to perform column wise operations in Excel Power Query. Specifically I want to know how to either keep or discard columns ...

**0**

votes

**1**answer

34 views

### How does this SUMPRODUCT(COUNTIF( )) function work?

I was searching for a solution to count distinct values in a range, and came across this article. The example provides a list of ten names comprised of four unique entries. It then uses the ...

**0**

votes

**1**answer

14 views

### Getting Excel to Auto Increment correctly

I have a question regarding Auto Incrementing when dragging formulas.
I have several series of data in columns on a sheet and I am trying to reference them on another sheet.
So on sheet2 I place the ...

**1**

vote

**1**answer

26 views

### Conditionally centering text in an Excel formula

Is there a way to tell Excel to center the text and keep a numeric value right aligned. For example in the formula =IF(+A1=+A2,"Match",+A1-A2), I would like Excel to center the word "Match" but right ...

**0**

votes

**0**answers

22 views

### Locked cells are editable. Why? [on hold]

Why am I able to edit the contents of a locked cell when the sheet is protected? What am I missing. When I select "Protect Sheet" the only choices I make available are to select locked cells or ...

**-1**

votes

**1**answer

69 views

### How do I reference another cell based on the value of another cell?

No one understood my question which is understood due to my bad explanation.
I'll put an example to avoid further confusion.
In Sheet2 I want to change A2's formula then it will fill B2,C2, and ...

**1**

vote

**2**answers

32 views

### How to use OR in a COUNTIF function when dealing with dates and “>” characters

I want to write a function whereby I could count a cell if it is blank OR greater than a date.
This is a piece in what will be a much larger formula so looking to avoid a solution of ...

**-1**

votes

**1**answer

61 views

### Formatting any cell referenced in a Formula [on hold]

I have two sheets, one with formulas pulling data from the second. I need to create a macro or some conditional format to highlight the cell green if the data was pulled from the second sheet. sheet ...

**0**

votes

**0**answers

42 views

### multiple IF conditions and answers

This is a cashflow spreadsheet. I want the column next to the expenses column to show me the source of the expense.
The expenses are arranged in spreadsheets, so for example; checks, taxes, general ...

**0**

votes

**1**answer

29 views

### Can PivotTable create Pareto buckets?

Is there a way to use a pivot table to create cumulative buckets or brackets...from either built in functionality or a back-door method? My analysis is to show aggregate data for items that comprise ...

**2**

votes

**0**answers

19 views

### Fill one Word Form and Get Several Different Docs Filled with same information [on hold]

In my word form there are spaces for name, surname etc. I also have some other documents that have similar spaces for similar things. Every time when there is a new case, I have to fill the form, fill ...

**-1**

votes

**1**answer

36 views

### Formula to return “N/A” when other cell value is “No”

How do I get one cell to come up with "N/A" when "No" is selected from another cell's drop down?

**0**

votes

**0**answers

15 views

### Sorting and separating by category in creating a macros [on hold]

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

50 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

21 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

**2**answers

27 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

38 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

48 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

48 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

34 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

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

**1**

vote

**0**answers

20 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

89 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

67 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

43 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**

vote

**1**answer

34 views

### Find the last data in a table with conditions [duplicate]

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

15 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

30 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

20 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

30 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

19 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

**3**

votes

**1**answer

329 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?