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

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.

24,481
questions

0
votes

0
answers

8
views

After adding image to excel web, the image resolution is reduced. How do I add image without reducing image resolution?

0
votes

1
answer

17
views

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

0
votes

0
answers

31
views

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

0
votes

2
answers

15
views

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

0
votes

1
answer

17
views

How do I fix this my vertical axis is overlapping the axis title as shown below

0
votes

1
answer

18
views

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

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

0
votes

1
answer

20
views

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

0
votes

1
answer

22
views

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

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

0
votes

0
answers

10
views

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

0
votes

1
answer

23
views

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

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

-2
votes

1
answer

39
views

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
vote

0
answers

23
views

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

0
votes

0
answers

26
views

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

0
votes

2
answers

31
views

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

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

0
votes

2
answers

39
views

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

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

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

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

0
votes

1
answer

17
views

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

0
votes

1
answer

34
views

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

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

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

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

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

0
votes

1
answer

19
views

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

0
votes

1
answer

13
views

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

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

-1
votes

3
answers

21
views

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

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

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

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

1
vote

1
answer

33
views

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

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

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

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

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

0
votes

1
answer

57
views

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

0
votes

0
answers

33
views

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

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

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

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

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

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=&...

0
votes

1
answer

27
views

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

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

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