Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

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.

0
votes
2answers
10 views

In excel how can I sum all the cells above the current cell upto a particular cell

What formula should I apply to add all the cells above the current cell but only up to a cell with a particular text. Like in case of the below example the formula adds all cells above it but only up ...
-1
votes
0answers
11 views

Create a bar graph in excel expressing total money spent between multiple people [on hold]

I have two columns of data I would like to make a table for. One column has money spent and the second column is the name of the person. The table has duplicate entries for each person with each row ...
0
votes
2answers
8 views

How can I expand Excel datasets that have formulas attached?

I'm trying to work with some relatively simple datasets in Excel, but I realized that I don't know how to expand them properly. See the image below for reference: If I wanted to add a USER E or ...
-1
votes
1answer
26 views

Is excel good for data storage and analysis?

About a year ago I decided to store some personal information in excel file (weight, daily step count, blood pressure, books read, tasks completed, ...). Every row is one day and it's getting ...
0
votes
0answers
10 views

Excel VBA Code Works with F8 but not When Run [on hold]

I've researched this problem and have not found any situation similar to mine. Goal of the Macro is Insert an Embedded Picture into an Embedded Chart. Code does this by: Copying the Picture Adding ...
0
votes
0answers
16 views

Excel to PDF - number turns to symbol

When I save as PDF or print my excel to PDF the 1 in my date changes to a symbol. How do I stop this from happening. Pictures below to show what i'm talking about. I'm using excel 2016 and adobe ...
0
votes
0answers
11 views

Creating Excel Financial model

I have created a model that calculates the monthly cost of a property and would like to return the annual cost in a table below it. What function would you use to return an annual value that could ...
-1
votes
0answers
34 views

Running two VBA procedures in Excel

