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)

0
votes
1answer
30 views

how to CONCATENATE array text?

Let the cell A1 has "abccba" Now I write a formula in the cell B1 =RIGHT(LEFT(A1,ROW(INDIRECT("1:"&LEN(A1))))) it gives value "a" or array string as{"a";"b";"c";"c";"b";"a"} Now when I concatenate ...
0
votes
1answer
29 views

Excel 2013, Vlookup - accessing different sheets.within a workbook

I Have a cell (lets say its A1) that specifies (from a drop-down list) a Sheet Name (AA BB CC DD etc) I want to pass that sheet name to a VLOOKUP Formula which would (if life were simple) be SOMETHING ...
0
votes
0answers
17 views

Hyperlink to file in TextMate

I use TextMate to edit LaTeX documents. Let's say I have the file foo.xlsx on my Desktop. In my .tex file how can I add a hyperlink to foo.xlsx, so that when I click on the link, the file is opened ...
1
vote
0answers
77 views

Office 2013 on Windows 8.1 gives out of memory error when opening files

We have the same error that has been posted here: Problems opening Excel attachments from Outlook Namely, when a user opens a file from the internet, the internal network or an outlook attachment ...
0
votes
1answer
89 views

excel 2010 Vba, looping through named ranges, Run-time error '1004':

I am assigning the same Macro to several OptionButtons. I try to determine in which named Range the cklicked OButton is located. So I get the Cell of the Button and loop through all named Ranges in my ...
0
votes
0answers
38 views

Excel Daily Average Profit [duplicate]

I have a table that looks like this..Just two column..Date and Profit: Date--------------Profit 24 - March------25.00 24 - March------19.85 25 - March------5.25 26 - March------6.36 26 - ...
1
vote
2answers
44 views

Microsoft Excel - comparing values of multiple columns against values of multiple other columns

I have a spreadsheet containing names. I have 5 columns of unique names, let's call the headers: Name A Name B Name C Name D Name E I also have 10 columns of other names (not necessarily unique), ...
0
votes
2answers
39 views

Finding a value in one colunm that matches another column then putting that value in a third column (excel 2010)

All of the values are texts since the are usernames that are from two different systems. so one column has: Column A Column B smit19108 Fred99015 Fred99015 Smit1908 ...
1
vote
1answer
33 views

How can I assign Excel keyboard shortcuts for macros that use keys other than Ctrl + {alpha character}

I would like to assign keyboard shortcuts to Excel macros that use keys other than the standard Ctrl + {alpha character}. Based on this post it sounds like it is possible but I am not sure how: ...
1
vote
1answer
52 views

Excel formula to show FORMULA

Ok, guys. I am 100% sure that a few days ago I saw and tested a real built-in Excel formula for showing a formula as text in any cell. Now, when I need it, I cannot find it!!! No VBA, no tricks. Just ...
0
votes
0answers
44 views

setting upper and lower limit excel histogram

I am using the built-in data analysis tool to create a histogram for a column of numerical data in Excel. I'm doing the same thing for many different files, and they all need to have the same scale ...
0
votes
0answers
54 views

Multiple Values in one cell needing separate row in Pivot Table

I am looking for a solution on how to have a separate row in a pivot table for 2, 3 even 4 values in one cell. Example - Columns are as follows: Date, Job Name, $ Value, Distributor Quoted, ...
2
votes
1answer
43 views

How to unselect Excel Cell using Keyboard Shortcut?

One can select multiple Excel cells (either contiguously or not) using the keyboard shortcut Ctrl+Click. How do you deselect one or more of these previously-selected cells?
1
vote
2answers
56 views

Excel: Sum a column of text excluding duplicates in another column of numbers

I am trying to figure out a formula. I need to know how many times a certain issue happens based on case numbers. Meaning there are multiple entries under a specific case number for that subject, but ...
0
votes
0answers
30 views

Import image from MS SQL Database into Excel

I have a MS SQL Database where images are stored as byte[]. Is it possible to import these byte[] into Excel and convert them back into images? I already have a connection to the database in my Excel ...
1
vote
0answers
31 views

Cell Formatting, 0.00 where blank value

I have some cells that are formatted as hours and minutes i.e. [h]:mm. If no value exists in a cell I want the cell to show 0:00 without having to manually type. It needs to be user friendly, so if ...
0
votes
1answer
17 views

