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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
2answers
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
1answer
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
0answers
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
0answers
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
1answer
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
1answer
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
0answers
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
0answers
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
7answers
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
1answer
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
1answer
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
1answer
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
2answers
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
1answer
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
1answer
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
2answers
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
0answers
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
1answer
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
0answers
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
0answers
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
1answer
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
1answer
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
0answers
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
1answer
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
1answer
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
0answers
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
2answers
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
1answer
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
0answers
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
0answers
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
2answers
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
0answers
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
1answer
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
0answers
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
2answers
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
1answer
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
0answers
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
1answer
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
0answers
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 ...