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.

-2
votes
0answers
16 views

How to call multiple images from folder in excel?

Hi Excel experts & VBA wizards, Is there an easy way to call images from folder in Excel using a formula or VBA? Also, I would like images in R2 to be tied to the campaign names in R1. If the ...
0
votes
1answer
15 views

Ranking two columns with different categories

I am looking at how to rank two columns separately and then take the average of the two ranks. One column is a percentage and one is a just a number. Column A is the name of the org, column B is a ...
0
votes
0answers
21 views

Excel collect rs232 data [closed]

The quality department has asked me to create a backup data collection solution for this measurement probe https://www.lmicorporation.com/595. I just wanted to know if there was any particular (...
1
vote
1answer
54 views

COUNTIFS and SUMPRODUCT are giving different results

Context: I am working on an Excel 2010 spreadsheet, summarizing a lot of data and deriving various results by comparing the contents of several columns. All of the details aren't important; I'll ...
1
vote
1answer
23 views

Avoid having 0 returned by INDEX() displayed

I have a function returning some values from a different table: =IFERROR(INDEX(Table2[Kommentar];[@[Radnr.]]);"") This works great for most cases, but if there's no information entered into the ...
0
votes
2answers
24 views

How to merge Excel worksheets by stacking columns, using an ID column?

I have a Worksheet #1 containing: ID VALUE1 ---------------- ABC 8274 DEF 613 GHI 236 and a Worksheet #2 containing: ID VALUE2 ---------------- ABC 11.13 XYZ ...
0
votes
0answers
20 views

Is it possible to run a vba macro inside a vbs script?

Long story short, I'm a complete newbie when it comes to VBS (our dev left half work done and then dissapeared) so I """"made"""" (got help from SO) a macro that basically organize HR data based on ...
0
votes
1answer
45 views

How do I extract numbers between strings in Excel?

Let's say I have cells of data that look like this: Sample text abc (10) and sample text defg (14) Test 123 abc (14) and more test defg (17) I would like to extract the numbers in parentheses ...
1
vote
1answer
20 views

Excel Chart, Axis Label decimal removal

I have a Y axis that looks like so: How can I Remove the .00 decimals? Make the negative values displayed with a red font?
0
votes
3answers
32 views

How do I force excel to display (potential) expressions as text, instead of attempt to evaluate them?

I've got an excel worksheet that contains (string) cell values like this =-L =-N =-R etc Now, excel sees the "=" character and attempts to evaluate the expression. It cannot, and displays the ...
2
votes
1answer
27 views

How to filter a list and pick randomly one of the resulting records in Excel?

I want to randomly pick a name that matches specific criteria. See for example the image: How can I filter a list, each one with associated data in other columns, using provided criteria, then pick ...
0
votes
0answers
23 views

Force error formulas with reference to a specific sheet

I have a complex workbook with many spreadsheets. One of these spreadsheets is called Raw Data. Many of the formulas on the Raw Data spreadsheet reference cells in a hidden spreadsheet called "2018 ...
2
votes
1answer
10 views

Excel Character Encoding - Cell showing one thing, while text export includes new character

I have an interesting situation in Excel 365. I one column I have phone numbers of my contacts. By looking in a cell it looks like this: +xxx‎31417728 But when I export file as text file TAB ...
0
votes
3answers
39 views

editing cells , excel

wonder if somebody could help, cell B2 has a vlookup formula in it, I want to be able to type "Y" in C2 and the information displayed in B2 to be either colour blocked out or erased, keeping the ...
0
votes
0answers
34 views

Moving selected cell data in excel right or left without using cut + paste or, copy and paste. Move data with arrow keys would be great

Hi I would like to know how to run a VBA or macro (or any other simpler way) to shift the values only of any current selection (varying from one cell in one row to multiple cells and selections across ...
0
votes
1answer
12 views

Update Excel object embedded in Word document when opened

I have an Excel sheet embedded in a Word document, this object was created from Word and no xlsx file exist for it. There is only one cell and it has a random number formula that returns a new number ...
0
votes
1answer
54 views

Excel Chart, X Axis timeline spacing

I have a timeline I want to do on my chart, I have 2 issues, 1) The actual time , ie 1m, 3m, 6m, are not showing up on my x-axis, rather it is 0, 2, 4. How can I put the actual time here? 2) How do ...
0
votes
1answer
31 views

