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

20,997
questions

**0**

votes

**1**answer

7 views

### AHK ComObjCreate(“Excel.Application”) invalid class string

I am trying to run Excel via AutoHotKey as every single tutorial suggests by using the COM object through this command ComObjCreate("Excel.Application"). However, it does not get past this command as ...

**0**

votes

**0**answers

18 views

**0**

votes

**0**answers

5 views

### Listing and formatting tagged data in Google Sheets / Excel [migrated]

I'm creating a list of texts with some tags associated to them in Google Sheets, each text has a "tags" column where the tags are separated by commas.
I want to have a second sheet where the ...

**0**

votes

**1**answer

13 views

### Pivot Table : How to group by month if the dates are column headers?

Exist table:
5/4/2020 5/11/2020 5/18/2020 5/25/2020 6/1/2020
Jim 2 5 6 7 6
Jane 3 2 4 3 3
...

**0**

votes

**1**answer

21 views

### Column and Row Alignment In Excel

I'm given a question in which I am required to randomly generate a multiple between 10 and 100 inclusive in Cell A, an integer between 1 and 3 inclusive in Cell B. In Cells C and D, I must:
If Cells B ...

**0**

votes

**1**answer

18 views

### Sum column if its greater than or equal to a value in a corresponding column times a constant

I want to sum the R column if the values in the I column are greater than the value in the corresponding R column times a constant.
Simply stated, the condition on each row is this:
Add R to the the ...

**0**

votes

**1**answer

16 views

### How to batch-convert MS Excel files page size from letter page size to legal page size using VBA

I have 200 Excel files in one folder, with file extensions .xls, .xlsx, and .xlsm.
They were all typed in letter page size and I need to convert all of them to legal page size (landscape orientation). ...

**0**

votes

**1**answer

12 views

### Excel INDEX Match and TEXTJOIN Function

I am trying to combine INDEX-MATCH and TEXT join function
I have a company- ABC Ltd against which I have a job number as 15-SER-7170. I maintain a tab for the order details (called SERVICE ORDER LOG)....

**1**

vote

**1**answer

13 views

### Excel VBA - Post with empty cell values

I have a Macro that takes text entered into a textbox and posts it to the next empty row. This simulates a running list. The problem is that if the textbox is left blank, the next time the user clicks ...

**0**

votes

**2**answers

20 views

### How to Indicate Overflowing Text Cell in Excel

In Excel, if I have a Date cell which doesn't fit in a column, Excel with display the value as # until I resize the column properly.
But with Text cells there is nothing to show the overflowing ...

**0**

votes

**1**answer

17 views

### Expanding query table rows based on another table

I have a list/table in sharepoint that I am trying to create a project ghantt for, imported to excel with query. I was planning on using the stacked bar chart in excel to do this. The issue im having ...

**0**

votes

**1**answer

8 views

### Changes to sharedStrings.xml in xlsx archive does not change Excel contents

The Excel file format .xlsx is on fact an archive that can be inspected, and have the contents edited, if renamed to .zip.
However, changes to the sharedStrings.xml file in the .xlsx archive does not ...

**0**

votes

**1**answer

33 views

### Optimizing item position using in a warehouse excel formula

I currently am in need of an excel formula or way to do this simple optimization to sort items by popularity.
Context:
The image is a top-down view of course, each square is a product we sell, and ...

**2**

votes

**2**answers

38 views

### Random generation of multiples of 10 between 10 and 100 in Excel

