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.

learn more… | top users | synonyms (2)

0
votes
1answer
32 views

How to optimize fields that has “if” function which return blank value on Excel?

Here is the screenshot, it's only an example since I can't post the original one: I made this worksheet to cross-check the employee present with another sheet that has information whether this ...
-3
votes
2answers
38 views

If statement what is wrong with my formula?

What is wrong with this formula? =IF(I89="Pepsi Direct","15 or 225$ Rev", IF(H89="Large Format",VLOOKUP(B89,LF_List,3,FALSE), IF(H89="Small Format",IFERROR(VLOOKUP(B89,OTS_List,2,FALSE)),"22", IF(...
0
votes
0answers
26 views

Formatting similar MSWord (pasted from MSExcel) tables in batch

I've got a lot of similar spreadsheet (same dimensions, different numbers) in MS-Excel, like this : To present them in my report in MS-Word. I have to format them in this way : To avoid ...
0
votes
1answer
23 views

How to automatically create a copy of a list that filters out rows that have/do not have contents in a specific column?

I'm trying to manage a customer list. I have a sheet that has all customers on it. Some customers have emails, and others don't. From this full list, I need to create two separate lists. A list ...
1
vote
1answer
28 views

Conditional formatting if an input cell is blank in a row marked completed

I want to highlight any blank input cell in a row if the row is labeled as completed in column B. There are several columns with information being entered in them and I would like to use this as a ...
1
vote
2answers
54 views

Changing cell colors in Excel based on data in another worksheet

I have a storage facility where I am trying to use Excel to track all the units. I understand conditional formatting well enough to change the text and cell colors for the unit size and current status ...
0
votes
0answers
14 views

Refresh Excel Connection without source being open

Morning all, I have a query regarding refreshing Excel connections. I have a company workbook that has many sheets and is in constant use all day, however I have a connection created to this which ...
0
votes
1answer
24 views

Autoupdating an excel table in a word document

Not really a microsoft/windows user so apologies if the answer is obvious. I am running a windows 7 machine using microsoft office 2007. I have an excel spreadsheet in which a series of different ...
0
votes
0answers
32 views

I want to split my Excel data into a new row

I need some help in sorting my data. As in the image, the original file looks like the top image and I want to split the size into a new row below for all items as in the bottom image. The file ...
1
vote
0answers
27 views

How to Mirror Cells when the source is a data validation list? (Excel 2010)

I have a workbook with two tabs. The first tab is being used as a table for data validation lists I'm creating in the second page. For example, one list is called "Supervisors". This list starts cell ...
1
vote
1answer
41 views

How to count the number of cells in a range containing a specific (sub)string with Excel/Calc?

Using Excel/Calc I have the following situation: a range of cells containing values; assume it's A1:B10, and a string I want to look for; for example, assume it is contained in C1. Now what I want ...
0
votes
1answer
27 views

Extended Subtraction Between Columns on same row in area

I want to calculate the transaction value so by that i mean i've got different accounts in column "A" and for each transaction i got a column like "B". The transactions show the new value, after the ...
0
votes
0answers
15 views

CTLR + [ to trace precedents on international keyboard

How can I execute the shortcut CTRL + [ on an international keyboard (Italian in particular)? "[" can be inserted only using "Alt Gr" button, so the shortcut doesn't perform at all. Furthermore, is it ...
0
votes
1answer
38 views

Turn cells in a column a color based on another column

My spreadsheet has conditional formatting that turns a cell in Column M a color when the cell value is NOT "N/A." How do I also change the color in Column A based on the corresponding cell in Column ...
0
votes
0answers
49 views

Excel: Can I use text references without volatility?

A1 contains Namedrange,1,23,3,bla On the row I split it down to having each of the , delimited entries in its own cell. B1 =LEFT(A1,FIND(",",A1)-1), C1= formula results in 1, D1 = formula results in ...
-1
votes
0answers
23 views

Find Data in Excel sheet 1 in sheet 2 A1 where theres is a match populate with data from sheet 2 b2 multiple variables

I excel I would like to find the data I have populated in sheet 1 cell A2 in sheet 2 A12:A55. When that data is found I want the matching data in B12:B25 to populate on sheet 1 cell C2. I would like ...
1
vote
0answers
23 views

excel 2013 clipboard entries

Sorry for missing a step between 2 & 3 on my original post. Edited portion is inserted in bold text (step 3). I got this excel 2013 copy-paste command problem that occurred a couple of days ago. ...
0
votes
1answer
19 views

Formatting “spills over” to next rows: is this a bug in Excel 2013?

I have ran into an annoying thing in Excel 2013 for a few times now, and I can't find any reason for this behaviour. Below are the steps to reproduce the weird behaviour: the question is, is this a ...
-1
votes
1answer
25 views

Changing cells in range based on a range title

I have a column of 25 triggers that have Y or N and the occasional B (for Blocked) for an execution of an automated script. I have a few different scenarios that I would like to control by setting ...
-2
votes
1answer
25 views

Using Conditional Formatting, highlight a cells based on value in adjacent cells

How to highlight column B values based on corresponding Column A value using conditional formatting. Thanks in advance NRM
0
votes
3answers
62 views

Excel 2013 - combining conditional formatting

I'm not very proficient when it comes to Excel formulas, so a few weeks ago I posted a question & got a great answer. Since then, I realized there's one additional thing that would make this even ...
2
votes
2answers
15 views

using cells embedded with text in calculations

How can I incorporate text within a cell while maintaining the ability to use that cell in other calculations? For example: To show "Days" within a cell, I've used formala: =B1-A1&" "&"Days",...
0
votes
0answers
18 views

Pulling non-blank date value for where ID matches and there exist both blank and non-blank values for same ID

I have a report that has rows where a UserID shows up multiple times. I am needing to pull the start date (non-blank field) for any row where the UserID matches the reference UserID (matching the ...
1
vote
4answers
40 views

Add a Function to Existing Formula

I would like to be able to amend my already existing formulas and add them new functions in mass. For example, I originally wrote a calculation =Sheet1!D38-Sheet1!E38 and would like to add an =...
0
votes
2answers
41 views

How can I sum with partial parts of cells?

Let's say I have a spreadsheet look like this. A |B ---------------- 1 |1.0 2016-05-07 2 |0.5 2016-04-12 3 |x.y yyyy-MM-dd How can I sum those first values(1.0, 0.5)?
-1
votes
0answers
8 views

Compare and Highlight Duplicates/repeatition in Workbook after Workbook has been updated

I have periodically updated workbook sent to me. The issue is that it is difficult to identify the difference between the older workbook and the updated ones because there are hundreds of rows. Is ...
0
votes
1answer
22 views

Combine data from two rows to make one row where that data alternates

If I have 2 rows of data, A1:E1 and A2:E2, and I want a new row to organize that data by alternating the numbers, A1,A2,B1,B2,C1,C2.... Is there a formula I can use that will copy over and keep the ...
0
votes
1answer
26 views

Excel 2010 Pivot Table - Show Value As

I have set up a pivot table. Two of the fields are "Inseminations" and "Confirmed Pregnant" in the "values" area. They are the count of dates for inseminations and count of "1"'s as the "confirmed" ...
0
votes
1answer
29 views

How do I insert thousands-separators without affecting significant figures in Excel?

I need to figure out how to add thousands separators to large spreadsheets without affecting the amount of significant figures or the dates that are also in the tables. I can't figure out how to use ...
0
votes
2answers
28 views

How do i remove #N/A in a IF formula

Here is the formula: =IF(I11=H11,$H$10,IF(I11=G11,$G$10,IF(I11=F11,$F$10,IF(I11=E11,$E$10,IF(I11=D11,$D$10,IF(I11=C11,$C$10,IF(I11=B11,$B$10)))))))
1
vote
1answer
37 views

Excel VBA code and Outlook Programmatic Access warning

Since about last Friday one of my Excel macros that generates an email has been getting this warning: Microsoft Outlook: A program is trying to access e-mail address information stored in Outlook. If ...
0
votes
1answer
23 views

CountIF/CountA using Array Functions

I have a list of projects in various countries (each row is a distinct project; countries are listed in Column A). Each project can have multiple tags (e.g., demand, pedagogy, ICT, etc.). For a much ...
0
votes
1answer
52 views

VLOOKUP assistance: match column with column on another sheet

I have a fairly simple VLOOKUP Question but I'm comically horrible with Excel. Basically, I have two spreadsheets. I'm wanting to find data from Column B of Sheet 2 on Column W from Sheet 1. If the ...
0
votes
0answers
13 views

Limit Data sum & count to less than value

I have 13000 customers data of bills. I want arrange it in various files with 2 conditions 1st in 1 file all sum of bills is less than 8400 required 2nd in 1 file less than 199 customers require. ...
0
votes
1answer
32 views

Trouble combining IF statements in formula

I am trying to create one formula that will do this: If <=10, then take 50% of the amount, if >10, then the lower of 5 or 25% of the amount. I converted the second statement to Excel by saying if ...
2
votes
1answer
127 views

Excel 2007 help: How to find four or more instances in any seven-day period?

Got an Excel question. I throw myself before the Excel gods and pray for your merciful help! Every time an employee sneezes, I put it on the chart below. If there are four or more sneezes in any ...
0
votes
1answer
23 views

Excel import data from web

While importing data from web page the text formatting is lost, ie any data that seems to be numeric is converted to numeric, which should not. for example: web data contains 0023181 012318U ...
0
votes
1answer
32 views

Automating number of paid sick days employee has remaining

I have a file showing how many paid sick days an employee has remaining, we get five days each on a rolling 365 day basis. So if someone is sick 24/05/16, 25/05/16, 26/05/16, 27/05/16, 28/05/16, they'...
0
votes
1answer
49 views

How to change a negative value to a positive number not exceeding 49

Hi I have the following question that I am struggling with solving I have si numbers from a lotto draw to which firstly I would like to subtract each number by 25 and record into cells , therafter if ...
0
votes
2answers
35 views

How to add line on the top of the text in excel 2016

How do I add horizontal line on text in excel 2016. It is like underline but it goes on the top instead of bottom of the text. There are explanations on the internet for earlier versions of excel but ...
0
votes
1answer
21 views

Excel's “filter by cell value” filters OUT. I want to filter IN.

Filter by Cell Value is smart enough to identify and delete all rows containing a match to a list in another column. BUT I want to capture and keep them! (instead of deleting). If excel can ...
0
votes
1answer
18 views

Workbook sheet date to autofill weekly tracker

I'm building an excel workbook in which the first sheet, a user will type a date in A2 and pull down the property he visited in B2. The next sheet is a weekly tracker with the first row labeled weeks ...
0
votes
1answer
77 views

Mirror cells when a change in either cell updates the other

Gary's Student answered this question before and it worked great for only 1 cell per sheet. If I wanted to mirror multiple cells what could I do? I have tried the following and it does not work. I do ...
0
votes
4answers
68 views

How can i get one certain row , one line below?

What i mean is that i have an excel doc with 4 rows A B C D 1 Data1 Data2 Data3 Data4 2 Data5 Data6 Data7 Data8 I want every D row data to get on the below line and ...
-3
votes
0answers
22 views

How to take inputs and create database in excel

I apologize in advance for the broad question. I am using excel to keep a database of a group of around 20 people and (theoretically an infinite amount) of companies for a school club. Basically, I ...
0
votes
1answer
17 views

Split string and get the first part with IF

I have the following data in excel and would like to get the first part (before the "/") if there is a "/". If not, just get the value in the cell. A1 is the raw data and A2 the desired output. ...
0
votes
1answer
33 views

How to design table in MS Excel or MS Word with varying cell sizes? [closed]

How can I design a table in Microsoft Excel with varying cell sizes? I do not want to have the entire row as one size, but single cells as a specific size.
0
votes
1answer
41 views

First date that matches criteria

I have 2 columns, LotNbr and ShipDate. I'm looking to create a column that contains whether the ShipDate was the first date for that LotNbr: LotNbr | ShipDate | FirstShipment aaaan1 | 1/1/2016 | yes ...
0
votes
0answers
30 views

Using spreadsheets for comparison

I run a small business, so I'm having to learn how to do a lot of things I never thought I'd have to. Anyway my question is this, I have just got a new supplier who supply some products that are the ...
0
votes
0answers
15 views

Excel Automatically Fill Cells In Time Range

I am trying to create a calendar that will fill cells in the graph to reflect the times listed out in Columns D and F. In essence, my hope is that I can enter the start time, enter the end time, and ...