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
8 views

Insert high quality image to MS excel web

After adding image to excel web, the image resolution is reduced. How do I add image without reducing image resolution?
  • 1
0 votes
1 answer
17 views

Copying cells for a larger dataset in Excel

My aim is to copy the same values for the same bank over different industries. Are there any functions in Excel where if you drag down and copy the same consecutive values depending on another string ...
  • 1
0 votes
0 answers
31 views

Alternative for ADDRESS function that returns an array

I primarily use LibreOffice Calc instead of Excel. When creating my spreadsheet, I relied upon the fact that the ADDRESS function was able to take a cell range and return an array of cell reference ...
  • 101
0 votes
2 answers
15 views

Search for cells in a single column containing a string and output all matching cells to new column

This sounds a lot simpler than it appears it is to achieve! I am trying to search a column for a strong CONTAINING the word "Task" and then output each of those matching cells into a new ...
  • 1
0 votes
1 answer
17 views

Vertical axis overlapping title in excel

How do I fix this my vertical axis is overlapping the axis title as shown below
0 votes
1 answer
18 views

How to prevent occurrence of or cause Excel to ignore all circular references in a spreadsheet automatically

I have very large Excel spreadsheets. Excel recognizes a large number of cells as having circular references. However these are not true circular references and I wish to avoid all these error ...
0 votes
0 answers
12 views

VBA Change data source for Pivot Chart

I have a file (Europe) with various destinations. I would like to create separete reports with pivot charts for specific destinations that I choose by clicking on the userform (Italy, Spain, France...)...
  • 1
0 votes
1 answer
20 views

Can no longer update Excel chart links in Word, except with a weird workaround

I have a report where some data and charts are generated in Excel, then linked from Word. Normally, the links are updated using a macro, but all of a sudden links to charts no longer update. When I ...
  • 1
0 votes
1 answer
22 views

Finding and Displaying Unique Names

A bit of context: I am working on a short film, which requires a lot of props and assets that need to be made. To keep track of what I need and how each asset is progressing i have made a spreadsheet. ...
0 votes
0 answers
18 views

Why does Excel capture mouse wheel events when it has the focus but the mouse isn't over it?

In modern Windows applications, mousewheel events are delivered to and responded to by whichever application the mouse pointer is over, even if that application doesn't have the focus. For example, I'...
  • 185
0 votes
0 answers
10 views

Excel always crash when I click on a function on the screen

My Excel always crash when I click on a function suggested on the screen. I've updated Office through Windows Update. I've completed Quick Repair and Online Repair, but Excel continues to crash when I ...
  • 143
0 votes
1 answer
23 views

Excel - Combine range to column

