**0**

votes

**0**answers

1 view

### Excel CONCATENATE function produces error when referencing a worksheet with space in name

In Microsoft Office Excel 2013 on a Windows 8.1 PC, I get an error message, #NAME?, when trying to do the following:
=CONCATENATE('Calculation Sheet'!D, "- Customer Sales")
Doing the same with an ...

**0**

votes

**1**answer

7 views

### Using ISNUMBER and SEARCH

I'm trying to use the formula =IF(ISNUMBER(SEARCH("180",A1,0),1,0) but for some reason it isn't working. I tried removing the quotes and the same problem occurred, I see entries (e.g. "it is 180 ...

**0**

votes

**1**answer

7 views

### Using A Conditioning Statement

Tried using statement =NOT($F2="Received"), but it still highlights everything. To start from the beginning because none of these are working, I am looking to highlight everything in red that has been ...

**0**

votes

**3**answers

35 views

### Formula is not working, cannot find error in the formula

I'm sure that this has an incredibly simple answer but I've looked over this formula for hours and can't figure out the error. Essentially what I want the formula to do is if F3 = "Freshman" then ...

**0**

votes

**0**answers

15 views

### Different permission for different user on Excel Online

I need to create Excel on-line workbook with different permissions sheets. more like some users can see some sheets while other can't edit, etc.
can I achieve this?

**-2**

votes

**1**answer

27 views

### Alternative programs to Visual Studio [on hold]

I am looking for an alternative (free to download) program similar to visual studio where i can create dlls that i can import into Excel. I have sharp develop but i am unable to import dlls into excel ...

**0**

votes

**0**answers

14 views

### Multiple languages mail merge word

I'm having some trouble with Microsoft Word's mail merge feature. Every day, we send an e-mail to a bunch of people across the world. I have an around 600 rows Excel file generated daily and I send an ...

**-2**

votes

**0**answers

18 views

### Excel to sum row values in date range

I have a worksheet with dates in row 1 and data values in following rows.
How can I sum the values for last week, month, etc?
More specifically how do I set the sum range?

**2**

votes

**0**answers

17 views

### Opening Microsoft Office 365 gives blank menus and blank popups

I have recently installed Microsoft Office 365 (shows up as Office 2013) but when I open any of the applications (Word, Excel, etc.) I am presented with a popup which is nearly blank and the ribbon ...

**2**

votes

**1**answer

18 views

### Replace contents of Excel column with realtional data from another column/sheet?

I have two excel sheets that have been exported from MySQL, with relational data in them, and I need to replace the reference ID's with the actual data from the relative column.
For example, in one ...

**2**

votes

**0**answers

15 views

### Users logged on

Need help with this I am able to run this script with no issue even excel pops up however no computer or data come in please help. I am just trying to get a list of user logged in from a specific ...

**0**

votes

**0**answers

33 views

### Multiplying Two Cells Returns Zero

I created a formula field that multiplies two cells and it returns 0 even if the numbers in those cells are greater than 0.
The formula is
=K2*J2
The values I see in those cells are:
K2 = 16.32J2 ...

**-2**

votes

**1**answer

17 views

### How to nest SubTotal with SumIf?

I have an Excel table. I would like to combine in one Formula following:
=SUBTOTAL(9;M10:M21)
and
=SUMIF(I10:I21;"Promotion";M10:M21)
Is it possible ?

**0**

votes

**3**answers

48 views

### calculating end times with working hours and skipping weekends

In my worksheet, I want to calculate estimated end times of processes.
However, i want to restrict this to a predetermined time constraint. So for example, when i add 4 hours to 14:00 I dont want the ...

**0**

votes

**1**answer

24 views

### Bar chart from data in one column in Excel

Call me stupid but every time I want to perform an easy task in Excel I end up using Google to find a solution. Today's mission impossible is to create a bar(or pie) chart from data located in one ...

**0**

votes

**0**answers

15 views

### switching between excel and other program alt + tab

I am having a problem in my new system. When I have to type certain figures in excel worksheet from a different program, I use alt + tab. Now if I am typing a long figure and have to see more than ...

**3**

votes

**1**answer

30 views

### Excel, how to use text functions on lookup array without putting in another column?

If I'm using a vlookup, or a match function but I need to do some mumbo jumbo on my lookup material, is there a way of doing this in the lookup array without simply adding another column?
Let's say I ...

**1**

vote

**1**answer

11 views

### How to copy a path from “recent items” in any MS Office application?

or "recent places" for that matter
It's not possible to copy the location from the application, so is this list stored somewhere else e.g. registry, file system, xml config file?
The problem is that ...

**0**

votes

**3**answers

50 views

### How to automatically make copies of columns in Excel?

Everyday I have to take the raw data which has more than 40 columns and increasing number of rows (right now 2,5 millions) and prepare it according to a certain format.
Lets assume that I have 5 ...

**-2**

votes

**0**answers

23 views

### How to make 1300 row Excel file with specific column name and copy the data in separate workbook? [on hold]

File#1
BEE PEE GREENS (All Lic From 01/04/2002 to 30/09/2014)
LicenseNo LicenseDate LicenseValue LiCategory IssuingOffice ExporterClass Item
1830000033 11-Jun-13 ...

**0**

votes

**1**answer

20 views

### VBA highlighting a cell if corresponding range in the same row is not blank

I am trying to enforce food name in column B of a file if column D to DX (Qty) has any value in it.
Rational is if any new request of food is received which doesnt appear in the file, the user can ...

**0**

votes

**0**answers

16 views

### Column order and names for table objects in Excel

I have a table in Excel that is connected to MS SQL Server table in the database. When I created a connection I specified a query that returns col1, col2, and col3 in this particular order. Then I can ...

**1**

vote

**1**answer

51 views

### Excel chart for rail car movements

I need to display the movements of a group of rail cars between two locations.
Each car has dates for "left location A", "arrived location B", "left location B", "arrived Location A" - repeatedly ...

**0**

votes

**0**answers

16 views

### Excel 2013 displaying 'zoomed' UI on Windows 8.1 with high DPI screen?

I'm using a high DPI laptop - 13" 1080p screen - which Windows 8.1 usually manages very nicely for modern sofware. Old stuff looks blurry, PowerShell is bizarrely unusable, everything else pretty much ...

**0**

votes

**1**answer

26 views

### How to translate automatic months from a language to another?

I'd like to translate a billing report from Portuguese to english.
It is accurate by months, and it is an automated sheet.
A contract may start on January, but it's commonly started on the others 11 ...

**2**

votes

**2**answers

41 views

### Random selection with a caveat / criteria

I have a 6 x 6 grid. I have 36 samples split into three equal groups (A, B, and C).
I want a formula to arrange the samples in that grid randomly. However each row and each column must contain two of ...

**-1**

votes

**0**answers

20 views

### Autonumber based on criteria

Trying to create a specific auto-number system based on the following:
**Criteria** **Numbering Sequence**
Pillar 4.0
Objective 4.1
Action Item ...

**0**

votes

**1**answer

21 views

### Copy/Paste only cells with values

Is it possible to do the following?
Source Target Result
|1| |F| |0|0|0| |1|0|F|
| | | | -> |0| |0| = |0| |0|
|1| |F| |0|0|0| ...

**0**

votes

**1**answer

37 views

### Excel - find multiple pieces of data in several different columns at once

I've currently got a spreadsheet on the go which lists contracts. I need to know if a contract is a renewal, new to product, or new to company. I'm currently struggling with the logic behind it and ...

**0**

votes

**2**answers

36 views

### Improper Excel Profit Formula?

I'm looking to include in column H of my spreadsheet as profit as a %. Such as if you paid $5, and sold for $10, you made 200% profit or 2x your money, obviously excel will only recognize 200%, not ...

**1**

vote

**1**answer

21 views

### Excel conditional drop down lists causing massive file size

I have an excel file which relies heavily on data validation. There are about 20 drop down lists per row. One column has a 35 formatting conditions. One column is a conditional drop down list (using ...

**1**

vote

**0**answers

22 views

### How do I combine data in two tables in LibreOffice?

I have a spreadsheet with two sheets inside, SheetA has Customer number and location, SheetB has Order number, Customer number. How do I combine the data so that one sheet has Order number and ...

**0**

votes

**0**answers

24 views

### How do I apply conditional formatting to many workbooks?

I have 120 similar excel workbooks. They each have one sheet containing a small customer databases.
I want to apply conditional formatting to all these workbooks. I can do it in one workbook. Is ...

**1**

vote

**3**answers

48 views

### Excel: How to show top 3 “winners” by age and gender?

I'd like to use Excel to manage the data for a marathon. The marathon groups winners by age and gender into a category, and awards prizes for first to third place in each category.
Can Excel be used ...

**-2**

votes

**1**answer

27 views

### Attendence Points Rollover

I have an attendance worksheet where we calculate employee attendance based on points, if employee absent they get 1 point and if tardy or did not complete shift get 1/2 points also if employee has ...

**0**

votes

**1**answer

28 views

### Functions (specifically text functions) within a countif function

Is there any way to nest text operators within a countif?
I want to check if the first 4 characters of a file are in the form A**.
=Countif(Left(A1,4),"A??.") doesn't work, but I can put in a
...

**0**

votes

**1**answer

19 views

### Monthly Pivot Tables In an Annual Report

I was given 12 tables of purchase orders (one for each month) that my school has made and was asked to create an annual report listing purchases for each month which is pretty simple.
The thing is ...

**0**

votes

**0**answers

15 views

### Permissions issues - Excel docs on Linux server, Windows and Mac OS workstations, no domain

Going to visit a client who's having trouble with permissions on Office documents, mostly some Excel sheets. They use a Linux server (Ubuntu), do not run on a domain, and have a mix of Windows and Mac ...

**1**

vote

**1**answer

52 views

### How to fetch data from another excel file and sort it under name?

I have 2 excel files, one of them is a list of workers and the other is a list of absences. I need to have the reason and the ending date from the absences list to be fetched into the main list, and ...

**1**

vote

**1**answer

17 views

### Combining 2 data sets in excel where a certain value can corresponds to multiple pairs

I have a problem where I want to combine 2 data sets. The difficult part is that certain value may have more than one pair of data and if it happens I need to combine both entry.
E.g:
Data 1 ...

**-1**

votes

**1**answer

23 views

### How do I isolate certain characters in cell content of an excel to new cell?

How do I isolate certain characters in cell content of an excel to new cell
Example: I have a big paragraph of information wrapped in a cell and I need to separate only few characters of that data ...

**0**

votes

**1**answer

19 views

### Run formula from different sheet

Can you run formulas from different sheets? (not simply showing the formula as a string/static text)
Say I type
=Sheet1!A1
where in that cell I have a formula
=concatenate(ice&cream)
...

**0**

votes

**1**answer

22 views

### Copy every nth column on a specific row from one sheet to another (in Google Sheets)

I want a function to select every 2nd column on a particular row and display it in another sheet.
I have two sheets: Sheet1 and Sheet2
In Sheet1 A2 I have a list of numbers that start from 1 to ...

**0**

votes

**1**answer

13 views

### How do I insert a picture in the comment box for Excel 2013?

I want to insert a picture in Excel in the worksheet itself, say to pop up when the user hovers over a cell. Many sources online have answered this question by saying you just add a Comment, then ...

**2**

votes

**1**answer

38 views

### Excel Strange Extra Digit

In Excel 2007/2010, I get this strange behaviour:
Formula in cell: =2.6+1.4+4.62-8.2
Result in cell: 0.420000000000002000
Weird extra '2' about 14DP in. Can anyone explain why this is happening ...

**0**

votes

**2**answers

32 views

### Return data based on matching date range

Our group has an Excel sheet that's used to track rotating responsibilities. A simple example would be laid out like this:
Column A: START has dates defining the start of the time period represented ...

**0**

votes

**1**answer

20 views

### Column to aggregate values in another one

I have a series of values in a column, and I want another column to cluster these values to specific aggregates. How would I do this in Excel?
if a1 cell value between 0 and 5, then b1 = low
if a1 ...

**0**

votes

**1**answer

21 views

### MSO Excel - Add padding to the fill color of the cell

Is it possible to add some padding to the fill color of a cell?
Now if you set a fill color on a cell, the cell is always completely filled.
(I use Excel 2016 preview, but it looks just the same as ...

**1**

vote

**1**answer

30 views

### Excel add-in not loading when opening Excel from VBA

I'm using excel reg-ex add-in and it works well, the only problem with it that it doesn't load when excel is started by VBA.
I've a macro in word to collect some data in Word and copy it to excel, ...

**-1**

votes

**0**answers

18 views

### How can I use recording macro for merging cells of rows in excel and enter to next rows?

I have 1300 data which is required to merge. I am merging the data with recording macro. the problem is now that I am not able to step next row after one merge. Please suggest me how to set up the ...