Apologies if this is a somewhat rudimentary question.
I have attempted to generate random multiples of 10 between 10 and 100 in Excel via the following function:
CHOOSE(RANDBETWEEN(10,100),10,20,30,40,...

**0**

votes

**0**answers

9 views

### Replace formatted text in XLSX files using e.g. VS Code [closed]

I want to reformat text in Excel cells that are beyond the capabilities available in Excel's native Replace dialog. Technically, XLSX files are ZIP archives, so I can perform modifications to files in ...

**0**

votes

**0**answers

18 views

### Split data into tabs based on column

I found this code online where you can split data into different files based on column. Is there a way to use this wherein instead of creating new files, it will create new tabs within the worksheet? ...

**0**

votes

**0**answers

23 views

### How to split data into tabs based on column?

I tried using the following code I found online. It mostly works fine. However, when the data in the column has an invalid character or length for a Sheet Name (e.g. Accounts payable and accrued ...

**0**

votes

**1**answer

36 views

### Excel - Use index to find multiple of the same value and return multiple values from another column

I have two works sheets one which will hold the cook book instructions
Then another where the user will type in the function name and all the steps from the sheet 2 will appear.
What I want to ...

**0**

votes

**1**answer

24 views

### How to auto update formula when a new column is added

I have a body of data, and on another sheet I have calculations for the minimum and maximums of entire rows.
The data starts in D4 and each row is another data set. The problem is when I add a new ...

**0**

votes

**1**answer

44 views

### How to move down 1 row after scanning bar code

I am not a professional in the use of Excel and need some help.
The cursor moves down 1 row after scanning barcode & hit the enter key.
How does it move 1 row down without hitting the enter key? ...

**0**

votes

**0**answers

17 views

### MS Access Linked Excel File āExternal table is not in the expected format.ā

I have a intermittent problem with Access not being able to read simple linked excel files. I've been using the same processes for years without issue. Now, when calling an Access Macro from an Excel ...

**1**

vote

**1**answer

32 views

### Excel: Help Formatting Columns from Another Sheet

I am trying to reformat an existing excel sheet in a new sheet.
The workbook has 2 sheets. Sheet 1 is called Responses and sheet 2 is called Question.
The format of the Responses sheet is:
|-------...

**0**

votes

**1**answer

49 views

### How to filter features in a tables

I have an Excel table for products by suppliers with which features each product has as shown in the image;
I wanted to create a Slicer from the table to act as a filter to so one slicer with Feature ...

**0**

votes

**1**answer

21 views

### How can I automatically correct the UNC file path of linked workbooks when one of the workbooks changes paths, in Excel?

I have two workbooks, Source.xlxs and Linked.xlsx. In Source I have a tab that has linked cells, in the form of array formulas, to cells in a tab, TabName, in Linked. The formula in Source looks ...

**0**

votes

**2**answers

56 views

### How to return column header if a cell contain certain value based on their nth occurrence

I have a table with delivery dates and number of package delivered to a person on a given date. Each person received package with different number of times.
I want to have another table to show when ...

**0**

votes

**1**answer

34 views

### EXCEL: SUMIF() as true statement to IF()

I have a 2 sheet workbook. One showing a basic readout of summed data and a second with dummy exported data from sending emails to people. I need to check IF datestamp cell is equal to today, Sum the ...

**0**

votes

**1**answer

25 views

### Error Handling in VBA

I am creating 2 arrays in VBA based on the values present in Column number 16. However some of the values in the column are error values (#N/A). I want to check the value of the column against some ...

**0**

votes

**0**answers

19 views

### Sorting polytonic Greek list by initial letter case in Excel

I'd like to extract all the capitalised words from a list of polytonic Greek words. For example, out of...
į¼ĪøĪ·Ī½Ī±įæĪæĪ¹
Ī±į¼±
į¼Ī»Ī»Ī±
I'd like just į¼ĪøĪ·Ī½Ī±įæĪæĪ¹ as it begins with a capital. I've done this before ...

**0**

votes

**1**answer

32 views

### Excel: Split strings into duplicate rows

The attached screenshot explains best what I need.
What I have now are rows of customers and each customer might have multiple email addresses in one cell. I need to duplicate the customer rows for ...

**0**

votes

**1**answer

16 views

### Area Chart Not Aligned

I am having a problem where my area chart doesn't seem to align with the values in the middle of the chart, only at the end. How can I make it a straight line as the one close to 1 Jun? I already ...

**0**

votes

**1**answer

20 views

### Creating an image from excel spreadsheet data

I have a spreadsheet representing 2D measurement data. Think of each cell's numeric value as a pixel intensity at (x,y) where x is the cell's column and y is the row. I would like to visualize the ...

**0**

votes

**1**answer

53 views

### How to calculate the minimum value over the last 5 years of some data

I am using this data which is a data on US oil stocks each week.
So column A is the date, and column B is the value
I would like to add two new columns C and D that are :
The minmum value at a given ...

**0**

votes

**1**answer

24 views

### Excel IF with DATEDIF, when Date is blank

Assistance with this formula. If the date cell is blank, leave blank, otherwise if the date is less than today, give the difference in months:
=IF(F5="","",(F5<TODAY(),DATEDIF(F5,TODAY(),"M")))

**0**

votes

**1**answer

23 views

### Populate a list based on value in cell

So i have a list of employee names and locations. I have a cell with a location name and want to populate a drop down list with all the employees from that location.
Now I've tried various vlookups ...

**1**

vote

**0**answers

27 views

### Can't connect to the server at this time. Your table cannot be published in Excel Sheet

I have an Excel Sheet. As per my requirement, I have to import this Excel sheet into SharePoint Online List.
When I tried to import that Excel Sheet into SharePoint Online List, It is showing an ...

**1**

vote

**0**answers

15 views

### in microsoft excel how to define a default language for columns

Hi I'm working on a dictionary and need to have English words in one column and Persian translation in another. but it takes time changing language every time I want to type the English and Persian ...

**0**

votes

**1**answer

10 views

### Adjust gridlines in excel PivotChart

I have the following data:
Now I create a Pivot Chart which looks like this:
I add vertical gridlines. However, my problem is that the gridlines are not exactly on the year centered, but the actual ...

**0**

votes

**0**answers

25 views

### SUMIF with CONCATENATE in Excel

Previously, I had this formula, where F column is MeterID, F3 MeterID to find, and D column is Value.
=SUMIF($F$2:$F$337,$F3,D$2:D$337)/1000
It works great, but now I have to inclue a new column ...

**0**

votes

**1**answer

34 views

### Assign a name to a cell based on 4 possibilities in another sheet

I'm quite new to conditional formatting in excel. I'm looking for a way to fill a cell based on multiple choices. Here is an example:
I have a list of provinces, and next to each province, I have a "...

**0**

votes

**2**answers

50 views

### How to use XLOOKUP with an dynamic row count?

At the result cell C2
=XLOOKUP(B2:B10, {"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"}, {1,2,3,4,5,6,7,8,9,10,11,12})
The first column A is all text.
I want to convert to ...

**0**

votes

**1**answer

86 views

### How to return sum from different column in Excel

I have a table with the number of goods delivered to a particular person on different dates.
How can I make a (pivot) table to sum the total number of goods delivered on a given date?

**0**

votes

**0**answers

31 views

### How to replace formulas into values but with possibilty to remain referenced to its original source (dynamically)

I would like to have the possibility to convert some formula (in my case CONCAT) into values, but with the possibility to select those values and not to have formula shown, and also to be able to ...

**0**

votes

**1**answer

19 views

### Excel Macro building: How do I pull .csv and .xlsx files from my downloads

I am working on a tool to help my business order products. Right now, We have a tool that pulls all of the .csv files from our downloads folder and add them to one excel work book.
I am trying to ...

**0**

votes

**0**answers

19 views

### How can Ī¼ be typographically represented through =UPPER() while still making sense, e.g., human readable & distinguishable? [closed]

Of course, I can always just encapsulate it in LOWER(), but I'm wondering if there's any convention or standard regarding this?

**0**

votes

**1**answer

11 views

### Auto Populate from one cell to another worksheet

I have an amortization spreadsheet that calculates percentage remaining. I want to click on a cell (A1) under the percentage column and auto populate on another worksheet "dashboard" (B1). The next ...

**1**

vote

**3**answers

43 views

### IFS function in excel not able to work

I am not sure what is the problem, either is syntax error, or data error.
The data in 1st column F is all text. Some are in millions (with the word 'M' at the end) and some in thousands ((with the ...

**-1**

votes

**0**answers

13 views

### Excel: Won't display data from graph [closed]

I'm currently working on a Mac, on the Google Chrome Browser for Excel, yet when I attempt to display the chart data, it will not work. This is really aggravating me, as I have tried multiple times to ...

**0**

votes

**1**answer

33 views

### Detect cell format change

How can I detect a change in the fill colour of a cell in a column in a table, I have tried using OnChange like;
Worksheet_Change(ByVal Target As Range)
......
If Not Intersect(Target, Me.ListObjects(...

**0**

votes

**3**answers

32 views

### Use Macro to Split Data into 2 Columns

Use Macro to Split Data into 2 Columns.
Using Excel 2013 on a Windows 10 laptop. Have used Macros in Word, but new to using them in Excel.
The goal is to take everything beyond the first word in a ...

**2**

votes

**1**answer

28 views

### VBA to hide certain rows based on cell value

I have some information in rows 9 to 38. I need to hide these rows based on a cell value, for example A8:
If A8=3 then only show rows 9 to 11 out of 38
if A8=9 then only show rows 9 to 18 out of 38
...