I want to combine a range of cells (shown in the screenshot) into a singe column while ignoring blank cells. The order does not matter, the column should look something like this: pr pf pth psz … (...
1 vote
1 answer
38 views

Excel: Split a 2 column range (A:B) into multiple smaller columns with a pre-set number of rows

I'm struggling with a problem; I'm trying to split two columns (A&B) containing anywhere from 100-1,000 rows of information which need to remain together, into multiple columns containing a pre-...
  • 21
-2 votes
1 answer
39 views

Max value for multiple datasets in different orders

I need to find the max value of specific Cities on each sheet. So I would like to write a formula for Max of odd cities (City, 1, 3, 5). The tables are sorted by Salary, not by City alpha. (Cities are ...
  • 1
1 vote
0 answers
23 views

Excel Formula Sum if greater than 0 in Column A and Column B equals text

If Column A has a specific text, I want to sum column B if greater than zero. For example, If I collect fees and then someone asks for a refund then that fee becomes a wash. I don't want to delete ...
  • 11
0 votes
0 answers
26 views

Excel how to create a list of dates and times based on a range of dates and times

I have a data base, in column "F" of dd/mm/yyyy hh:mm. In cell L5 I have a start dd/mm/yyyy hh:mm and cell M5 I have a end dd/mm/yyyy hh:mm. In Cell P5 & Q5 I have two times of day exp. ...
  • 1
0 votes
2 answers
31 views

How to increment a cell references in a formula

Say I have numbers in cells A1 to Z1 and in cell A2, I have the formula A1 + B1. What method can I use so that in Cell B2 all my cell references are incremented by 2 so that the formula is C1 + D1? ...
-1 votes
0 answers
30 views

#solved Formula - If multiple cells say no

I need to know how to do the below formula. IN CELL BZ14 IF Cell BN14,BO14,BP14, BQ14, BS14 and BT14 ALL say no. The result should be - NO LOGGED TRAINING. Please advise thank you
  • 17
0 votes
2 answers
39 views

Merge Rows and Sum Single Value in Excel

I want to merge rows with mostly similar data but sum their quantity values, using the unique "id" value while keeping the rest of the data in the row intact. The raw output looks like this: ...
0 votes
1 answer
28 views

How can I copy a larger number of cells into a smaller number of cells that are already feeding a graph?

I have two 10-cell columns that currently feed a graph (one for the x-axis, the other for the y-axis). I have now doubled the discretization of my dataset, so instead of the original 10 data points, I ...
0 votes
0 answers
18 views

Excel´s Power Query: SUMX not working properly(?)

I'm working on a pretty straight forward Query. I need to add a measure in order to calculate the sum of 5 different columns. My best guess is I need to use SUMX but it is giving weird values. enter ...
0 votes
1 answer
15 views

Excel conditional formatting: contains one string but not another

In an Excel column that I've selected, I would like to apply conditional formatting to any cells that contain the string "US-" except if they contain the string "US-D". Based on ...
  • 1,727
0 votes
1 answer
17 views

VBA code to auto hide rows based upon text in cell A1

I cannot seem to get my code for this sheet to work properly. I have code in there functioning fine which will hide rows based upon whether cells in a range are empty. However I would like to ...
  • 1
0 votes
1 answer
34 views

Finding aggregate return for multiple entries under same name

I would like to find the aggregate return in an excel for trading entries. I have 3 columns, A - name, B - Buy, C - Sell. For instance Sally first entry is Buy 2 and then later on Buy 3, and her last ...
-3 votes
1 answer
24 views

Joining tables with one key and multiple repeating values of the key on the other

I'm struggling to combine two sheets using the column of one as a key, and XLOOKUP is no help since the second sheet has multiple rows that match each of the key rows in the first. Sheet A has 65 ...
0 votes
0 answers
22 views

How to keep a blank row in Power Query when there's no data from the original worksheet?

I appended multiple power queries into one table because I am working with more than one worksheet. Please see my example image below. When I delete the data for Bob and Betty from the "...
-1 votes
1 answer
24 views

Excel: How to count how many times a consecutive text value appears

I'm making a work schedule and I have to pay attention to a specific rule that, no worker should be scheduled to work more than 6 days in a row. I got this spreadsheet where I make those schedules but ...
0 votes
0 answers
31 views

need advice two excel formulas

#SOLVED - =IF(AND(COUNTIF(b3:e3,"Yes")>=1,i3="Yes"),"Remove Online Module",IF(AND(COUNTIF(b3:e3,"No")=4,OR(i3={"Yes"})),"Complete Online ...
  • 17
0 votes
1 answer
19 views

Combine two related line graphs

If I have this data Product 1 Product 2 3.88% 5.71% 0.70% 4.58% 0.38% 4.64% 1.41% 1.62% 5.24% 1.32% 1.15% 6.47% where the percentages (Y-axes values) are a certain metric of the prodcut and ...
  • 171
0 votes
1 answer
13 views

Formatting a column to a type can I have header text that is not that field type and will not cause issues?

If I have a column of data in Google Sheets or Excel can I have a header column that is not that type? For example, I need to have a column of data of type time. But I want to have a header text for ...
0 votes
1 answer
34 views

custom number format: Show "ok" if cell is not empty

In a column I have different values. Some are numbers, numbers + letters, some numbers have a leading 0 (Zero). Therefore I formatted the column as text. With help of the number format I want to ...
  • 178
-1 votes
3 answers
21 views

Excel: How To Transpose Every Random amount of N Rows From One Column To Multiple Columns?

I have a set of multiple choices questions with ABCD as answers, all answers are stacked on a column, but not every question has the same amount of answers. Instead of transposing every nth value, my ...
0 votes
2 answers
31 views

How do I convert a custom function to handle spill arrays (excel)

I need a function that produces a list of sheet names, I already have one that can turn sheet numbers into sheet names but it doesnt handle arrays The function I would like to convert is Function ...
0 votes
2 answers
26 views

MS excel not coping data in correct format from csv file

I am coping data from csv file it contains tables in that table there is column name PostedDate when i copy that PostedDate column in excel it shows wrong formatting (ie instead of / it shows -) ...
1 vote
0 answers
14 views

Excel vs Sheets: use case of rand() as autonomous trigger for sheet calculations?

I recently read about a fairly brilliant and novel use of the rand() function in order to produce (functionally speaking) real-time calculation on G Sheets independent of the sheet actually being ...
  • 762
1 vote
1 answer
33 views

Is there a formula for calculating the difference in minutes or hours between two times?

Is there a formula for Is there a formula for calculating the difference in minutes or hours between two times in two columns? In my spreadsheet I have the following two columns called start time and ...
1 vote
0 answers
22 views

Equation worksheet

Example equation Let's say I have the following equation: A = B - C - D If I know any three variables, I can solve for the fourth. The expressions for the other variables are: B = A + C + D C = B - A ...
0 votes
0 answers
21 views

Call a sheet using a variable name

I have this code in wich I add a sheet with a certain name and then I need to call this sheet to get a cell value but it doesn't assume. Dim nome1 As String Dim tableName As ListObject Dim addedRow As ...
0 votes
1 answer
36 views

updating SUM with latest data

I have a sheet that I am working on. It is a data caputure tool that will enable me to track the Value Added (VA) Score of student data vs their target. For example, a student with a target of 5 that ...
0 votes
2 answers
40 views

Formatting cells to 000-000-0000-0000 in MS Excel

I would like to format cells in excel to the following format: 000-000-0000-0000. This is only an example and the zeros can be replaced with other numbers, but the hyphens need to stay. I think regex ...
  • 1
0 votes
1 answer
57 views

Excel Formula - Cell equals contents of another cell but display blank if the cell was empty

I often have several tabs on my spreadsheets but then have a main page collating data. I use the easy formula cell "insert cell" equals another cell "insert cell". If the original ...
  • 17
0 votes
0 answers
33 views

Food intolerance matrix in excel [closed]

I'm attempting to make a crude food intolerance matrix in excel. The matrix itself is simple enough, however the formula for ascertaining the number of instances where symptoms were found is ...
0 votes
0 answers
39 views

Excel formula to slow down the price column increase [closed]

I'm searching for a formula to slow down the price increasing start from quantity. The image explain better what i'm trying to do. The "A" column has quantity value, and the column "B&...
0 votes
1 answer
38 views

How do I get text from sheet1 from multiple columns, to show up in sheet2 into rows?

I want to create a formula that basically says "Anywhere on sheet1 in B2:D6 where there is text in the columns and ignoring all cells that are blank, automatically make that text appear in sheet2 ...
0 votes
1 answer
23 views

Excel VBA: How to use RegExp.replace to remove characters from a string?

In VBA Excel I am working with Regular Expressions. I have enabled Microsoft VBScript Regular Expressions 5.5 and am trying to use RegExp for the following. Input: "234;BB-154" Expected ...
0 votes
0 answers
14 views

How do I convert this excel formula to work in google sheets? [migrated]

In excel I have this =INDEX(PayoutID,MATCH(TRUE,COUNTIFS(INDIRECT("'"&PayoutID&"'!$D:$D"),$A3)>0,0)) in B3 It looks at cell A3, then using a named range PayoutID (a list ...
2 votes
1 answer
31 views

Proper Syntax for AND OR NOT Excel Formulas

I was practicing some basic formulas in excel. The last 3 I worked on are as follows: =IF((OR(C4="Hourly",C4="Contract")),"Yes","No") =IF((AND(B4=&...
  • 23
0 votes
1 answer
27 views

MS Excel spot difference in a row, find which column the change is in and print out column header

First of all, Hi and thank you for taking the time to read this. I've been thinking of tangling this problem for a while now and decided now is as good of a time as any. The problem is as follows: Let'...
-1 votes
0 answers
36 views

Long to wide format with inserted blank rows

How can I covert an Excel table from long to wide format, inserting blank rows for missing "values" (days): ID: subjectId should be grouped by DailyTIL.TILDate, where one should follow the ...
0 votes
2 answers
59 views

Find column of the last appearance of a value

I have a table like this: A B C D E 1 2 3 3 5 5 1 3 2 3 2 2 1 3 3 For a given number in the table I want to have get the letter corresponding to the column of the last appearence of the number in ...
  • 192

1
2 3 4 5
490