How do I perform VLOOKUP or INDEX MATCH based on three different criteria?

I can't figure out the proper formula to lookup a value based on three different criteria. I want to fill out the summary table with data from the source table. I tried using INDEX, MATCH and ...
-2
votes
0answers
40 views

Excel not working post 1809 W10 update

HNY. Since updating last week to Feature Windows 10 (1809), my Excel (2016 or 2007, tried both) seems to have issues. VBA code that was running fine no longer works (run-time error '1004') and even ...
0
votes
3answers
89 views

Excel formula for cumulative costs in 5 year increments

I had a previous problem that was solved that was similar, but wasn’t a running total: Excel formula for declining number, in 5 year intervals So this number is about budge forecasting. It needs to ...
0
votes
0answers
22 views

Excel Financial Market Data Disclaimer

I have a workbook that contains stock market data. The version of Excel that I use has data types specifically for this, which I'm using. But now, every time I open the workbook, it brings up a banner ...
0
votes
1answer
16 views

How to paste sparse columns so they line up with existing data?

So, I have a spreadsheet with about 5000 rows. Each of these rows has a unique number in column A, followed by some data in column B: | A | B | |-------|------------| | 5142 | Test ...
0
votes
1answer
37 views

Excel: Finding difference between 2 columns when rows are not matched

Column A: 1000 unique names Column B: A number corresponding with each name in A Column C: Same 1000 names as A (different order than A, since values in D have changed) Column D: A number for each ...
0
votes
2answers
35 views

In Excel - how to compare a date to today's date, but ignoring the year portion?

I have a large and constantly evolving list of contact's birthdays. They all include the year, but that is irrelevant to our needs. I would like to have a cell that calculates whether a birthday (day ...
-1
votes
0answers
10 views

personal macro will not hyperlink data in an active workbook

I wrote a macro that will alpha sort names for sheets in both an index on a team overview as well as sort the tabs in the same workbook. the final step is to exclude blank or unused sheets named(zzass)...
-1
votes
1answer
61 views

How to look up the last occurance of one of 4 recurring symbols from a row that includes various other data?

Per the attached image, I am attempting to create a formula that would accomplish the following: Look up the most recent of four recurring characters in a row of other text. Screen shot of the four ...
1
vote
1answer
13 views

Excel - Can't tick boxes in the Select Data Source dialog

I have been trying to record a macro that would select a specific series to display on a graph. Since I can't use my mouse and I do not know VBA, I have been trying to record this using only my ...
0
votes
2answers
31 views

Excel, complication IF/ELSE/MACROS

I am totally stuck on this one, your assistance will be greatly valued! Lets say I have 2 shifts in a power plant, shift 1 = 10pm - 4am and shift 2 = 8am - 4pm. Between 4am and 8am there is no work ...
-2
votes
1answer
24 views

Excel: Remove only true cell content if its in a other cell

Cell A1: House of Cards Cell B1: of Cards Cell C1: EXPECTED RESULT House Cell A2: Looking forward to hear Cell B2: to hear Cell C2: EXPECTED RESULT Looking forward So, C1 should basically be the ...
0
votes
0answers
8 views

Adding a row to PowerQuery table shifts data

I've got a small project that is used for keeping track of attendance. In this project i've used a single table that is referenced by each sheet (Different weeks) in order to sync up the participants ...
0
votes
1answer
33 views

Copy from Excel to Outlook - white cells behind topleft corner of image

I am copying excel content from Excel to the Outlook Email Body, and unlike many other users my problem is not that cell formatting is messed up, but rather that when copying any of the images from ...
1
vote
1answer
23 views

How do I set a data cap in a SUMIF function?

I want to create a single formula that combines the two formulas together: =IF(E1>500,500,E1) and =SUMIF(A1:A10,"Y",E1:E10) Basically, I want to sum items from columns E1 to E10 when the value of ...
-1
votes
1answer
31 views

Excel formula for declining number, in 5 year intervals

I have a starting number that declines 6% each year. I’d like to show intervals of the number, for every 5 years (but it still declines 6% every year, not just every 5 years). I did a simple Excel ...
0
votes
0answers
25 views

