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
1answer
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
0answers
18 views

Excel - Rank top 3 students

This is the image regarding my issue. Thanks.
0
votes
0answers
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
2answers
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
1answer
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
1answer
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
1answer
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
2answers
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
0answers
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
0answers
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
0answers
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
1answer
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
1answer
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
1answer
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
0answers
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
1answer
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
1answer
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
1answer
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
2answers
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
1answer
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
1answer
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
0answers
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
0answers
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
0answers
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
1answer
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
0answers
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
1answer
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
2answers
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
1answer
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
0answers
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
1answer
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
0answers
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
1answer
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
3answers
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
0answers
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
1answer
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
3answers
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
1answer
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 ...

1
2 3 4 5
420