Questions tagged [microsoft-excel]

A spreadsheet application by Microsoft. Use this tag along with [vba] if your question involves programming Excel in VBA, and with [worksheet-function] if it involves an Excel formula or worksheet function.

Filter by
Sorted by
Tagged with
0
votes
0answers
25 views

Excel - Matching Two Tables Based On Criteria

I need help with the following: I am trying to link the output of a table based on if set criteria are met, for example, if the function is listed as business process and the individual has grade A ...
-2
votes
0answers
26 views

How to remove “Sorry, we couldn't find [filename]. Is it possible it was moved, renamed or deleted?” prompt from Excel on open

Ever since I've removed SharePoint sync from my PC, I've been getting this message each time I open Excel. I've tried uninstalling and reinstalling Office, deleting the cache at the upload center, ...
1
vote
2answers
38 views

Concat of several cells with custom separator

After applying CONCAT to the range of cells and trying to combine it with custom separators, function returns only the first object of the list. Function that I'm using - =CONCAT(A1:A3&" "&...
-1
votes
1answer
23 views

Excel - Extracting multiple matches into separate rows

Hello I am trying to extract the matches (Item2) for the Item1 column into separate rows, so I have a head with the Item1, and then under it all the matches for this Item1 with the column Item2 . ...
0
votes
2answers
48 views

Date filtering in Excel Online

I might be completely overlooking the feature, but i've been trying to filter a range of dates to only display today and future days in Excel Online (365). At first sight it appears that there is ...
0
votes
1answer
41 views

Looking for the mathematical equiv of the PMT function in excel

I have a question which I am analysing for a university paper, which is asking for the monthly payment on an investment after 1 year. I have plugged the values into Excel and have found the payment ...
19
votes
5answers
2k views

How do I get the =LEFT function in excel, to also take the number zero as the first number?

My data contains a column of room numbers. Each room number's first 2 digits is the floor number where the room is located. The =LEFT function works well for data that does not start with zero. The =...
0
votes
1answer
41 views

Filtering data for graph in Excel

I have a x and y set of data I am trying to filter for a graph. The problem with my data is there are too many points, and I would like to filter out a significant amount of the data. In my case, I ...
0
votes
1answer
11 views

Excel: Strange behavior related to INDIRECT pointed to itself

Using Excel 2013 ... I was playing around with the INDIRECT function and found a very strange sequence of results. It occurs when I place the INDIRECT function in a cell (for example, A2) and ask for ...
0
votes
0answers
28 views

Split row into multiple row based on comma delimited value in one column with excel vba only

A B 1 a,b,c 2 d,e 3 f,g,h I want this to be as below A B 1 a 1 b 1 c 2 d 2 e 3 f 3 g 3 h I need this with excel vba
0
votes
1answer
43 views

Excel: Find identical values & return different values from same rows

Ok, I hit a stop here and don't even know where to begin. The scenario (interface between two student information systems) is as follows: I have two worksheets W1 (roster comprising all available ...
0
votes
1answer
38 views

Excel: how to manually set alternating background color?

In a pivot table, only one column has alternating background color. The other columns have no background color. How do I manually set the alternating background color? So far, I have found no way of ...
0
votes
1answer
35 views

Is there any way in excel to show last line of a cell when we reduce height?

I am wondering if there is any method or function to show last line when we reduce the height. Let's say in a cell there are three lines. This is line 1. This is line 2. This is line 3. When I ...
1
vote
2answers
23 views

How to concatenate or combine multiple cells with header

I am trying to combine columns a2 through to z2 including the column header for each item and then apply to about 3500 rows. It works when i enter =A1&A2&"----"&B1&B2&"----"&C1&...
0
votes
2answers
13 views

Excel formula to sum value in column to the left in array formula based on criteria

I have a row that looks like this: |52|52|52|_|_|_|_|_|13|B|_|_|_|_|_|24|C|_|_|_|_|_|18|B|_|_|_|_|_|16|A| The vertical pipes represent columns and the underscores represent blank cells. I want to ...
0
votes
0answers
29 views

ppt vba code stopped working after months of proper work

I have a PPT file with a small number of slides and objects that run macros. Some of the macros write to an Excel file and some extract data from such files. I am using Office 365 Business. The code ...
1
vote
2answers
51 views

Excel how to do math with row or column indexes to create cell references?

