Microsoft Excel is a commercial spreadsheet application written and distributed by Microsoft for Microsoft Windows and Mac OS X. If your question is about programming Excel in VBA then also tag it excel-vba. If it is about an Excel formula or worksheet function, then also tag it worksheet-function.

learn more… | top users | synonyms (2)

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