Can someone tell me how to combine and run both of these in the same Excel worksheet? Please be specific since I am a neophyte at coding!! Thanks This procedure: Private Sub Worksheet_Change(ByVal ...
0
votes
0answers
11 views

Displaying a different value in referenced cell

Have two tables in same worksheet, table 1 has a value of 14 in cell C36 and I made cell T24=C36 in Table 2, the value in T24 displayed is 9... any reason why this would happen? both cells are ...
0
votes
0answers
15 views

How to convert range of image file path from local folder as comment in the selected destination range?

I'm asking for your help. My research ended up in 2 different macros that combined will give a good utility for my work. This VBA code will insert image as comment. This VBA code will fetch ...
0
votes
0answers
18 views

Why does Excel say “there's [an issue] with the clipboard”?

I had to paraphrase the error from Excel because Superuser doesn't allow "problem" in the title, which is a bit amusing in this case. The actual error, as I'm sure anyone who uses Excel is aware, is ...
1
vote
1answer
32 views

How to increase speed of code using data structures rather than for-next loops?

I have already resolved several others using Application.Index with Application.WorksheetFunction.Match and reduced time to perform from about 7-8 seconds to milliseconds. But I feel there is still ...
0
votes
1answer
23 views

Excel - INDEX MATCH MATCH with a twist

I'm trying to assist some local firefighters make a crewing display page on their excel roster. Their roster is setup with dates from 1st January -> 31st December vertically in column A with the ...
-1
votes
0answers
23 views

Has Excel updated their Times New Roman font?

The symbol ∧ (unicode 22c0) does not work with Times New Roman Font in MS Excel for Mac 2013. But it works in MS Word for Mac. The symbol's stats in other encoding formats can be found here: http://...
-1
votes
1answer
27 views

How can I make Excel visually update cells?

I am using Excel 2016. I have a small spreadsheet that is exhibiting some unusual display problems. When I recalculate a range, which includes all cells on the sheet with content or formulas, two ...
-2
votes
0answers
40 views

Need help to write VBA [on hold]

I am new to VBA and don't know how to wright it. I have spreadsheet that needs to be converted to the different format. I used the "IF' formula it gave me the result but it didn't completely did what ...
0
votes
0answers
12 views

When I copy data from Qt-Creator to Excel, the tabs are turned into spaces

I am using Qt-Creator to edit a file which contains lines of tab delineated data, and I have white-space rendering turned on in Qt-Creator, so I can see the tabs. When I copy this data into an excel ...
0
votes
1answer
17 views

Conditional formatting for merged cells

I have these two rules for a set of cells: The full formulas are =$AB27="" and =LOWER($AB27)=ok I thought this would make it so that if "ok" (with any capitalization) was entered into the the ...
0
votes
0answers
15 views

update sheets to master sheet

How to update a Excel spreadsheet from a master that I would be changing data on periodically. I would like to update the Master with newer formulas and data. when I go to a folder and open up the ...
0
votes
2answers
39 views

Combine multiple row into one, keeping columns data

I have the following type of table Current table P.no. P.Line ian feb mar apr mai iun iul aug sept oct nov dec 100001 Line1 100 ...
0
votes
1answer
32 views

Percentage calculation formula

I have two questions and I just can't figure it out. I have trying to calculate 3% into a base rate. $28.54 + 3% = $29.40 The goal really would be to do: $29.40 - 3% = $28.54 However, when I do ...
2
votes
2answers
51 views

Split cell content into multiple separate rows in Excel

Suppose in A1 cell I have some comma separated letters. content(A1 cell) = A, W, L, F I would like to the following result: content(A2 cell) = A content(A3 cell) = W content(A4 cell) = L content(...
-1
votes
0answers
32 views

Formula not Working After Date 12 for every month

I came through a very weird issue. In Image1 You can see I am converting Column B to TEXT in a specific format in Column D. And in Column E I am getting the Time Hour Value. (Ref - Image 1) But my ...
0
votes
1answer
15 views

Excel: Grading Formula to Omit Certain Cells

I have an excel sheet I've made for a class. I have pre-filled in all of the assignments: | A | B | C |------------------------------------------- 1|Assignments |Points ...
-1
votes
0answers
28 views

VBA check existing file timestamp on network

I don't know how or where to start & Excel VBA MsgBox doesn't help me at all. My employer has a shared excel file that multiple people access & use on a network & saving has become an ...
1
vote
0answers
28 views

Microsoft Office Tools- permanently remove author name

I am having some trouble with Microsoft Office tools, I want to permanently remove the author name from all future created documents. Word, Excel, etc, keep pulling my computer login username (Lets ...
0
votes
0answers
15 views

Delete columns based on selection from a list box in Excel

I want to use Excel to delete columns from a worksheet based on the column header values that are seeded into a list box.
0
votes
0answers
35 views

Conditional Formatting Wont Work

I created 4 conditional formatting rules and for some reason, only 3 of them work. For all 4 of them, the rule type is set to "use a formula to determine which cells to format", as I want the whole ...
-1
votes
0answers
22 views

How to display only data in a recap that meets certain criteria in Excel

I have a spreadsheet that contains individual tabs that are checklists for property inspections. Each item in the checklist gets a score of 1 – 4 and has comments. I want to create a “Remediation Plan”...
0
votes
0answers
22 views

How can I get the exact position of bold words in a cell?

I have two cells (let"s say A1 and B1) with same content, but not same formatting (borders, size, background, etc.) I need to have the same bold words in the two cells. But I don't want to change any ...
0
votes
3answers
42 views

Simple Array Formula in Excel not comparing the right values

I'm trying to calculate with an Array Formula (in Cell D2) what i'm calculating in cell D11. The issue i'm having is that it appears my Array Formula is not evaluating the inputted array one-by-one. ...
0
votes
1answer
15 views

Excel euro negative numbers

I have the custom cell with the below formatting _-[$€-x-euro2] * #,##0.00_-;-[$€-x-euro2] * #,##0.00_-;_-[$€-x-euro2] * "-"??_-;_-@_- How to show negative number inside brackets ?
0
votes
1answer
34 views

How to generate a splatter chart in Excel?

I am trying to get a chart for the following. I have different groups -- Fiance, HR , IT, Maintenance -- and for each one, I have on the X axis a pick list of choices to show interest (very low, ...
0
votes
2answers
54 views

Advanced F&R Regex - Sheets / Excel - If “X” is in cell A1 and add “Y” to cell B1

I am looking for a formula or regex that I can use to find a value in a string in one cell and if found add another string to the adjacent cell in another column. For example, I have a list of ...
1
vote
0answers
27 views

Cloud or In-house [on hold]

I am assigned a task to find a way to reduce the computing cost. We are using AWS at the moment. The work we do involves a lot of calculation in excel spreadsheets using VBA modules. The result will ...
1
vote
0answers
26 views

Tortoise svn diff for excel files

I was pleasantly surprised to find that Tortoise svn diff lets me find the diff between two excel files. The cell which is different is highlighted in red. It works for small excel files. But I have ...
1
vote
1answer
46 views

Combining Data From Rows into Columns, Excel 2016

So, In column A, I have a lot of repeating typeId's, with different data in columns C/D. I would like to take any row that has a duplicate typeID, take the data in column C/D and move it to the next ...
1
vote
1answer
23 views

Copy multiple cells from workbook a to workbook b keeping keeping the exact reference to the cell

I am building a catalog I have all data and costing listed in workbook1. Now I need to reference workbook2 the customer catalog, back to workbook1 so all data only needs to be updated in one place. ...
0
votes
1answer
59 views

Excel vlookup not working

I am using a Mac. I have 3 categories of ZIP Codes, Zone 1, Zone 2 and Zone 3. I have a list of ZIP Codes and I need to see easily if a zip code is zone 1, 2 or 3. Column E holds my ZIP Code. ...
1
vote
1answer
17 views

Trouble using getpivotdata with different dimensions, Vertical and Horizontal

I am trying to use getpivotdata, but not sure how to get the formula working properly. I need to have the critera of business date, Name, and then base it on my headers and return the numbered area in ...
0
votes
0answers
28 views

Find duplicates within group in excel

Say I have a spreadsheet with the following: RoadIDs | Order 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 2 1 1 I'd want to ...
0
votes
1answer
23 views

Hiding row if there is data in all cells of a row

I've searched high and low but couldn't find an answer to fit my issue. I was wondering if someone could help me figure out a code for.. If all cells in a row contain data then hide the row; if there ...
-2
votes
0answers
31 views

How to display a value in cents as dollars (without fraction) by using only cell formatting, not formulas

The question is same as this one, but 950 cents should be displayed as 9, while keeping original 950 as cell value. Let's say I have an integer value of 950 (representing 950 cents) in cell A1 in ...
-2
votes
0answers
25 views

Name cells based on adjacent cells [on hold]

I need help with the following: If the cell above is named the same, the cell to the right will be named "Level 1" if not "Level 2". Now if it is "Level 2" all of the cells below with the same name ...
2
votes
0answers
20 views

Excel for Mac conditional formatting not working (at all)

My Conditional Formatting button stopped working (MacBook Air, MacOS Mojave 10.14.2, Excel 2016). This is true for existing files with the formatting done previously, and new files. None of them are ...
-1
votes
1answer
15 views

Excel: New Powerquery from Web (csv) doesnt work

I want to build a worksheet where the user can input a Stock symbol and the balance sheet is automatically downloaded from morningstar to a table, and then some custom formulas are run on the data. ...
1
vote
0answers
20 views

MS Excel Filter Chart Data Labels not updating with filter

I have a large table of data containing my x-axis data, a column of dates, a column of numbers, and a column of data labels. I have setup a pivot chart where the date is the filter and the data all ...
0
votes
1answer
18 views

Add a CountIF to a SumProduct Formula

In a previous question, Scott gave me this great formula to sum all the sales from salespeople who saw an increase in sales from 2017 to 2018: =SUMPRODUCT(C2:C9-B2:B9, --(C2:C9>B2:B9), --(B2:B9>...
0
votes
1answer
51 views

Excel formula matching sheet1 and sheet2 and getting result

Can someone please help on Excel formula: I have a spredsheet With two sheets. In sheet1 I have two column In sheet2 I have tree column. I want two column from sheet1 to match With two column in ...
-1
votes
1answer
21 views

Merging data from multiple files

So in my case I have multiple Linux VM's and each one of them there is a file called output.txt (or other extension like excel?). They look like: Average download time:8647 Average whatever : 153 ...