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
0 answers
4 views

How to edit legends of a chart from cell range

I have a list of legends and plot data in separate file. When I plot the data it creates legends as series1, series2, and so on. Now I want to replace the legends from cell list in other file. I can ...
user avatar
1 vote
2 answers
14 views

How do I convert an Excel calculation into a spilled dynamic array

I'm not even sure how to ask what I'm looking for, without describing the full question. if I have this table (CSV form at the bottom if anyone wants it): A B C ...
user avatar
3 votes
2 answers
19 views

Excel - Need formula help for project at work

I am working on a project at work where I am pulling a report each week from one of our systems and pasting it into a "DATA" tab in a workbook. There are then 6 other tabs that are specified ...
user avatar
1 vote
1 answer
15 views

Excel/GoogleSheets Forumla to List All Rows Without A Corresponding Value in Another Column

I'm hoping there is a simple way to perform the following. I have 2 columns (A,B), and I would like a third column (C) which consists of all values from column A that have an empty cell in column B. I ...
user avatar
1 vote
3 answers
29 views

Index of value in table with variable row selection

I have a table like the following: My problem is the following: I want to be able to get the index of the row of the value, when the value and column are specified. Example: Col 3 and 1 should output ...
user avatar
  • 11
1 vote
2 answers
26 views

Drag formula 8 rows, but in a pattern that skips only 2 rows

So I have this problem where I need to drag down a formula 8 rows in the A-column but it should only jump down 1 row in the E column. So A2=Item_1, A9=Item_2 and so on. Can anyone help with a formula ...
user avatar
0 votes
0 answers
22 views

Inserting 1000 rows to Table Excel

I have a large table with approx 110 calculated columns and one row as a template, to which users paste a certain amount of rows - this ranges from anywhere between 30 and 200'000. The way I do this ...
user avatar
  • 1
0 votes
1 answer
13 views

comparing 2 cell formula and getting either 1 cell value or get value of 0

can anyone advise the following formula, cell A = a value cell b = a value wanting the formula at cell c. if cell A > cell b, will use cell A value, if cell A < cell B , will use 0
user avatar
0 votes
0 answers
22 views

Conditional formating of groups in excel

My goal is to flag (via conditional formatting) any cell with the same 'code' but different 'prices' with in the same 'column'. I have added a screenshot of what the final output should be. Is this ...
user avatar
0 votes
1 answer
22 views

Excel: Get max value in specific row with row number retrieved by a formula

I should like to get the max value in a specified row in another worksheet, where the row number is retrieved by a formula. I can call up the desired row number from the sheet called “Kur” by this ...
user avatar
1 vote
0 answers
22 views

Disable splash screen on Office 2016

How to disable this splash screen when starting Office applications such as Excel? Note: /q does not seem to work, /nologo idem, /splash idem /e disables the splash screen but does not open an ...
user avatar
  • 1,606
0 votes
0 answers
27 views

How to add color to specific text in excel output file using powershell

