# 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

**1**answer

22 views

### Two columns from one

I have a column in word which has two parts (one Persian and one English). I need to put tab space between the two languages (there is a single space between them). to clarify:
اجرای وصیت put in ...

**0**

votes

**1**answer

18 views

### data is not copied in the same row (Multiple workbook to mastersheet)

i have a code to copy from multiple workbooks to one masterfile. but the problem here is that, there are possibilities that the datafile will contain an empty row. So everytime a new data is added, ...

**-2**

votes

**1**answer

18 views

### Excel formula: Amount + 1 x 1.5 =

We would like to set up a 1 step calculation to work out pricing automatically
i.e - 9 + 1 x 1.5 = 15
The first number (9) changes with each item
Thank you

**-2**

votes

**1**answer

21 views

### IF functions and results

I am looking to create a formula for 2 columns. The formula will check if the first column has a value greater than 1 and if the answer is yes it will then execute A1-B1 and show the answer. If the ...

**0**

votes

**1**answer

26 views

### Excel: Compare 2 columns and pull missing data into 3rd column

Here is the situation:
Column A: Some employees (Partial List)
Column E: All employees (Complete List)
I need Column C to be populated with all other employees not in Column A (Column A compared to ...

**0**

votes

**1**answer

25 views

### EXCEL - generate a square wave from timing data

How would I generate a digital square wave from the following data? I have absolute time and the high/low level at a given time. I know that each set needs two data points for every X transition to ...

**0**

votes

**2**answers

18 views

### Excel cell character limit

Is the cell character limit (32,767) in Excel hard coded or can it be modified to allow more than 32,767 characters? I have not found any source which suggests it can be modified, but I have found ...

**0**

votes

**1**answer

30 views

### Excel date formatted contrary to preference

In my Excel spreadsheet (a mix of text and numbers) under Windows 10 (Build 1809), the date keeps changing format.
When I input a certain date as 03/09/2018 (3rd Sept 2018), it changes to 09/03/2018; ...

**0**

votes

**0**answers

51 views

### Notepad ++ or MS Excel find/replace sequence range of numbers 1-10 [on hold]

Have looked for a long time for a way todo this but not come up with working solution.
I am trying to alter the contents of an excel file that has cells with a sequence range on numbers, i.e 1-10, 50-...

**0**

votes

**0**answers

25 views

### Format a cell to fit the contents within it (excel)

I am attempting to format a cell within Microsoft Excel with an image in the cell, but when formatting the cell to fit the contents, it will not properly fit. I have a spreadsheet that instructs user ...

**0**

votes

**1**answer

33 views

### How to create two-dimensional column chart in Microsoft Excel for Office 365

I would like to create a two-dimensional column chart in Excel. On the x-axis I would like to plot % of Net Sales, and on the y-axis I would like to plot Gross Margin %. Here's an example:
You can ...

**0**

votes

**1**answer

25 views

### Formula to ignore or treat as empty a cell that contains another formula with no result?

I'm using Excel 2007
I have a Cell B14 which contains a formula getting data from a different worksheet and sometimes this formula may have no result.
I need a formula to ignore Cell B14 or treat it ...

**0**

votes

**0**answers

7 views

### Getting a multi-property item to display once in a pivot table per instance

So I'm trying to run a frequency analysis - how often does an item show up?
Items can show up in a few ways:
Type Make Color Count
1 A Blue 5
1 B Blue 3
2 ...

**0**

votes

**0**answers

20 views

### Task scheduler to run scripts

I Currently have a task scheduled to run a powershell script which in turn runs an Excel macro which processes some numbers and emails out a report. Until recently, it worked perfectly fine.
I'm ...

**22**

votes

**7**answers

7k views

### In Excel, when I enter 22222.09482 then I see 22222.0948199999 number in the formula bar

Could you please help - as I have a weird situation that when I enter a number 22222.09482 in cell then I see a different number 22222.0948199999 in the formula bar. Below is the snapshot of the ...

**0**

votes

**1**answer

12 views

### Excel date format with abbreviated month without the dot

Hi,
I am using this formula for custom date format in Excel:
[$-es-ES]d-mmm-yyyy
and this is what I get:
4-oct.-2018
almost fine but I dont need that dot there, how can I lose it?
Thank you.

**0**

votes

**1**answer

21 views

### Is there a way to access the built-in excel form via a shortcut?

Is there a way to access the built-in excel form via a shortcut? Macros/VBA and addins are disabled. Users are running either Excel 2013 or Excel 2016.
Search has yielded only custom toolbar ...

**0**

votes

**1**answer

15 views

### Combining table into a row

I would really appreciate some help with the following query. I need the following table to be listed as one entire row:
10/12/2018 08:00 18:30 08:00 18:30
11/12/2018 08:00 18:30 08:00 ...

**0**

votes

**2**answers

22 views

### Index Match Match return #REF when dragged down

I am trying to fill a table using Index Match Match, which returns me the correct values for the top row, however i get a #Ref! error when I try to drag down the formula vertically.
I am using this ...

**0**

votes

**1**answer

32 views

### Sumproduct formula with alternative conditions from a table

that's my first question, I hope to be clear enough. Let me know if need clarifications.
I have a SUMPRODUCT formula where I need to use multiple alternative values in one condition (OR like). I have ...

**0**

votes

**1**answer

38 views

### Convert data {“a”=“1”,“b”=“2”,“c”=“3”} to sheet

I have a column of data with each cell containing {"a"="a1","b"="b1","c"="c1"}, including the curly braces and where "a", "b", "c" are the same in each cell. Is it possible to create a sheet with ...

**-1**

votes

**2**answers

39 views

### VLOOKUP for a range of letters

I need to take a range of letters for example:
if the cell contains A, B, C, or D and fill a cell with P1.
If the cell contains E, F, G, or H fill a cell with P2.
If the cell contains I, J, K,or L ...

**0**

votes

**0**answers

10 views

### Representing time as a duration in Microsoft Power BI

I have an Excel spreadsheet containing video statistics. One of those statistics is the length of the video as a duration. When I import this data into Microsoft Power BI, it can be represented as ...

**0**

votes

**1**answer

21 views

### want to add reg using vbscript

vbs code are as following :
Set oShell = CreateObject ("Wscript.Shell")
Dim strArgs
strArgs = "cmd /c REG ADD "HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\RUN" /v "...

**-1**

votes

**0**answers

27 views

### Excel Formula referencing IFERROR with blank gives #VALUE error

I have come across an issue with using IFERROR to return a blank. When I have another cell referencing this blank one to SUM values I get a #VALUE error in that cell.
I assume it is because the "" ...

**0**

votes

**0**answers

28 views

### Ctrl+Shift+Right arrow pins the Excel window to the right-hand side of the screen

I am running Windows10 and for some reason, I cannot use the Ctrl+Shift+Right arrow to select all data. Arrow down works fine, but the right arrow simply pins the Excel window to the right-hand side ...

**0**

votes

**1**answer

38 views

### IF function with two logical tests

I need help with creating a formula with two logical tests. I got the first one but can't figure out how to include the second logical test.
My formula currently: If column E=S, I want Annual Salary ...

**0**

votes

**1**answer

11 views

### Excel chart into Word - losing underlines

I am trying to copy an Excel chart into Word as a picture but I am losing the underlines under certain cells. I am copying as a picture (alt+H, C, P, P, Enter), and pasting into word as a picture (Alt+...

**0**

votes

**0**answers

13 views

### Excel Code to find corresponding value to a cell [on hold]

I would like to create a code in excel that allows me to look for all the corresponding values in other columns for the term that I type in. For instance, [the following image] shows a column of ...

**0**

votes

**1**answer

27 views

### Convert Binary Sentence to Text Sentence in Excel [on hold]

So you successfully explained multiple letters to binary. Thanks for that. Is there a way to reverse that? Like an excel formula to convert a binary sentence into a text sentence.

**0**

votes

**1**answer

23 views

### Take average and ignore duplicate results in a different column

I have data similar to the following;
symbol returns
LYS.PA 0.001470588
PWG.PA 0.11875
BALYO.PA 0.240875912
ADVIC.PA 0.000712758
ADVIC.PA 0.000712758
I am using the following formula:
=...

**-2**

votes

**0**answers

15 views

### Set character encoding in MAC OS and Microsoft Excel [duplicate]

I have a csv with words in Hebrew. (It was generated with Python using df.to_csv(encoding='utf-8')) But the words are not presented good:
When open it in TextEdit, I see the Hebrew properly.
I am ...

**0**

votes

**2**answers

23 views

### Sum row/cell values when multiple column conditions are fulfilled

I'm want to sum every row/cell range in a table where one of (multiple) conditions is fulfilled in one of the columns.
An example:
I want to find the sum of all cells where the two (or more) ...

**0**

votes

**1**answer

419 views

### How to make SUMIF only consider the first column of a range?

I have a spreadsheet with 11 columns (A to K). I want a SUMIF to look at column A and add up the values in column K so my range is A-to-K. However, there are figures in columns B through J that ...

**1**

vote

**0**answers

20 views

### How to switch which sheet another Excel sheet is looking at?

Excel (2016). Suppose I have some piece of Excel in AnalysisSheet that analyzes data in some other data sheet. And suppose the following:
There are actually several such data sheets. For example, ...

**0**

votes

**1**answer

27 views

### How to multiply a row of values to a table with the same number of fields?

I have a row of value from A2:H2 and then I have a table of values from B7:E8 (both the table and row have 8 data points).
How do I go about multiplying them? Please see the bellow illustration:
+---...

**0**

votes

**1**answer

26 views

### Excel 2010: Create a column chart that groups items and then charts them by year

I am having no end of angst trying to build what I thought would be a simple column chart. My data are in three columns: Player in Column "A", Year (from 2005-17) in "B", Points for each year in "C". ...

**0**

votes

**1**answer

28 views

### Is it possible to merge 2 IFERROR formulas into 1?

I'm not sure if it's possible to merge 2 IFERROR formulas into 1. I created 2 combo boxes, in 1 sheet, one for upper and one for sole (footwear) but only "upper" appears on data field because the ...

**0**

votes

**1**answer

23 views

### How to reference a shape by name and what else can be used in .Select?

I use MS Excel 2007
My question is in two parts
I have a form option button called "Option1"
How do I refer to that button in other macros?
I know that I can select it using:
ActiveSheet.Shapes("...

**0**

votes

**1**answer

14 views

### How to reformat long date to short version in Excel

I have column with dates in format
2017-12-05 12:16:20
I´d like to change the format to
05.12.2017
I tried it via right muse button > Format Cells > Date but even if I tried all short date ...

**-1**

votes

**0**answers

15 views

### Excel Formula about percentage of the given percentages [on hold]

How to find the percentage of a task done by different persons whose results are also given in percentage?

**0**

votes

**2**answers

20 views

### EXCEL:What's a good replacement for SEARCH function that returns #VALUE! error

I have cells that contain text with the format: IVORY / RED
I'm using a LEFT function to extract the first text string like so:
=LEFT(AV1440, SEARCH("/",AV1440,1)-1)
Sometimes I run into a cell ...

**0**

votes

**0**answers

49 views

### Updating Excel worksheet

I want to use a data input worksheet to update another sheet in the same workbook. Using a command button that updates sheet2, I want the data from sheet1,cell G3 to move to sheet2. The placement of ...

**0**

votes

**1**answer

52 views

### Cell has text and number, but I need to count both

I have an excel database formatted in a calendar style for employee holidays and wages.
Sarah works the same shift pattern every week, so in the cell that relates to Monday, I have "8", for 8 hours ...

**0**

votes

**0**answers

12 views

### How can I derive a graph and table of the Cumulative Distribution Function for a column of data in Microsoft Excel (v. 16.16.2) for Mac?

Application: Microsoft Excel (v. 16.16.2) for Mac
Given the following column of data, how can I derive the CDF and return a table and graph?:
%chg
3.00%
4.90%
9.10%
6.20%
3.80%
5.90%
4.00%
2.70%
5....

**0**

votes

**2**answers

50 views

### Excel Conditional Format: If cell A10=“Highlight” then highlight all values in Column B that match cell B10

I have a dropdown box in column A. Lets say I'm working row 10. I select "Highlight" in cell A10. When I do that, I would like a conditional format that highlights any cells in column B that match ...

**0**

votes

**1**answer

33 views

### Viewing/switching efficiently between many Excel worksheets

I have an Excel workbook with over 50 worksheets. This is a necessity and I can't go away from it.
However, I find it hard to:
Have an overview of all the worksheets available
Quickly jump to a ...

**-2**

votes

**0**answers

30 views

### Which values makes the differences between Column A & B [duplicate]

The user has 2 columns with values(some values are not the same, you have to count the numbers in one column to get the total in the other column. Some of the values are credits and debits in the same ...

**-1**

votes

**1**answer

50 views

### How do I compare the values of two columns and output the value in the third column

I have three columns in excel, A, B and C. A and B have the same attribute, however A has more values in the dataset. For every unique row id in B there is a corresponding value of 1 or 0 in column C....

**0**

votes

**0**answers

18 views

### Is it possible to define Excel template regions in XML so that I can fill them in programmatically?

I am trying to use C# and XML so that I can transfer data between multiple workbooks. These are very large workbooks with lots of calculations and their formatting is dramatically different from one ...