**1**

vote

**2**answers

53 views

### How can the SUM be repeated in the equation until answer is less than or equal to 1?

Base equation
(J3+x)/150
Multiply answer by x then divide all by 150 and Repeat
( ((J3+x)/150)x )/150
(( ( ((J3+x)/150)x )/150 )x)/150
Keep repeating until the answer to the last repeat is ...

**0**

votes

**2**answers

56 views

### unique count of values in a cell separated by comma in excel

How do I get the unique count of values in a cell separated by comma in excel?
For example: cell B13 has the value
1,1,2,3,7,1
Using the below formula we get the count of values separated by , as ...

**2**

votes

**1**answer

41 views

### Excel sheet with list of servers and links to different Remote Desktops

I have found some code to execute Remote Desktop from Excel,
Sub RDP()
Dim RetVal As Variant
RetVal = Shell("c:\WIndows\System32\mstsc.exe " & Range("A1"), 1)
End Sub
I have many ...

**0**

votes

**1**answer

18 views

### Automatically push row downward

I'm trying to make a time sheet document, and I want it to be formatted
-----------------------------------------
| Date | Time In | Time Out | Hours |
-----------------------------------------
| ...

**-2**

votes

**1**answer

26 views

### IF/AND Function in Excel returning 0 when conditions are met [closed]

So just like the title says, my formula is returning some of the outputs, but for others, it simply outputs 0, which is the value if false. Perhaps I have too many nested AND functions. Any analysis ...

**1**

vote

**0**answers

15 views

### Conditional Formatting the rest of the column, not the entire column

I want to add conditional formatting to the rest of the cells in the column, not to the cells above. I can figure out how to add it to the entire column, but I want to make sure that the formatting ...

**2**

votes

**1**answer

175 views

### Excel vocabulary to find solutions faster [closed]

Excel (or other spread sheet application) users sometimes find it hard to search for already documented solutions for their problems on google / superuser / other sites when they are not familiar with ...

**1**

vote

**0**answers

15 views

### LC_date like option for excel sheet (possible in libre office)

Windows 8.1, office 2013, english interface - danish region.
When working in excel I often paste dates from another application. These dates are in the form Januar 2013. When pasting, it seems excel ...

**0**

votes

**2**answers

46 views

### How to show two data series of same range but different frequencies on same graph in Excel?

I would like to show two data series (as lines) on the same graph in Excel. The two data series have different frequencies but are of approximately the same time range. To be specific, I want to ...

**0**

votes

**1**answer

15 views

### Searching within an Excel string

I have a column that contains a (varying amount) set of tags all comma separated. I'd like to convert some of these into a single column so I can separate items by the tags.
Sample cells:
* ...

**0**

votes

**1**answer

40 views

### Virtualbox 4.3.20 on Debian 7.7 as Host with Windows 7 as guest - can't save excel 2010 file on to external usb drive

Can't save excel 2010 files on to external usb drive:
External usb drive is identified as JMicron USB to ATA/ATAPI bridge [0100] as a "USB device filter". However saving a text file created in ...

**1**

vote

**1**answer

18 views

### Bars In Excel Take Up More Space Than Axis

I have this graph sent to me in Excel, which I have moved into Word:
As you can see, the bars of the graph take up more space than the axis, and the bars at both ends have been cut off. Compared to ...

**0**

votes

**1**answer

10 views

### Excel Math using IFBLANK on certain cells

I have a spreadsheet that has some prices for parts, and then has a check list for those parts.
So basically I have in A column a list of budget leaps, such as 1000, 2000, 3000, 4000 etc. In B ...

**0**

votes

**2**answers

25 views

### Save clipboard contents

I need to make the same changes to multiple spreadsheets over time. The clipboard forgets or deletes its contents when I close Excel. Is their any way to save the contents of the clipboard for the ...

**0**

votes

**0**answers

17 views

### Updating MySQL data in an Excel spreadsheet

I have a data table in excel drawing data from a MySQL data connection using a custom query definition. Right now I am trying to change one of the "WHERE" clause parameters, but when i do so the data ...

**-1**

votes

**0**answers

22 views

### 4 year earnings, expenses and savings in one graph?

Over the past few years I have kept somewhat through Excel "budget reports" and a yearly sheet that contains the months (B1 - M1) and the $$$$ in 4 categories: Year, expenses, income, balance, money ...

**0**

votes

**2**answers

15 views

### Autofill increment from another sheet

