**0**

votes

**2**answers

24 views

### Excel formula for average daily profit

I have a table that has just two columns, Date and Profit:
Date Profit
24 - March 25.00
24 - March 19.85
25 - March 5.25
26 - March 6.36
26 - March 10.18
26 - ...

**0**

votes

**2**answers

9 views

### Excel macro: Last non-empty cell in a column

This is a followup question to this one.
The following formula can be used to find the value of the last non-empty cell in a column, in Microsoft Excel:
=LOOKUP(2,1/(A:A<>""),A:A)
My ...

**-2**

votes

**1**answer

12 views

### How to transfer spreadsheet to downsized spreadsheet

Can I copy an excel spreadsheet with 20 columns and paste into a template using only 8 of those columns with the column sizes slightly changed?

**0**

votes

**1**answer

13 views

### How do I prompt a user with file “Save As” dialog using a macro?

I created an Excel macro to replace data from "Quote" to "Invoice", but after running the macro, I wish for the macro to continue to run and stop at: "Save As..." mode so that the user can provide a ...

**0**

votes

**1**answer

24 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

**1**answer

17 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

**0**answers

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

**0**

votes

**0**answers

18 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

**1**answer

27 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

**1**answer

23 views

### Excel Daily Average Profit

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

**2**answers

32 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

**2**answers

23 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

**1**answer

15 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

**1**answer

37 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

**0**answers

22 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

**0**answers

22 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

**1**answer

23 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

**2**answers

40 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

**0**answers

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

**0**

votes

**1**answer

13 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

**1**answer

22 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

**1**answer

26 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

**1**answer

26 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

**1**answer

15 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

**1**answer

21 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

**1**answer

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

**0**

votes

**0**answers

24 views

### How do I stop excel duplicating values in VBA?

I run a code that groups same products together and total quantities of those products. However It only works if all items are filled in if not it duplicates. For example:
Instead of
Product 1 ...

**1**

vote

**1**answer

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

**-1**

votes

**0**answers

14 views

### Excel, printing copies with serial numbers [duplicate]

I am trying to print 100 copies of a worksheet with each copy having a unique serial number (1000-1100). I want the number to appear in cell K63. I have found similar questions answered with ...

**0**

votes

**3**answers

18 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

**2**answers

20 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

**2**answers

14 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

**2**answers

44 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

**0**answers

18 views

### MS Excel 2010 - Graphing Problems

I have an XY plot in Excel with some water level data, and I wanted to add a set of precipitation data as bars to help correlate changes in water level. However, there is no option to add dates for ...

**0**

votes

**1**answer

28 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

**2**answers

22 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

**1**answer

37 views

### Excel Issue in Conditional formatting

I need numbers to be assigned to variables and do conditional formatting.
Eg: 1a will be 1, 1b will be 2, 1c will be 3 etc.. So, in the whole excel sheet, wherever I type 1a, the value of that ...

**-1**

votes

**0**answers

13 views

### How can I graph a fermentation with 3 variables - using excel?

Need hours along the horizontal, specific gravity along the near vertical and pH along the far vertical...
Sandra

**0**

votes

**0**answers

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

**0**

votes

**0**answers

17 views

### Excel seems to have uninstalled itself, but viewer still works [on hold]

So about a month ago on a work computer, I turned it on and tried to use excel, but the file opened up in the viewer. I tried searching through the programs folder to find it and it doesn't seem to be ...

**-2**

votes

**1**answer

24 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

**1**answer

23 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

**1**answer

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

**-1**

votes

**0**answers

32 views

### Office 2013 Data Extraction from multiple workbooks [on hold]

I generate numerous time sheets for my client on a daily basis (varies from 6-12 daily) and usually work is performed at least 6 days a week. I need to populate the total number of hours (ST and OT) ...

**0**

votes

**3**answers

50 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

**1**answer

18 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

**0**answers

27 views

### software for fixing specific format

I have a document where I want to write a name of person, village, location, and area of property of that person on specific location on document. First I want to create that format and then I just ...

**0**

votes

**0**answers

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

**0**

votes

**0**answers

18 views

### Sum rows of a array function that outputs a matrix [Google Spreadsheet] [migrated]

I got a arrayfunction that is returning a matrix. I want to edit this to only return a vector, where this vector contains the sum of each row. I tried applying sum(), but that summed every element of ...

**1**

vote

**0**answers

30 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):
...