EXCEL nested IF alternation

I am using poi to generate a cascade dependent drop-down lists, but Excel has a limit to the nested IF formula, so I was wondering can I change it to CONCATENATE IF. However, after the change the ...
0
votes
1answer
25 views

How do I get a cell to dynamically move and update?

I have a workbook that has multiple sheets. The content that gets entered into a sheet changes monthly. For instance, sometimes I will have 5 entries, and sometimes I will have 400 enteries in a sheet....
0
votes
1answer
32 views

Excel conditional calculation

I have a fixed cell value $50. A1 The next column contains a ratio - typically .2 to 2.0. B1 What I want to calculate in an adjoining cell is a value based upon the ratios. C1 rules: if A1 is less ...
0
votes
1answer
11 views

My chart splits the two lines independently

I am working on a school project and I have a big issue with my Chart. Basically the Two lines which should be closer together between 11000-13000 keep being split apart and the Red one appears in the ...
-2
votes
1answer
26 views

what is the fomula for this in ms excel

I want to know the formula if I need to subtract e100 from i100 if d100 and h100 are greater than 0.I have not tried out anything regarding this.I want to know what would be the formula in ms excel ...
0
votes
0answers
55 views

How do I select values at 1 minute interval from data at 1 second interval in Excel

I have a set of data recorded at a 1 second interval as below: How can I select values at a 1 minute interval? For example,only copying the data that recorded at xx:xx:00, which would be at a one ...
0
votes
1answer
331 views

How do I get websites and software applications to open up into a window?

Occasionally I work on a desktop computer that uses a Samsung screen. The screen can switch between analog and digital mode. I've only ever worked from the digital screen. Recently, though, I ...
0
votes
1answer
22 views

Formula in Excel or Numbers to generate a series of numbers

In my spreadsheet I have two numbers, start_number and nr_iterations. I'm looking for an formula that returns a series of numbers starting with start_number - 1 and nr_iterations long (each following ...
0
votes
1answer
26 views

Select user id for every date in excel

I want to select user id for every date in excel. Tried doing this =IF(A2=A1,(IF(B2>=B1,E1+1,0))) but not getting the exact expected result Input user_id date 10003 12/19/18 10003 12/19/18 ...
0
votes
2answers
29 views

return a list of values that meet criteria in Excel

I'm trying to generate a list sorted by categories in my budget. For example, I want the column J to have a list of amount I have spent on Groceries generated from the table on the left. Is there a ...
0
votes
0answers
13 views

When opening files from Excel though OneDrive, a separate dialog box opens and freezes Excel

A person in my company uses OneDrive to store her files. When opening an Office file like Excel, it will open a transparent dialog box and that cannot be closed and the Excel file cannot by modified ...
-1
votes
0answers
30 views

How do you find if value in Excel is unique to one column?

I have 6 columns, A to F, and each contains a list of names. I would like to compile a list of unique names in, for example, column A. How is that possible to do in Excel? I have searched but only ...
0
votes
1answer
16 views

In Excel how do I extract the address referenced in another cell's equation?

In Excel I have a grid of stock data, where the rows are call prices and the columns are put prices. For each cell in the grid I can generate a graph of results for that particular call/put ...
0
votes
0answers
30 views

Excel: Ignore the last value in series 1 if COUNT(series1) > COUNT(series2)

I am currently using excel to do some trading. In one series I have a column of "buy prices" and the column next to it is "sell prices". I want to divide all of my sell prices by all of my buy ...
-1
votes
1answer
17 views

Setting up conditional formula

I have a spreadsheet with conditional formatting set in columns M & N. These columns are set IF column K is over 250, then it divides column K in 1/2. Also, in column M it will add column I in ...
-2
votes
0answers
36 views

Excel dates = how much does a contract fall into each charging period

A business contract has a different charge during a period 31/03/xxxx-01/04/xxxx Cell H2 has the contract start date and cell I2 has the end date If the charge changes on 1/04, I want to find out ...
0
votes
2answers
24 views

Excel: Automatically detect if value is lower or higher

I want to have an excel sheet for staff with the following info Name | Week 1 | Week 2 | Week 3 | Week 4 | Drop? Info will be like Mike | 100 | 80 | 90 | 100 | 90 | Yes I want the last cell to ...