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
0answers
5 views

Excel not selecting font as expected

I am using a non-system font with excel, the problem is whenever I go to the font box and open it with a non-system font formatted cell or range Excel opens the list with another font selected by ...
0
votes
0answers
10 views

Automatically reference to a cell on other sheets

I have a libre calc file with many sheets and I want the first sheet to contain a list with the other sheets names and next to each one the contents of a specific shell of every one of those sheets. e....
0
votes
1answer
24 views

what went wrong in my Excel if else formula?

I have written a IF formula with Vlookup. Vookup is working perfectly fine. But the else part is not working. The idea is simple A3 content of the current sheet is = that in first sheet...then ...
0
votes
0answers
24 views

#REF error using VLookup and Offset

So I'm running into an issue where I want to pull a few formulas automatically based on what my material type is (I column) and then I'm using a custom module/macro to evaluate my strings as a formula,...
1
vote
0answers
16 views

VBA vs PowerAutomate protecting sheets

I had an excel files with 3 sheets Password protected in order to prevent data insertion in the cells out of the range I needed. I wrote a VBA script to let the user have a button to add a line to a ...
2
votes
0answers
20 views

Power Queries in Excel just default to “anonymous” and doesn't ask for login info

I have created multiple Excel sheets for my coworkers, many of which involve power query connections to our corporate SharePoint site. When I set it up, I logged into my SharePoint account to ...
1
vote
0answers
28 views

Find Replace from excel to word template macro

I want to use excel to find (ColA) data and replace it with (ColB) Data in to a premade word template I have the macro that already opens up the word template with what i want to find/replace I am ...
2
votes
2answers
708 views

In Excel, how can I round or display numbers to 2 significant figures (the two leading non-zero digits of a decimal number)?

In Excel 2016 I need to show zeros out to the leading non-zero digits and then just the two digits after that. For example: 0.00002423 should read 0.000024, 0.242 should read 0.24, 0.0032255 ...
0
votes
2answers
50 views

Excel Formula for counting cells other than specific values

Trying to count number of fruits I have in column G, I have: =COUNTIF(G:G,"Oranges") and =COUNTIF(G:G,"Mangoes") How do I create a formula to calculate the rest? I mean all other ...
1
vote
1answer
29 views

Searching a cell for a particular string, outputting a different string in a different cell

I'm looking to search for a string in a cell, and then output a different string of text into another cell. Example: Cell A1 contains the string "370904RV". I'd like to search for "37&...
0
votes
1answer
40 views

Microsoft Excel — Images distorted when printing

Images get distorted; circles print as ovals I have an Excel document which has several images (vector art, EMF images). When printing, the images are distorted: circles become ovals, which looks ...
0
votes
3answers
54 views

Excel - create a lookup with multiple values and return Y/N/Underdetermined

I am trying to lookup data in a table that has multiple instances of the lookup value and want to return a value from another column that is then turned into the value of that 2nd column or 'unknown' ...
0
votes
1answer
35 views

How do I Preserve the format for a date field as mm/dd/yyyy in Pivot Table

I am in need of my pivot table to preserve the date filed as mm/dd/yyyy. I have selected the field and attempted to set the custom value, I have unchecked the Autofit Column and made sure the ...
-1
votes
0answers
25 views

Assist me with a small vb code script for an Excel button to open links

So this is what I want to do: I am trying to get a button to somehow open a specifiable quantity of hyperlinks. The hyperlinks are put into a column, say D4:D100. Obviously I don't want to do 96 at a ...
0
votes
0answers
22 views

Excel 365 - Dealing with changing data locations

There's a table in worksheet A that I need to reference in worksheet B. My problem is, my manager needs the table to always be alphabetized, and new entries are constantly being added. How do I set it ...
0
votes
0answers
35 views

Importing data from .csv to Excel by adding columns to an existing table

I have a seemingly complicated task for importing data to a worksheet and I'm new to macros and VBA in Excel - hopefully someone can help me out! I have an Excel spreadsheet containing a table. ...
0
votes
1answer
30 views

SUMIFS spilled range between certain dates

I'm building an inventory history that will grow throughout the year and include new products. I don't want my formula to look past the date the product went live. For example: Product was launched ...
0
votes
0answers
30 views