Return transposed list of all strings in a row in Excel

In my Excel (for Mac 2011) sheet, the range B2:2 contains mostly empty cells, but some cells contain strings. I would like to print these strings into a transposed list beginning at A12. This list ...
2
votes
1answer
29 views

Excel Formula - returning data

I have a spreadsheet that has four columns of data. I want column number four (D) to display the value of column three (C) IF the number next to it in column two (B) matches ANY number in column one ...
1
vote
1answer
36 views

Show increase in trendline by using Excel vba

I have data in c5:c12 (sales1) and I plotted a graph and a trendline of this data. I also have data in d5:d12 (sales2). I would like to show an increase, graphically, in my existing trendline by using ...
0
votes
1answer
31 views

Excel converts datetime to other format where days are low enough to be months

I live in europe and our datetime format is usually dd/MM/yyy I have an excel spreadsheet where I have ALOT of dates But for reasons I do not know, Excel converts where (dd < 12) to mm/dd/yyyy - ...
0
votes
1answer
19 views

run macros assigned to many excel sheets of a workbook, with one click

I have one workbook with 8 worksheets. I have a macro assigned to each worksheet. I want to run all 8 macros from one worksheet in one click(by clicking one button, to run all 8 macros). How can ...
0
votes
1answer
27 views

How to link drop down cells in 2 different worksheets?

I am trying to make a spreadsheet for my work and I want to create a drop down list which have to contain "Canceled","ordered","accepted".(I know how to create this drop down list). Now I want the ...
0
votes
1answer
39 views

Excel VBA: How to use a unique username or save location for an export pdf macro

I have a macro that prints a uses the internal Excel method ExportAsFixedFormat to print a worksheet as a pdf and save the document to the desktop using a unique file name structure. ...
1
vote
1answer
23 views

How do you do an Excel format string that represents number of days in the times-apn

Let's say A1 contains a value which is the number of days in duration. Example: 17.121875 That number represents the number of days. I would like to use an excel format which ultimately makes it ...
0
votes
3answers
36 views

Display excel grid lines in front of a chart?

I have an area chart in Excel for Mac 2011 that I'd like to display grid lines in front of. Is there a way to do this? I know I could make the chart semi-transparent and show the grid lines through, ...
0
votes
2answers
58 views

Excel 2010 Table auto expand/formula copy not working

I have a table with around 2k rows, for which I originally needed any formulae copied down into new rows, when they are added. To achieve this, I created a table from the data as many threads stated ...
0
votes
2answers
24 views

Weird Calculated Field behavior in a Pivot table in Excel

Intro: I wanted to add an index to a pivot table I wanted to add an index number (1, 2, 3, ...) to the rows of my pivot table. After some experimenting, I ended up adding a column to my source table ...
1
vote
2answers
89 views

Excel: How to connect to a sqlserver localDB

I have created a LocalDB that I can work with in MS sqlserver management studio 2014, linqpad, and visual studio 2013. Here is the part of the "connection property" dialog in SSMS which shows the ...
0
votes
1answer
60 views

when criteria does not match do nothing excel vba macro

I am implementing a macro that checks column E for dates that are 7 days away from current date. If cell date - current date = 7 then an email containing the row that has the matching cell, is sent ...
0
votes
2answers
25 views

Excel function - Extract string

I have some urls in various lengths in an excel sheet. ex- www._______________________________/article1-1328904.aspx www.__________________/article1-2754304.aspx I have to extract out the 7 digit ...
0
votes
0answers
21 views

How do I copy/referrence last value of the column from another file and worksheet

I have two spreadsheets - one is the inventory sheet that gets updated with sales and purchases, and the other spreadsheet is where I want to reference or copy the ending inventory as soon as it gets ...
-2
votes
1answer
29 views

I am trying to insert a function in my VBA code to only fill a cell when another cell has data in it [duplicate]

This is my code. It fills the Date when I have this =Updating_Date(B5) typed in C5. What it is supposed to do is fill the Date ONLY when data is present in B5, and remove the Date when No data is ...
0
votes
1answer
27 views

add prefix to a cell in a spreadsheet