I have the following values in my excel: shift 2 data 131 12 55 23 45 11 23 45 119 77 I would like to define a formula which refers to the n-th cell to ...
0
votes
0answers
19 views

Formula for recording the changes of a cell, not VBA

Basically, I often use my excel files on Ipad, so there is no VBA support. Then, I can't track my changes during the day (no recording). I just want to ask: "Is there any formula to solve this ...
0
votes
1answer
65 views

How to auto-insert text from a cell into a part of an Excel formula (GETPIVOTDATA, specifically)

I have this formula: =GETPIVOTDATA("[Measures].[Sum of Daily_Income]",'After-Tax Income'!$A$3) Above it is cell B2 with "Daily" written into it. I want to make it so that the "Daily" in "[Measures]....
0
votes
0answers
23 views

Chart Data Based On Cell Value

Project Task Chart Hi, I'm trying to chart the progress of project tasks dependent on the status of the project. I have a table with all projects and the % progress and % remaining for all tasks ...
0
votes
1answer
55 views

Excel doesn't accept formula

Another SU thread, How do I change whole number into a decimal number in Excel?, deals with the problem of taking a multi-digit whole number and inserting a decimal point between the first and second ...
0
votes
0answers
25 views

Does anybody encounter this bug ? formula should return 0 but return 5,6843418860808E-14 [duplicate]

I got thjis ultra simple formula in cell F2 = F1-E2+D2. it is simply to calculate balance of an account from debit and credit amounts : old new balance = old balance - debit + credit But, if F1 = n, ...
1
vote
1answer
36 views

Office 365 Security

I have a work based Office 365 account and am looking at working remotely, if I open an Excel file on Office 365 it will open Excel online, however, if I want to work on a more complex spreadsheet I ...
1
vote
2answers
41 views

Switching X and Y values for every series in scatter chart

Oy people! My problem is as follows: My data table: Selecting the data and creating a scatter chart nets me such a result: Then for each series I have go and manually edit them, switching X and Y ...
0
votes
0answers
18 views

Keep the error bars in foreground in Excel scatter chart

Often in my work I place vertical scatter data inside a graph and overlay a single data point corresponding to the average of that group of data. When I place error bars on that average, the error ...
0
votes
0answers
28 views

Excel for Mac gives “cannot open file… format or extension not valid” error for custom add-in when pulling from git

I am currently working on a custom Excel add-in which, until now, was only used on Windows. I am attempting to make it cross-platform. Unfortunately, when I pull my add in from git and attempt to load ...
0
votes
2answers
35 views

Special characters not recognize from Google Sheet & Microsoft Excel

I have developed a web crawler to extract some information and print them to an Excel spreadsheet. However, neither Excel nor Google Sheet recognize some special characters, see below: The text ...
0
votes
0answers
28 views

Color column in Excel based on two cell's values

I have two columns, C and I. which contain data. Both columns have time stamps in them (ex. 11:00:00 am). I need to write a logic formula that has C>= to 11:00 AM and I <= to 11:00 AM, and if ...
0
votes
0answers
15 views

Excel Macro Module blank

I have been having this problem for a while, all my macro codes just go blank and they don't function and excel crashes when I press the Macros button on the Developer toolbar. Tried searching ...
0
votes
0answers
26 views

Macro for Returning Multiple Values into One Cell

