# Questions tagged [microsoft-excel]

A spreadsheet application by Microsoft. Use this tag along with [vba] if your question involves programming Excel in VBA, and with [worksheet-function] if it involves an Excel formula or worksheet function.

**6**

votes

**2**answers

11k views

### Excel create table with all combinations

Let's assume I have 3 columns with labels
A B C D
a b c d e
1 2 3 4 5 6 7 8 9 10
Is there a quick and easy way to create an empty table with all permutations? i.e.
A - a - 1
A - a - 2
....
D - e ...

**0**

votes

**1**answer

3k views

### Excel - value of the last changed cell in row

I hope someone can help, I have a number of cells in a row which is filled automatically by another application, I need to read the last changed value in that row into one cell. I know I can create ...

**-1**

votes

**0**answers

11 views

### Create a bar graph in excel expressing total money spent between multiple people [on hold]

I have two columns of data I would like to make a table for.
One column has money spent and the second column is the name of the person. The table has duplicate entries for each person with each row ...

**0**

votes

**2**answers

10 views

### In excel how can I sum all the cells above the current cell upto a particular cell

What formula should I apply to add all the cells above the current cell but only up to a cell with a particular text.
Like in case of the below example the formula adds all cells above it but only up ...

**0**

votes

**2**answers

8 views

### How can I expand Excel datasets that have formulas attached?

I'm trying to work with some relatively simple datasets in Excel, but I realized that I don't know how to expand them properly.
See the image below for reference:
If I wanted to add a USER E or ...

**-1**

votes

**1**answer

27 views

### How can I make Excel visually update cells?

I am using Excel 2016. I have a small spreadsheet that is exhibiting some unusual display problems.
When I recalculate a range, which includes all cells on the sheet with content or formulas, two ...

**0**

votes

**2**answers

39 views

### Combine multiple row into one, keeping columns data

I have the following type of table
Current table
P.no. P.Line ian feb mar apr mai iun iul aug sept oct nov dec
100001 Line1 100 ...

**-1**

votes

**1**answer

26 views

### Is excel good for data storage and analysis?

About a year ago I decided to store some personal information in excel file (weight, daily step count, blood pressure, books read, tasks completed, ...). Every row is one day and it's getting ...

**2**

votes

**1**answer

3k views

### vlookup in a cell that contains mid formula

I am trying to create a vlookup in a cell referencing a specific cell so that I can pull the data from my lookup table. Well this cell that I am referencing happens to have a mid formula in it, and ...

**0**

votes

**1**answer

3k views

### PowerShell Excel search replace issue with loop

What I'm doing here is to search excel sheet for a value, if value matches it will be replaced by first value in a given text file:
example:
search for value text find the first instance replace ...

**1**

vote

**1**answer

2k views

### Excel Values Require Enter within Cell to recognize as number

I have a worksheet where I am getting direct output from STATA that has a weird character format that included " =[ number ]". I put in a new column to strip the characters and leave the numbers. ...

**3**

votes

**2**answers

144 views

### Generate all possible permutations given input values

Please note my question is different from the suggested duplicate. The suggested duplicate does not show all possible variations based on the number of options, so an input of 3 can have a variation ...

**-1**

votes

**0**answers

28 views

### VBA check existing file timestamp on network

I don't know how or where to start & Excel VBA MsgBox doesn't help me at all.
My employer has a shared excel file that multiple people access & use on a network & saving has become an ...

**0**

votes

**0**answers

10 views

### Excel VBA Code Works with F8 but not When Run [on hold]

I've researched this problem and have not found any situation similar to mine.
Goal of the Macro is Insert an Embedded Picture into an Embedded Chart. Code does this by:
Copying the Picture
Adding ...

**0**

votes

**2**answers

3k views

### How to insert rows value automatically based on another cell value

At first, please look this excel worksheet:
The month table contains whole year data. If I select any month from the table by typing or by selecting from drop down menu (e.g "Selected") then only ...

**0**

votes

**0**answers

16 views

### Excel to PDF - number turns to symbol

When I save as PDF or print my excel to PDF the 1 in my date changes to a symbol. How do I stop this from happening. Pictures below to show what i'm talking about. I'm using excel 2016 and adobe ...

**1**

vote

**1**answer

23k views

### Formula to update cell based on user changing another cell's content