I have written a script to check the nslookup for each server and export the details to Excel Please help me on How to add color to specific text in the Excel output CODE $result = foreach($Server in $...
user avatar
  • 63
0 votes
1 answer
17 views

trying to randomize 2 cells adding values to it randomly to every week of the month for every employee

New Bei - First line >is dates, second is days and the third is week number. This is how my data look like. it is a weekly off register wherein I need to add word "WO" randomly in only 2 ...
user avatar
0 votes
3 answers
21 views

Move a marker based on cell value

basically I am trying to move a marker (or any shape like a circle or whatever) based on a cell which can have a value between 8 and 24. Imagine like a reverse slider which moves from left to right ...
user avatar
  • 1
0 votes
1 answer
29 views

Automatically duplicate the same formula when adding new rows

Let's say we have a formula in column B, for example =LEFT(A2; FIND(" "; A2)) but it could be anything else. How to make that, when adding a new row in the future (here on row #4), the ...
user avatar
  • 1,606
0 votes
0 answers
7 views

DAX formulae to reflect "show % of..."

This is related to this question, but as I am a brand new user (yay) and cannot comment (unfortunately), I had to start a new question... So, is there any way to get a % of column total using a ...
user avatar
  • 1
0 votes
3 answers
28 views

Microsoft Excel, cannot extract the numbers of the date from a table header

I have searched similar problems but I couldn't find them. So sorry if I ask the same question. My excel table: This is the formula in C15: =DATEDIF(B15,$C$12,"Y") Using: =year(B15) ...
user avatar
0 votes
2 answers
31 views

How to get a running sum - floating above the cell

I have a column of natural numbers (1, 2, 3...) and I want to know the sum up until a certain point without opening a new column that would calculate the sum. Basically, I want to have a floating ...
user avatar
0 votes
0 answers
37 views

Random BSOD opening excel files

At my office, we have several users that when they open some of their excel files, it goes right to BSOD before Excel has a chance to open. There is no pattern to the excel file or the user. The stop ...
user avatar
0 votes
2 answers
24 views

array difference and/or intersections in Excel

How to get the difference and intersection between arrays? (Possibly w/ dynamic arrays functionality) I want {"a","b","c","d","e"}-{"a",&...
user avatar
  • 11
0 votes
1 answer
13 views

Identify first occurrence of group of repeated values in excel, but groups could be repeated

So I have a column in excel that looks like the first column in this screenshot: Data screenshot The "existing result" column comes from this formula which is easily found from googling: (...
user avatar
0 votes
1 answer
18 views

Find number of simultaneous activites from a list of times

I have a list of activities that contains place, start time and end time. I want to find the number of simultaneous activities at each place. I have found ways to calculate how many other activities a ...
user avatar
0 votes
1 answer
31 views

Excel Pivot display multiple columns

I had a Salary data month wise now i want to calculate the difference between last 2 months salary field wise below is the sample data Required Sample output of single employee. I have tried using ...
user avatar
0 votes
1 answer
19 views

Convert from table to matrix format with Excel 2010

I would like to convert this data from table to matrix format where the names in the dest column become columns and the number values corresponds to the total but the origin column stands still origin ...
user avatar
0 votes
1 answer
16 views

Excel countifs ignore one specific column

=if(COUNTIFS('Finishing Results'!G5:N5,'Finishing Results'!P5:AC5,"1")=0,COUNTIFS('Finishing Results'!G5:N5,'Finishing Results'!P5:AC5,"1")) Trying to exclude ('Finishing Results'!...
user avatar
0 votes
1 answer
19 views

Excel Pivot Table: Show aggregated data in one column and the actual data in another column

I have an excel document and inside this document, there are two sheets: 1. Actual Project Hours 2. Planned Project Hours. The actual project hours is broken down into projects, resources, hours taken ...
user avatar
0 votes
1 answer
19 views

How can I remove two across straight line in a scatter plot graph?

so I connected dots on the scatter graph but I got the two across lines in the middle. How can I remove them? I'm using Mac version. Thanks
user avatar
0 votes
1 answer
31 views

My workbook is 2 sheets. the 2nd looks in the 1st for a match on a name and returns the value in a cell from the row where the matching name is found

I asked this question before and got an answer that worked well, however, it no longer does. I've spent the last half hour trying to find it on site but can't. So anyway, I'm like to attach a sample ...
user avatar
0 votes
1 answer
31 views

How to split certain random row values in a specified column

I need to find who are our top business clients according to total sales and by products. This is easy while using a pivot table. But the problem is data in excel is not clean. I need to split one ...
user avatar
0 votes
1 answer
18 views

How do I syntax a simple logarithm in a spreadsheet formula?

simple logarithm How do I syntax this question in a spreadsheet formula? Trying to find N. (see image on at top) Don't know how to write the formula for this, or what function to use. s = 4 e = 2000 ...
user avatar
0 votes
2 answers
34 views

Converting an excel field with multiple units of measure into one

I have an Excel imported data field that comes in with multiple units of measure. I need to convert that into a single unit of measure. Data field example: "7 gal 45.2 fl oz" I need to ...
user avatar
  • 1
0 votes
1 answer
30 views

Retrieve data from specific table format

I'm having some trouble in Excel.. wondering if someone could enlight me? Suppose you have an excel with two sheets , sheetA and sheetB on sheetA you have a table such as this item 1 a ...
user avatar
0 votes
0 answers
22 views

Keep a Workbook open after a VBA Save to another file

I have a workbook that is updated from an external source. The code works but it closes both the Source Workbook and the New Workbook. How do I edit my code to keep the Source Workbook open? Here is ...
user avatar
0 votes
2 answers
29 views

Summing only the latest values for the entries

I would like to sum the values of only the latest entries. Please see example below: Deal name Value Green grass 110 Firebolt 220 Green grass 230 The formula would only sum the last two to get ...
user avatar
0 votes
1 answer
15 views

Excel conditional formatting of groupings with a variable number of rows

I have a vehicle electronics inventory with a multiple and variable number of rows per vehicle representing devices installed in that vehicle that I would like to format with alternating colors per ...
user avatar
  • 1
0 votes
1 answer
29 views

Ignore errors when updating links in Excel

I have an Excel file with over 100 sources. When I go edit links, select them all and go update it stops for prompt if it finds that source file is missing. Is there any way that I can skip that, so ...
user avatar
  • 387
0 votes
2 answers
26 views

Create a formula including nth values in excel

Say i want to use this formula "(x1*m1+x2*m2...+xi*mi)/m_tot" in excel. Where "xi" is found in every 6th row and "mi" is found in every 6th row in another comlumn. "...
user avatar
-1 votes
2 answers
33 views

Remove Excel Duplicate Columns 123 , 123-1, 123-3

I am facing this problem where I want to remove duplicates in columns in Excel. For example in 1 column I have these types of values: |Values| |123| |123-1| |123-2| |123-3| I want to have only the 123-...
user avatar
  • 1
0 votes
1 answer
18 views

Merge & center for multiple boxes

I would like to merge & center every values in this photo so each spans 2 boxes horizontally. May I ask are there ways to perform this, instead of manually 'merge & center' each of the values? ...
user avatar
  • 103
0 votes
2 answers
27 views

Dynamic Table Name in Excel Lambda Function with Structured References without INDIRECT

Is it possible to define an excel lambda function that takes a parameter that acts as a "dynamic" name for a table, that is then used in a structured reference, without using the INDIRECT ...
user avatar
0 votes
2 answers
55 views

Excel Sort Command not working AT ALL as expected

I have a table in excel (formatted as a Table), that does allow me to sort, but its results are incorrect in at least two ways: the numeric value column I am sorting on A-Z or Highest-to-lowest comes ...
user avatar
  • 3
0 votes
1 answer
49 views

Accessing a Password-Locked 1997-2003 .XLS?

My father passed away close to a decade ago and I'm trying to access a master file of his that appears to be a 97-2003 password-locked .XLS notebook. None of his known passwords have worked, and I've ...
user avatar
-2 votes
0 answers
19 views

#ASK how to get number_id in different sheet

Hello i want to ask a question what is formula to get customer ID ?? i ald use match and index still got #NA can someone help me i want to convert this XLSS file to CSV and then i'll update it to ...
user avatar
3 votes
1 answer
84 views

How to split multi-line clipboard data (e.g. from Excel) in single-line "pastes", one CTRL+V at a time

To illustrate my dilemma as simply as possible: I have a list of values ranging from 1-10 that I want to copy and store. When I press Ctrl+V (or any paste execution), I want 1 to be displayed. When I ...
user avatar
0 votes
2 answers
29 views

Sorting Function in sheets or excel

How do I do a repeated function in excel? I want the pattern to go: (Vertical) =a1 =b1 =c1 =a2 =b2 =c2 =a3 =b3 =c3 and so on. this will go on for until: =a400 =b400 =c400 Example in sheets
user avatar
  • 1
0 votes
4 answers
40 views

How to calculate an average of numbers when some cells in the range are not a number?

I'm trying to calculate an average number of days to resolve from some data I have. However, in some cases, because the problem hasn't been resolved yet, Excel thinks the number of days is #NUM! I'm ...
user avatar
0 votes
2 answers
21 views

Searching for a unique value associated with a category that is duplicated

This is my first time diving into excel and I'm currently trying to create a formula that finds the highest score in a certain category. I've left out some data for privacy reasons, and because it's ...
user avatar
  • 1
0 votes
2 answers
32 views

How to check two rows for two separate values and then populate each applicable value?

I am building a simple workflow. The functionality I am attempting to build is a column that will be used to show if something needs to be completed. Identification: Column B is the column that needs ...
user avatar
0 votes
1 answer
23 views

Excel function goal seek

I have 2 questions about the Goal Seek function: Can I set the "To value:" to equal the value of a specific cell such as U3? How can I do this function for 5 cells at the same time?
user avatar
0 votes
3 answers
24 views

How to have the data from one sheet put onto another sheet automatically via formula?

I know this formula: ='Sheet1'!A2 When pasted on Sheet2, it will put the contents from Sheet1's A2 cell into the Sheet2 cell that holds this formula. I can drag the formula to the subsequent cells. ...
user avatar
  • 119

1
2 3 4 5
471