I have a cell in a (google)spreadsheet document (let's say L7) where I usually put a numeric value (like, say: "28", "12", "87"...). I'm trying to make a formula that adds a letter in front (or ...
0
votes
1answer
47 views

How to lookup a value and return multiple unique values (remove duplicates) to a single cell - comma separated

I am trying to take a value (unique id) from column AC, do a lookup in column (B) and return (meaning concatenate) the multiple unique values from an adjacent column (C) to a single cell in column AD. ...
0
votes
3answers
59 views

how to get text instead of TRUE:FALSE in excel

suppose I have a formula in cell C3:=AND(A1=B1) it will give TRUE:FALSE but i need Yes:No instead so how do I format the cell C3 to get so? Thanks! Regards,
-1
votes
1answer
22 views

Excel not display cell content

When I open an excel document, some of the cells are not displaying their data : But the function box correctly displays the data contained within the cell : I'm using version : What can ...
0
votes
0answers
26 views

Excel hangs when trying to save a shared file

I have a fairly large spreadsheet (~ 5MB) shared between several users. While some users have no problems, some see Excel hang when they try to save their changes. It can happen when they are the only ...
1
vote
0answers
35 views

Excel 2007 =Hyperlink issue. Calling an EXE with a / switch. The “/” turns into a “\”

I'm trying to run a program from a spreadsheet using the =HYPERLINK function. The formula looks like this (I'm using DIR just as an example so people can recreate the issue if they want): ...
0
votes
2answers
23 views

Excel related query for the merging of data

i my worksheet there is several name in Colum A in which many of then are same and i want to merge all the same name along with the numerical data present in there respective colum B plz help me
0
votes
1answer
23 views

Excel file information shared over LOOKUP formula [closed]

In Excel, I have a Vlookup to a shared drive that only 3 people have access to. But other people who do not have access to the shared drive are also able to access this data For Example: I type in ...
0
votes
1answer
65 views

Excel VBA: Is there a command for printing to PDF (doPDF ver 7)

As the title suggests... I'm looking to expand my automating to include directly printing to PDF. The macro(s) I have written already formats the print area and page setup as I need it. But when I go ...
-1
votes
1answer
37 views

I need a cell to automatically fill when data is entered into a neighboring cell

I would like cells E5-E39 to automatically fill with data in cell P1 when data is entered into cells B5-B39. So when something is entered in cells B5-B39, E5-E39 are auto filled with the info in P1. ...
0
votes
0answers
9 views

Capture user ID of last updated cell in Sharepoint

I want to track who is changing what values in a spreadsheet I have uploaded to Sharepoint. Is it possible to capture the id of a user who last updated a particular cell?
1
vote
2answers
70 views

I need todays date to auto fill in cell when data is entered into another cell

I would like to have cells C5-C39 auto fill the date when data is entered into cells B5-B39. I have tried to get it to work using =TODAY() but don't how structure the formula. Thanks.
0
votes
1answer
26 views

excel formula to return value based on multiple criteria

I am looking for a formula that can search a table like the below and return on a different sheet a currency rate if i input the date. For example in a different excel i will put 2015.03.08 and i want ...
0
votes
1answer
21 views

I need the number in a cell to countdown when data is entered into other cells.

I'm making a sheet to keep track of the number of software licenses. In cell B1 I have the number 35 representing 35 licenses. As they are assigned to systems in cells C5-C40 I would like the total ...
0
votes
0answers
9 views

Is it possible to select an cell-defined range (such as September to December) from a set of data in Excel?

I am trying to create a spreadsheet in Excel that basically help me on counting my total daily allowance and takes account on leap years and number of user-defined "number of holidays" (where I don't ...
0
votes
2answers
25 views

Auto update Excel databse

I am using Excel 2007. I have an Excel file that has cell A1 showing a date and cell B1 showing an amount in sheet 1. I need to automatically update the date in A1 and amount B1 in a database in sheet ...
0
votes
1answer
20 views

Images gets distorted when copy/pasting between spreadsheets in Excel (Mac)

I have two spreadsheets with different row heights and cell widths. When I copy rows from spreadsheet #1 to spreadsheet #2 the images get distorted in an inconsistent manner (some end up just a few ...
0
votes
0answers
46 views

excel - how to count number of names in a column, name is specified in a cell

I have two worksheets, "Clients 2014" and "Receipts 2014". The receipts have client names for each row (each row is a receipt). The search key is in the "Clients 2014" worksheet. I want to ...