I tried using a macro formula from a YouTube video to do this but it came back with an error...maybe a slight adjustment will fix... Function Lookup_concat(Search_string As String, Search_in_col As ...
0
votes
1answer
13 views

How to prevent pivot table from resizing after refreshing data?

I have slicers and pivot tables on a single sheet and would like to preserve the pivot table size after refreshing the data. Any ideas as to how I can achieve this?
0
votes
0answers
23 views

Excel IF and SUMIF

I have a formula =SUM(H80/G80) which is giving me a total for the full set of data. H80 and G80 are subtotals =SUBTOTAL(9,G1:G79). I now need to break it down to 2 text variables from column E. I ...
0
votes
1answer
22 views

How to get Slicer to multi select instead of multi DEselect?

Adjusting the multi select setting on my slicer makes it deselect items. However, I'd like to select multiple filters instead. How would I go about doing this?
1
vote
1answer
24 views

Excel: Match with value and interval

I have a question regarding a formula in Excel. I have Sheet 1 and Sheet2 How do I need to write the formula (using Index and Match) in order to complete the blue cells from Sheet2. I've tried to ...
1
vote
1answer
31 views

Mysterious MS Excel error: Cannot find [..]!Local_Close_Sheet, which has been assigned to run each time myfile.xlsx is closed

I receive a mysterious error each time I try to close myfile.xlsx. Cannot find 'X:\WINFDC[FADRVR32.XLA]FADRVR32'!Local_Close_Sheet, which has been assigned to run each time myfile.xlsx is closed. ...
0
votes
0answers
21 views

VBA - Bing translation, how to copy from Bing to Excel?

Problem: Cell A1 has texts in Spanish. The code opens IE, goto Bing, translate A1 texts into English. Code works great so far. But now, I don't know how to copy the result (English) back to excel (...
0
votes
0answers
39 views

How to use a formula to Count Distinct Values in a Range according to multiple criteria (date range) without it taking too long to process?

My question is how can I make the following formula process quicker? Currently, whenever I make a change to date range, it can take up to 10 seconds to process. The data I am sorting through can have ...
1
vote
1answer
53 views

Excel: Find doesn't find it

In my spreadsheet, there are three 2,280,000. One of them is a calculated value, 19000*120, the other two are plain numbers. When I used the Find/Replace function to find 2280000 by formulas, it only ...
0
votes
0answers
21 views

Sumifs not working but countifs is for same conditions

I've got a sumifs function: =SUMIFS(Master!DK:DK,Master!E:E,1,Master!AL:AL,Sheet1!H2,Master!N:N,Sheet1!A2) that is returning 0 when it should be returning 2. There is one row matching that criteria,...
0
votes
2answers
69 views

adding numbers inside a text

I have cells containing number and text and I would like to sum only the numbers at the end of the cells. here is an example of my cells : L4-R4 L8-R9 L11-R11 L12-R11 L12-R11 L9-R9 the answer ...
-1
votes
1answer
46 views

Compare multiple cells from one row (EXCEL)

I really don't know if I am at the right place to ask this question, but I didn't find an answer anywhere. I am looking for an Excel formula (no macro or dynamic stuff) to compare the text values of 6 ...
0
votes
2answers
36 views

Based on Cell Value matches column with Yes or No

please see the table below. I have Columns like ColA has some value, Store has Store Names. And rest column names defined as unique cell value in Store1 column(Store1 till storeN. ColA Store ...
0
votes
0answers
20 views

The remote procedure call failed. (Exception from HRESULT: 0x800706BE)

While creating the excel file in the server exception as The remote procedure call failed. (Exception from HRESULT: 0x800706BE). In the same server before the exception, the application runs properly. ...
0
votes
0answers
46 views

Create a calculation based on previous date and specific identifier

I have an excel table that has a list of measurements and dates those measurements were taken. Each measurement is from a specific location. I need to perform a series of calculations that are based ...
0
votes
1answer
26 views

Clicking button causes quick zoom in and out

Sometimes when I click on a button in an Excel spreadsheet I've created, when I release the button, the worksheet quickly zooms in and out. There isn't anything in the VBA code to tell it to do it and ...
0
votes
0answers
66 views

How can I stop Microsoft Excel or Word from starting automatically?

When I start my computer, either Microsoft Excel or Word starts automatically with an empty page. I think it's the program I've opened last. I've removed and reïnstalled Office completely, this didn't ...
0
votes
0answers
30 views

Excel INDEX/MATCH function difficulty with CSE

I have an INDEX/MATCH function in one of my formulas to look up and match information with multiple criteria. I know that the first time the formula is entered, it is required to use ctrl+shft+entr (...
0
votes
1answer
20 views

Excel VBA Copy and paste to different workbook at end of existing data

I am trying to combine data from several workbooks into one master workbook I have 3 workbooks that all have a tab named company and I want all the data they contain to be pasted to a new workbook on ...
0
votes
2answers
62 views

Excel 2016 - Apply Conditional Formatting based on value of a prefix label

Hi I am trying to apply conditional formatting using the following search function: - =ISNUMBER(SEARCH("S",$C1))=TRUE My problem is that the "S" has been applied using custom format to insert the ...
0
votes
1answer
71 views

Lookup in Excel between tables

The image below shows three parts of my table. The yellow cell is the cell I am trying to pull information into (cell F18) which is in the Know Your Business table. The red cell is my drop down by ...