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)

-1
votes
1answer
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
0answers
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
1answer
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
0answers
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
2answers
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
1answer
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
0answers
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
1answer
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
0answers
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
2answers
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
0answers
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
0answers
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
1answer
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
2answers
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
1answer
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
0answers
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
1answer
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
0answers
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
1answer
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
0answers
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
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
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
1answer
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
2answers
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
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
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
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
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
1answer
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
2answers
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
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
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
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 ...
1
vote
0answers
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
2answers
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
1answer
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
0answers
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
1answer
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
0answers
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
1answer
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
1answer
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
2answers
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
1answer
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
1answer
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?