**0**

votes

**1**answer

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

**2**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**2**answers

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

**0**answers

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

**1**answer

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

**0**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**0**answers

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

**0**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**3**answers

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

**2**answers

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

**0**answers

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

**4**answers

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

**2**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**2**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**2**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**4**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**0**answers

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