# 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

**0**answers

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

**1**answer

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

**0**answers

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

**1**answer

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

**1**answer

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

**2**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**3**answers

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

**1**answer

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

**0**answers

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

**1**answer

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:
+xxx31417728
But when I export file as text file TAB ...

**0**

votes

**3**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**3**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**2**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**2**answers

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

**1**answer

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**2**answers

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

**0**answers

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

**0**answers

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

**1**answer

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

**0**answers

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

**1**answer

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

**0**answers

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

**2**answers

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