I'm using the formula =MID(Sheet1!C3,FIND("Item",Sheet1!C3)+6,13) and trying to autofill a large area but increment by 4. I use this one then =MID(Sheet1!C7,FIND("Item",Sheet1!C7)+6,13) and drag ...

**0**

votes

**1**answer

66 views

### How do I create VBA code to extract certain columns of data from excel file? [on hold]

I have a data file that has 600 columns and 14,000 rows of data. I am working on creating an excel GUI that lets you reduce this data to only the parameters you need. The parameters (headers) are in ...

**0**

votes

**3**answers

34 views

### Fill formulas until end of adjacent table

I'm trying to fill a column with a simple formula using cells from an adjacent table. I know how to do that by dragging the mouse, but it's a very long column, so I'd like to use AutoFill.
...

**0**

votes

**1**answer

38 views

### How do you export an Excel file to CSV with rows have differing number of columns?

I have text file with a header, master, detail, footer record. The types of rows all have a different amount of columns. When I export to CSV, it exports all data and puts in fillers to the longest ...

**0**

votes

**1**answer

27 views

### Zoom in on Excel 2010 print preview

Is there any way to zoom in when in print preview mode for Excel 2010? Many textboxes don't print as displayed (not WYSIWYG) and sometimes the print preview zoomed out is too small to notice.

**-1**

votes

**1**answer

90 views

### Referencing a cell in Excel using values from other cells in different worksheet (tab)

I'm trying to set up a Excel sheet for a running log.
What I'm trying to do is to get info from a cell that is 7 rows dowm from cell H8 on worksheet Log. This is so that I can just drag the forumla ...

**1**

vote

**2**answers

55 views

### Chart macro displaying incorrect labels from non-sequential visible rows on filtered worksheet

This macro displays text labels from the source worksheet when double-clicking a dot on a scatterplot chart. The chart is updated when the source worksheet is filtered on any of several columns. The ...

**2**

votes

**4**answers

60 views

### Using COUNTIF in Excel to count number of “Greater than” values in an array of values

So here is my situation. I'm a principal creating a tracker for my teachers to use to track student growth on assessments. In the current tracker it is set up like this:
% of ...

**0**

votes

**1**answer

46 views

### Excel worksheets not seeing their VB code

The form buttons and controls on all my worksheets suddenly stopped working. The behavior is like what you see before you respond to the security prompt-- "enable macros?", that is, when you ...

**0**

votes

**1**answer

25 views

### Excel - Creating UDF from a Formula

I often come across situations where I am writing very similar but verbose formulas that use the same range as an argument for multiple functions.
As a simple example, consider:
=(A+B)/B
Is there ...

**0**

votes

**0**answers

18 views

### Copying text from one pivot table to another

I'm trying to copy text from a pivot table in one spreadsheet to a pivot table in another spreadsheet. I get the message "Microsoft Excel cannot paste the data". Why? I've been able to do this for ...

**1**

vote

**2**answers

51 views

### Add 0 for h in h:mm:ss

I pull a lot of data that comes in as h:mm:ss, when it's under an hour it shows as :59:59 and I need it to show as 0:59:59. Any way to set something up that can automatically do that so I do not need ...

**0**

votes

**1**answer

28 views

### Excel multplying various cells

I am trying to solve a problem. Multiply a1*a2, if zero, multiply a1*a3. I tried using sumif(a1*a2),0,a1*a3 This totals both.

**0**

votes

**0**answers

26 views

### Sharepoint Excel file synchronization

I recently found a problem with Sharepoint and Excel with concurrent changes:
Person A created an Excel file with, let say, 2k inputs and uploaded it to Sharepoint with website
Person B did not open ...

**0**

votes

**0**answers

15 views

### Microsoft Powerpivot button not working

