# 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. Also add the the specific version tag (e.g. [microsoft-excel-2019] or [microsoft-excel-365]) as features and functions may vary between them.

25,959
questions

0
votes

0
answers

19
views

### Need Help Migrating A Drop Down List From One Workbook To Another

I need some help migrating a drop down list and the data selected from that list to another workbook.
I have a list of people that need to be contacted each week, with an updated file that is sent to ...

-2
votes

2
answers

33
views

### Excel function for filtering a list of substrings to include & exclude

Excel function where if any row values in column A include a keyword from the list in column D but does not include a keyword from the list in column E, write True, otherwise, write nothing/keep it ...

0
votes

0
answers

33
views

### Excel Index(Small(IF Issue

I'm looking to improve a formulas. The formula is:
=IFERROR(INDEX(IndexColumn,SMALL(IF(MilestoneColumn=TODAY(),ROW(MilestoneColumn)-ROW(MilestoneColumnFirstCellLocked)+1),ROWS(...

0
votes

1
answer

30
views

### Cascade formatting Excel formula

I use Excel and Smartsheet a lot and make some very complex nested formulas. Because these are written in sheets rather than in any kind of IDE, there is little or no formatting to them for legibility,...

0
votes

0
answers

40
views

### Excel XLOOKUP with Wildcards - Functionality Change

I'm playing with XLOOKUP with wildcards (Match_Mode 2). I believe it used to be if you want it to return results where a item in that excel it was = =XLOOKUP(""&"Text"&&...

0
votes

0
answers

31
views

### How to keep a constant number of line on a page after a macro modify the sheet

I am working on a page to list mechanical part and all the possible variations of components of that part, some of this have more than 21 lines. When I use the macro the lines with value 0 are removed ...

-1
votes

1
answer

44
views

### I have created a chart in Excel but the percentage bar length is not increasing

I have created a chart in Excel but the percentage bar length is not increasing. All data is fine in chart, only the bars length is the issue.

0
votes

3
answers

87
views

### Double XLOOKUP in Excel

I have an Excel-workbook containing two sheets:
One sheet contains the names of students with their evaluation
And a second sheet containing the "mappings" between the criteria and the ...

0
votes

1
answer

33
views

### Fill in missing data from date series in Excel

I have a set of data that looks like this when imported:
I would like two transformations:
Missing dates filled in to ensure all dates between the start and end dates are accounted for. Note the ...

0
votes

1
answer

23
views

### Excel: Worksheet.Calculate causes UDF to run infinitely

I have written a udf returns an array that is inserted at the cell location.
the udf can be long running as it reaches out to a rest service to fetch data from a database. so i added a button on my ...

-3
votes

0
answers

29
views

### Excel Formula that increment every 3 years to the current year [closed]

What formula should i use if the Date hired is increse every 3 years if 2016 is the date hired what is the last increment as of the current year.. that show 2022?

1
vote

1
answer

36
views

### Exporting excel data with powershell for robocopy

I have on my hand a 300 lines excel sheet with source path and destpath for robocopy, to avoid copy paste all the path on a .bat file I try to make this powershell script:
# Import the Excel module
...

0
votes

1
answer

60
views

### How to filter Excel list using data validation lists and matrix

I have a table of document names in the first column, and users in the following columns. I'm using the rows beneath each user to assign them documents to review. The list is quite long and I'd like ...

0
votes

0
answers

35
views

### Excel treats a date in format (dd-MMM-yy) differently if typed or pasted

This was discovered when opening a file in CSV format that has a column of dates in the format dd-MMM-yy (e.g 20-FEB-24). When opening this file in Excel (Excel 365 desktop) if the 2 year value is <...

-2
votes

0
answers

37
views

### Trying to build a quoting tool on excel [closed]

Trying to build a quoting tool on excel.
I am aiming for it to allow me to add in different quantity's in column . Then populate from other columns and rows with matching data. To output value.
...

-1
votes

1
answer

45
views

### Excel formula for returning list of values that match criteria

Sheet 1:
A B C D E
1 **Category** **TOM** **BOB** **JIM** **TIM**
2 Product 1 1 1 1 0
3 Product 2 ...

0
votes

0
answers

15
views

### Assigning Excel add-in macros to ribbon using a relative path

I am trying to create a basic Excel GUI for a Python software which uses Excel spreadsheets as inputs.
I have managed to create a basic add-in with a macro which runs the Python code for me.
To make ...

0
votes

0
answers

43
views

### group by date and get total profit

Excel table
i have a data of my closed transaction. i am doing analysis. here we have different lot size with different profit. lot size starts from 0.01, 0.02, 0.04, 0.08, etc.
i want to group ...

0
votes

1
answer

29
views

### Text to Columns not working unless each cell is double clicked into

I have a use case where I'm exporting a Windows event log to CSV and then need to split one column's cells into columns based on newlines.
As advised in multiple places, I managed to insert a newline ...

0
votes

1
answer

24
views

### Excel change orientation of linked data

I have a data entry sheet within which my data goes down the columns, D4:d8 for example. But as my data needs to be viewed on charts in date order this leaves me needing sheets in which to organise ...

0
votes

1
answer

31
views

### Columns matching in Excel

I have four columns of data. Column A,B & D,E. A&B columns are one set and D&E columns are another set. Both have account number and amount. Both has same account numbers and amounts but ...

0
votes

1
answer

42
views

### When saving as a PDF document, Excel uses your name as the author for the PDF doc - How to stop it doing this?

I create PDF invoices for my clients from a template I created in Excel. Rather annoyingly, Excel is auto-populating my name in the 'Author' field for the PDF document. The only way to remove it is to ...

0
votes

1
answer

63
views

### Mail Merge messing decimal places

When using an Excel spreadsheet as input to Word Mail Merge feature, the decimal places get all messed up:
8,1 becomes 8,0999999999999996
7,0 becomes just 7
(commas are the decimal separator, and ...

-1
votes

0
answers

19
views

### Excel kpi report restricted

We created employee kpi report in excel with formulas,if i share this on mail then other employees can see another employee details simply entering employee code can we restrict

0
votes

0
answers

29
views

### Want to create a mega pivot table from data from a matrix with 11 items, and 4 possible answers

I am trying to analyse data from a survey. In my survey I asked a 'matrix' question, with 11 items, and users could give one of 4 possible answers for each item.
for example:
carrots - i like it | i ...

0
votes

1
answer

68
views

### Excel - how to handle custom timestamp format

I have some measurement data from a datalogging software, saved as CSV, and one column contains time stamps like this:
12.04.2024 15:11:32:684
12.04.2024 15:11:35:752
The format of this is:
dd.mm....

-1
votes

1
answer

51
views

### Advanced Filtering

My goal here is to filter by a name only. The current filter shows every combination of every name. I would like to simplify this.

0
votes

0
answers

37
views

### Excel transforming dates ddmmyy to yymmdd

Having a date issue. When I enter date in excel as folles today being 20-04-24 , excel transforme it into 2020-04-24 . So it's mistaking the day for the year.

0
votes

1
answer

45
views

### 2 problems, complicated copying of data based on a "Number" and dates

The first problem I have is that I have a timestamp in one cell which includes the date and time and I would like to know if there is any automated way to separate them into 2 different columns (Date ...

0
votes

0
answers

55
views

### Advanced Excel Formula, It's a Doozy

I have a major dilemma i am trying to get to work. Hopefully the hivemind can help me out!
In the example i have my reference key which is test 1 - 5 in columns I - K , in Column I i have a drop down ...

1
vote

1
answer

42
views

### how can i count paid time off entries on multiple calendars?

I have a paid time off tracker. Each employee has their own calendar year on one sheet. The month "boxes" are small. 7 columns, 6 rows. The data inside those cells is just text with each ...

0
votes

0
answers

56
views

### How to average only the values of unique rows in a Pivot Table/Power Pivot

I have a data set that has three columns - a serial number, a category, and a price. Certain serial numbers are listed multiple times in the data set with different categories, but each one always has ...

0
votes

0
answers

18
views

### Excel needing a scrollable multicolumn table able to be resized vertically not reference to other cells but able to be populated manually

I have a worksheet populated vertically as such
Grp = Grouping
ob = observation
att = attribute
ssatt1 = session attribute
Grp# Grp object Ob att1 Ob att2 ssatt1 ssatt2 ssatt3
1 ...

0
votes

1
answer

59
views

### Dynamic Addition of two arrays across cells

I have 2 dynamic 2d arrays of equal length n x y. I want to add every entry of row n of the 1st array to every entry of row n of the 2nd array for every row. It will make a n x n spilled 2d array for ...

0
votes

1
answer

30
views

### Excel Calculation

Column A has a 'date' in or 'Allocation Block' in
Column B has a 'date' in
My formula to see how many days are between both is below
=(@columnB))-(@columnA)
However, how can I ensure if Column A has '...

1
vote

1
answer

43
views

### How to Loop cluster / ranges horizontal to vertical via vba [closed]

Newbie here and would like to get a loop working in Microsoft excel. Basically, to arrange clusters / ranges from horizontal to vertical. I have tried transpose function but have not been successful ...

0
votes

1
answer

27
views

### A formula to select the highest cell in a row that then shows the entire row

I would like to do the following:
Find the highest cell in a column in an excel spreadsheet.
Display that entire row.
I have a spreadsheet that tracks our Walks that shows:
Number of Walks (Column A)
...

0
votes

0
answers

37
views

### How to make a first class function cell in Excel

It is possible in excel to treat a cell akin to a first-class function?
For example, the typical behavior would be to set cell C1's value to =A1+B1 which is an immediate execution function. The ...

0
votes

1
answer

38
views

### Using a matrix constant as input for control elements and validity

Given that you have in Microsoft Excel a matrix constant named Values defined as ={"One","Two","Three"}, how can I use the constant in control elements like listbox or ...

-1
votes

0
answers

59
views

### Need help using index/match/vlookup

enter image description here
I need assistance creating a formula with match statement(s). My current formula isn't reading all my columns and gives me an "N/A" the moment I change "FOB&...

0
votes

0
answers

30
views

### How to refer to the range of values of an Excel pivot table from a formula

I've got a pivot table with FieldR in Rows and FieldC in Columns, both with some values selected and others filtered out. I've got Sum of FieldV in Values, with values shown as % of Column Total.
I ...

0
votes

0
answers

28
views

### Why don't values fit on the page in editing mode but do actually fit when printing?

In editing mode with the view set on "page break preview" some values don't fit on the page.
However, if I go to print, they fit on the page.
How does this work?
It might not look like it, ...

0
votes

1
answer

38
views

### Want to give more options in an IF formula

Current formula is
=IF(AND(RIGHT(A3,2)="00",B3="Vinyl",H3="No",I3="01 - UMGI",G3="Catalogue"),"8M Block required","None")
Instead ...

0
votes

1
answer

42
views

### IF formula using vlookup

I am trying to create an IF() formula using VLOOKUP(), my VLOOKUP() is this
=VLOOKUP(A14119,'CoO Flags Report'!D:L,9,0)
but I want it to state no if the VLOOKUP() finds #N/A

1
vote

3
answers

99
views

### How do I sort an Excel sheet vertically = reverse the order of the full sheet = put the sheet bottom up = turn the worksheet upside down?

Data in an Excel sheet needs to be sorted the other way round. I cannot sort the data by the two columns date and time since there are some lines in it that do not have the same pattern, for example ...

0
votes

0
answers

36
views

### Linking columns on different sheets

I'm very new to VBA coding (only dabbling for this specific project), so I would really appreciate any advice on an issue I'm having. I'm attempting to independently link multiple column ranges on ...

-1
votes

1
answer

35
views

### Hiding "display values", the numbers 45396 are showing where there is no data entered into the cell. How do I hide this?

enter image description here
Image for explanation. I used the =days(end,begin) formula to calculate the number of days that has lapsed since servicing. HOW DO I HIDE THE 45396 number?????? Super ...

0
votes

1
answer

71
views

### What gives Excel/csvs their formatting functionalities?

When I open a csv file by double-clicking it, it opens, and as one would expect, displays the data in a big array of cells with a ribbon of formatting options at the top (Clipboard, Font, Alignment, ...

0
votes

3
answers

539
views

### How do I get the sum of hours:minutes in MS Excel in the status bar and in a formula if the cells come in with a text format?

I know that there are questions around that are much the same, like Sum the number of hours in Excel, which asks you to format [h]:mm, which I do and it still does not work.
Also not so far is How do '...

0
votes

2
answers

60
views

### Pivot table in excel: get difference of two rows in original table as a value

I have a huge table that looks something like this:
Period
Retailer
Area
Section of people
Goods type
Metric 1: Quantity sold
q1
some dude
area1
1
doll
111
q2
some dude
area1
1
doll
100
q1
some ...