Excel - Error bars not appearing

I have a combined stacked column chart with a line chart with 6 series, like the one on Figure 9 of this paper (https://www.mdpi.com/1999-4923/12/12/1132/htm). I was able to add the corresponding ...
0
votes
2answers
33 views

How to put expandable image into Excel cell

I want to "store" an image inside a small Excel cell, where I can double click that cell and the image will become temporarily viewable for further analysis. One way to do that would be to ...
0
votes
0answers
16 views

Importing Fair Value from simplywall.st via importXML to Google Sheets

I'm trying to import the fair value from https://simplywall.st/stocks/us/tech/nasdaq-aapl/apple via the importXML function in Google Sheets using the XPATH for the FV. The formula: =importXML("...
0
votes
0answers
9 views

Excel online workbook cache local file which is password protected - content.mso

We are going through the process of moving our files to sharepoint, a few of our workbooks are linked to other workbooks which are all password protected. When I open Workbook 1 which is linked to ...
1
vote
1answer
24 views

How can I export chart from excel into Latex with high quality(Overleaf)?

Title says it all, we have data in Excel and we have found Kutools to create pdf files from tables , but it is not working for charts. We have tried export graphs into png, pdf and it has low quality ...
2
votes
0answers
31 views

Excel rows of data suddenly disappeared after undoing deletion of unrelated rows. Version history suddenly blank. Get my data back?

I have been editing an Excel workbook for 6 days. The workbook is saved in sharepoint and also marked to always be kept on my laptop. I have saved this .xlsx file dozens of times in the last few days. ...
0
votes
1answer
201 views

Creating excel charts with two y axis - 8 independent series (?)

Does anyone know how I can possibly create a graph exactly like this one in excel? It's Figure 9 on this paper (https://www.mdpi.com/1999-4923/12/12/1132/htm) I am totally lost. I've tried and lost ...
0
votes
2answers
22 views

Conditinal Formatting to highlight the first 5 similar cells with a specific text (not the TOP 5)

Column A of my spreadsheet has the following data with only values of A, B, C, D and E (shown below). There are more columns that I like to sort with, and would like the first column to highlight the ...
-2
votes
2answers
79 views

Is there an excel formula that determines whether a number is “stacking” or not?

I need help with developing an Excel formula that determines whether or not a 4-digit number has "stacking" digits (digits that are higher than the last e.g. 1234, 2356, 5679) without any ...
0
votes
1answer
23 views

random 2 vowels using Excel using the LET function

I'd like to generate a 2-character string with random vowel (e.g, ie, oo, au) using the LET function. I tried the following formula with does not work. =LET(a,{"a","e","i"...
0
votes
2answers
24 views

Filter out rows with 0 from many columns

I would like to filter out 0's from rows across many columns. However some of these rows may zero out. other times it works fine. This solution is not working for me: Filter only rows with 0 value in ...
0
votes
1answer
34 views

How can I delete a column in sheet 2 based on sheet 1?

I have two different sheets: "Input"(sheet2) and "Instruction"(Sheet1) I want to delete the whole column in "Input" sheet corresponding to the value in the cell(row 34, ...
-1
votes
0answers
29 views

How can I expand timestamp into rows and columns?

I have a spreadsheet that looks like that I need to make each day a column and each row a minute of the day ranging from 00:00 to 23:59 This is a sample of the I extracted time and date and made a ...
0
votes
2answers
46 views

If VLookup Function that add corresponding cells if 1 range matches another

If B4 matches a # in column A I need the formula to return the # in column C and then add... For example: Since B4 matches A1, I need C1 (90) +E1 (3) + F4 (0) and return the value in C4. I tried this, ...
0
votes
0answers
22 views

Format Result of VBA code respective to row

I have below sheet I am using below code to get reports in different sheet for Blank cells which Sub Loop_Column_Row() Dim lRow, lCol As Long 'Counter Dim i As Integer 'Find the ...
0
votes
0answers
19 views

Excel validation of cell as per other sheet

How can i validate excel cell from other sheet below is my sheet example want to validate Sheet 1 from Sheet2 as reference. I have done validation with same rows using FIND , Search function from ...
0
votes
0answers
15 views

Why the Excel Analysis Toolpak is NOT loading once I click it?

I use Microsoft Office Professional Plus 2013 in windows 8.1. Recently, I noticed that if I click on the Data Analysis Toolpak in Excel 2013, it doesn't LOAD the dialog box with the list of standard ...
2
votes
2answers
58 views

Creating Bar Chart with Start time and End time

I want to create a bar chart from the following data which will look like the attached picture. The data will have a start time, end time, and a number value. Sample Data: Bar Graph: Basically, I ...
0
votes
0answers
18 views

Is it possible to specify a range in an Excel data connection string?

I have a connection in my excel sheet to an access database which specifies the data to retrieve based on an SQL query. I'd like to modify the SQL so that the WHERE clause is limited to a range on an ...
0
votes
0answers
30 views

What can I do to create simple programs which will manage simple text databases? [closed]

I am taking in a large list of names. I need to make some operations on them. Such as: Entering and searching for them in a google search. Potentially pull information from websites, if that data is ...
0
votes
1answer
20 views

VBA code to generate report of blank cell in different sheet

Hi how i can modify below code so all blank cells value are generated as report in different sheet , taken this code from my different post which i posted earlier ! but found it will end if it find ...
-3
votes
1answer
36 views

SUMIFs function plus returning specific cell and adding

If B4 matches a # in column A I need the formula to return the # in column C and then add... For example: Since B4 matches A1, I need C1 (90) +E1 (3) + F4 (0) and return the value in C4.
0
votes
1answer
27 views

Substraction from multiple rows in the right order

I need some help creating a spreadsheet to take money and pay back money to different credit lines. I have a spreadsheet with 3 credit lines (each with different amounts of money I can borrow). Now I ...
2
votes
1answer
35 views

Excel N x M array of text data from Sheet1 to a list /single column into Sheet3

So I have an Excel with data in range Sheet1!B1:Z2000 and it contains about 1500 ID'd in that range in random places. ID in this case is text data (example of data "334_2_975"), length can ...
0
votes
1answer
27 views

EXCEL VBA Loop through cells and conditionally concatenate

I have two sheets. The first sheet contains this table: id seller state reason 1 bla1 approved not supported 2 bla2 rejected rejected by seller 2 bla3 rejected rejected by seller 3 bla3 failed ...
0
votes
0answers
32 views

Excel 2016: How to find a specific name in sheet “A” and and get the adjoining cell's value to a cell in sheet “B”?

Excel 2016: How to find a specific name in sheet "ASPI" and and get the adjoining cell's value to a cell in sheet "Watchlist"? I have currently used the method of this formula to ...
0
votes
1answer
19 views

Validate Excel cell format

i want validate my cell on basis in below values For ex : 12345678 Test Test Tets so beginning of cell always with 8 numeric digits Test Test Tets (12345678) end of cell always with 8 numeric digits ...
2
votes
1answer
38 views

Comparing several years in excel line chart/diagramm

I want to compare several data values of several years over the course of a year. Something like this. For that, I changed all the data to be within the same year and I can put them in a graph ...
0
votes
0answers
16 views

Macro validation and conditional check

i have below excel where i want to do data validation for ColumnName1 ColumnName2 ColumnName3 & ColumnName4 and as well check the condition if ColumnName6 = ColumnName7 && ColumnName5 = ...
0
votes
2answers
32 views

Selecting a row until the border

When I highlight a specific line by selecting the row number, I want the selection to stop at the border and not continue across the sheet.
0
votes
2answers
39 views

Excel Lookup formula based on 2 dependent lists or variables

So im trying to create a table that uses two dependent lists, which i have done, however I need a third cell to show a string of text that is specific to the first two selections in my list. Example. ...
1
vote
2answers
44 views

How to create multiple columns from a single one, combining rows with a common cell?

My data looks like this: USERNAME ENTRY_TYPE ENTRY_CHOICE user_a ice_cream lemon user_b ice_cream strawberry user_b ice_cream blueberry user_c ice_cream chocolate user_c ...
1
vote
1answer
40 views

Excel not printing 96 x 96 pixel square as 1“ x 1”

I am under the impression that 96 pixels = 1", and that is absolute. When I create a cell in Excel that is 96 x 96 pixels, it prints as something smaller than that. I have tried it on 2 different ...

1
2 3 4 5
444