Hoping someone can assist me with this strange Powerpivot issue; I have a single workbook which is not working with Powerpivot. It has a substantial amount of VBA code (much of which is related to ...

**0**

votes

**1**answer

33 views

### How do 'Sum' time in decimals for result in hours and minutes in Excel?

How do I total hours and minutes shown as decimals?
For example 1.45 represents 1 hour and 45 minutes plus 1.40 (1 hour and 40 minutes) summed to give me 3.25 (3 hours and 25 minutes) instead of ...

**0**

votes

**1**answer

28 views

### How can the camera tool in Excel be locked (no scrolling)?

I am currently using the Excel Camera Tool to display a legend on a different sheet. The problem is that the Picture seems to be fixed to a certain part of the page and if I scroll down, the picture ...

**-1**

votes

**2**answers

35 views

### Creating NEW files and folders

Sub Test()
Dim myDir As String
Dim Folder1 As String
StartDate = DateValue("2-Nov-2014")
NumberOfDays = 1
For N = 0 To NumberOfDays - 1
Folder1 = UCase(Format(StartDate + N, "MMM YYYY"))
Folder2 = ...

**0**

votes

**1**answer

52 views

### Excel 2010 formula [closed]

Does anyone know if there is an easier way to use the nested If statements other than what I am using below.
What I have is a column with 159+ counties in GA, and a column with data say AB or AG ...

**1**

vote

**2**answers

44 views

### How can I make a Msgbox pop up over other application?

I have an Excel macro that deals with thousands of lines in several tables and do some copy/paste/analyze/combine... operations. it takes almost 10minutes to run it fully.
I added a MsgBox "Job Done" ...

**-1**

votes

**1**answer

45 views

### how to setup (x) to (x) + 1 ÷ 5 + 3 calculation in excel?

I have been given an equation and also the correct calculation. However trying to set it up in excel is not matching the desired result. I am unable to figure out if i do not understand the equation, ...

**0**

votes

**1**answer

54 views

### How to create an Excel Macro that works with any Excel workbook on my computer?

I want to create a macro and save it in a way so that it would be used by any Excel workbook I open on my computer. Is there a way to do this?

**0**

votes

**2**answers

54 views

### How can I plot multiple columns as a single continuous series in Excel?

I've got a spreadsheet that has several columns that hold the same type of data (a list of average measurements). They're separated into different columns as each on represents a slightly different ...

**0**

votes

**1**answer

40 views

### Excel on Mac and Windows have different row height / column width ratios

I find it odd that the same workbook in Excel is stretched horizontally on the mac. This is a slight problem, because the word wrapping changes, sparklines become squished, and the appearance becomes ...

**0**

votes

**3**answers

53 views

### Excel - Recognize JS Date format

I have a service that spits database data out into CSV format, that I can't necessarily change right now.
While the executing query returns the standard SQL date format - 2014-12-26 19:41:23.012 - ...

**-2**

votes

**2**answers

129 views

### highlighting duplicate rows in excel by VBA macro

I have a matrix which includes different/same values in first column, and different values in first row.
I would like to compare all rows and highlight duplicate rows. For each row, it should check ...

**2**

votes

**1**answer

38 views

### Why does Excel Table Format, always use absolute referencing in formulas. Any way to disable it?

The Table format (Home> Format As Table) option is a good feature of Excel. I am using it in Excel 2013.
But when I put a formula and try to copy it across, it does not work. Trouble comes when you ...

**0**

votes

**1**answer

49 views

### Count several values appearing together in several rows with another

In excel, how can i count how many times one value appears in the same row as another value. for example in this array, how many times does 5 appear with 6. I can see its 3 times but need a formula to ...

**0**

votes

**2**answers

26 views

### How to sum rows with a timepoint and a duration criteria

I got two tables. One with 36 columns representing three years and a second table with three columns a number a start month and a duration in months. In the second table I got different rows, for ...

**2**

votes

**4**answers

67 views

### The file is open by another user

Help me to hunt down a question.
Then I am trying to open or save a spreadsheet in excel it always shows me a downloading status bar without any progress. After few minutes the file opens or not. ...

**1**

vote

**1**answer

60 views

### How to calculate average bed and wake time?

I have a spreadsheet of two columns. A contains bed time (time I went to bed) and B contains wake time (time I woke up). How could I go about calculating the average of bed time and also wake time?
...

**0**

votes

**1**answer

30 views

### Excel column functionality

i was looking for a function in Excel to do the following thing.
I have a list with EAN codes (they're all in column A) with every EAN code there is a description of what it is (descriptions are all ...

**1**

vote

**2**answers

47 views

### When draging cells down, how do I get it to fill with even refrences (A2, A4, A6)?

I am trying to fill cells with even references (condition A) but Excel provides me with complete series fill (condition B) when I drag down formula.
Condition A:
$A$1+A2
$A$1+A4
$A$1+A6
$A$1+A8
...

**0**

votes

**2**answers

18 views

### Building a graph off of a sensitivity table that's been conditionally formatted

Ok I'm having the hardest time explaining this so will use pictures. I have a sensitivity table with conditional formatting. Right now it's formatted to highlight everything <=$40. You see how ...