I want to know if there is a formula to update a cell in Excel with today's date
when a user changes any value in the row that contains that cell
OR
when a user changes the value of 6 / 7 / 8 ...

**0**

votes

**1**answer

5k views

### How to find first date after given date in a sorted column

I have two columns of sorted dates in Excel. Given a date in column 1, how do I find the first date in column 2 after the given date?

**0**

votes

**1**answer

3k views

### Merge rows and join matching values

I have two sets of data on the first set there is one column that has a list of IDs like below.
I have another set which could have several rows matching that same ID like below
I am trying to get ...

**0**

votes

**0**answers

11 views

### Creating Excel Financial model

I have created a model that calculates the monthly cost of a property and would like to return the annual cost in a table below it. What function would you use to return an annual value that could ...

**-1**

votes

**0**answers

34 views

### Running two VBA procedures in Excel

Can someone tell me how to combine and run both of these in the same Excel worksheet? Please be specific since I am a neophyte at coding!! Thanks
This procedure:
Private Sub Worksheet_Change(ByVal ...

**0**

votes

**1**answer

3k views

### Sum based on drop-down list in Excel

I have this table and I would like to sum the amount from the drop down list.
Lets say I have few categories from my drop down menu (column L) and on column P I would like to have the amount I ...

**0**

votes

**1**answer

3k views

### How to assign values to text fields for sum and average

I have 7 columns (E:K) of "Pass/Fail" results. I need to assign a value of "1" for the "Pass" result in 4 (E,F,I,K) of the columns and "2" for the other 3 (G, H,J) columns, along with a "0" for all of ...

**0**

votes

**0**answers

11 views

### Displaying a different value in referenced cell

Have two tables in same worksheet, table 1 has a value of 14 in cell C36 and I made cell T24=C36 in Table 2, the value in T24 displayed is 9... any reason why this would happen?
both cells are ...

**3**

votes

**3**answers

3k views

### Mail Merge function in Word 2010

I have this Excel file that has multiple sheets that I wish to import to Microsoft Word's letter format.
Firstly I started mail merge to this excel file and selected this particular sheet/table, then ...

**1**

vote

**1**answer

32 views

### How to increase speed of code using data structures rather than for-next loops?

I have already resolved several others using Application.Index with Application.WorksheetFunction.Match and reduced time to perform from about 7-8 seconds to milliseconds. But I feel there is still ...

**42**

votes

**5**answers

237k views

### How do you customize Excel 2010 keyboard shortcuts?

How do you customize Excel 2010 keyboard shortcuts? This article from microsoft.com provides instructions for "Microsoft Office 2010" but seems only apply to Word, not Excel.
http://www.microsoft....

**0**

votes

**0**answers

15 views

### How to convert range of image file path from local folder as comment in the selected destination range?

I'm asking for your help. My research ended up in 2 different macros that combined will give a good utility for my work.
This VBA code will insert image as comment.
This VBA code will fetch ...

**0**

votes

**0**answers

18 views

### Why does Excel say “there's [an issue] with the clipboard”?

I had to paraphrase the error from Excel because Superuser doesn't allow "problem" in the title, which is a bit amusing in this case. The actual error, as I'm sure anyone who uses Excel is aware, is ...

**2**

votes

**2**answers

4k views

### How can a calendar control be removed in excel

I've added a few ActiveX calendar controls and now can't remove them. The calendars won't select so that I can remove them. You can see from the video how I've went to design view and tried to select ...

**-2**

votes

**0**answers

40 views

### Need help to write VBA [on hold]

I am new to VBA and don't know how to wright it. I have spreadsheet that needs to be converted to the different format. I used the "IF' formula it gave me the result but it didn't completely did what ...

**0**

votes

**2**answers

3k views

### how to insert a helper column?

I have an excel spreadsheet where each data set covers three rows. I want to sort the data based on the value in column K, which is in the third row of each data set, there are no values in rows 1 ...

**0**

votes

**1**answer

23 views

### Hiding row if there is data in all cells of a row

I've searched high and low but couldn't find an answer to fit my issue. I was wondering if someone could help me figure out a code for..
If all cells in a row contain data then hide the row; if there ...

**1**

vote

**1**answer

1k views

### Excel - disallow formatting locked cells, allow formatting unlocked cells

When i lock cells in excel
How can i prevent users from editing the background color, text color, bold text etc in cells that are locked.
But allow them to change background color etc in cells that ...

**2**

votes

**1**answer

3k views

### How do I fix a long delay in Excel 2016?

I just bought a new computer (Lenovo ThinkPad E560 with Solid State Drive and Intel Core i5 processor) with Windows 7 and the local version of Office 2016 (NOT Office 365). I have noticed when using ...

**0**

votes

**1**answer

23 views

### Excel - INDEX MATCH MATCH with a twist

I'm trying to assist some local firefighters make a crewing display page on their excel roster. Their roster is setup with dates from 1st January -> 31st December vertically in column A with the ...

**0**

votes

**3**answers

3k views

### In excel, I need to compare the “rank” value of items in two sheets, and print the original rank in the new sheet

I've got two reports, pulled in as separate sheets in one excel file. This is the approach I came up with, but I don't know how to implement it:
For each cell in column "merchant_name" in sheet 1, ...

**-1**

votes

**0**answers

23 views

### Has Excel updated their Times New Roman font?

The symbol ∧ (unicode 22c0) does not work with Times New Roman Font in MS Excel for Mac 2013. But it works in MS Word for Mac. The symbol's stats in other encoding formats can be found here:
http://...

**0**

votes

**1**answer

12 views

### Update Excel object embedded in Word document when opened

I have an Excel sheet embedded in a Word document, this object was created from Word and no xlsx file exist for it.
There is only one cell and it has a random number formula that returns a new number ...

**1**

vote

**1**answer

3k 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

12 views

### When I copy data from Qt-Creator to Excel, the tabs are turned into spaces

I am using Qt-Creator to edit a file which contains lines of tab delineated data, and I have white-space rendering turned on in Qt-Creator, so I can see the tabs. When I copy this data into an excel ...

**0**

votes

**2**answers

54 views

### Advanced F&R Regex - Sheets / Excel - If “X” is in cell A1 and add “Y” to cell B1

I am looking for a formula or regex that I can use to find a value in a string in one cell and if found add another string to the adjacent cell in another column.
For example, I have a list of ...

**0**

votes

**1**answer

17 views

### Conditional formatting for merged cells

I have these two rules for a set of cells:
The full formulas are
=$AB27=""
and
=LOWER($AB27)=ok
I thought this would make it so that if "ok" (with any capitalization) was entered into the the ...

**2**

votes

**2**answers

51 views

### Split cell content into multiple separate rows in Excel

Suppose in A1 cell I have some comma separated letters.
content(A1 cell) = A, W, L, F
I would like to the following result:
content(A2 cell) = A
content(A3 cell) = W
content(A4 cell) = L
content(...

**0**

votes

**1**answer

32 views

### Percentage calculation formula

I have two questions and I just can't figure it out. I have trying to calculate 3% into a base rate.
$28.54 + 3% = $29.40
The goal really would be to do:
$29.40 - 3% = $28.54
However, when I do ...

**0**

votes

**0**answers

15 views

### update sheets to master sheet

How to update a Excel spreadsheet from a master that I would be changing data on periodically. I would like to update the Master with newer formulas and data. when I go to a folder and open up the ...

**0**

votes

**1**answer

3k views

### Excel VBA - Getting “Object Required” Error When Stating Range Is Not Null

Below is my code where I'm getting the error. I've marked the line that the error occurs on in bold (i.e. ** at the beginning and end of the line **).
The specific part of the code I'm receiving ...

**1**

vote

**0**answers

28 views

### Microsoft Office Tools- permanently remove author name

I am having some trouble with Microsoft Office tools, I want to permanently remove the author name from all future created documents.
Word, Excel, etc, keep pulling my computer login username (Lets ...

**0**

votes

**3**answers

42 views

### Simple Array Formula in Excel not comparing the right values

I'm trying to calculate with an Array Formula (in Cell D2) what i'm calculating in cell D11. The issue i'm having is that it appears my Array Formula is not evaluating the inputted array one-by-one. ...

**-1**

votes

**0**answers

31 views

### Formula not Working After Date 12 for every month

I came through a very weird issue. In Image1 You can see I am converting Column B to TEXT in a specific format in Column D. And in Column E I am getting the Time Hour Value. (Ref - Image 1)
But my ...