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

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

**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

**2**answers

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

**0**

votes

**1**answer

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

**2**

votes

**2**answers

52 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(...

**-1**

votes

**0**answers

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

**0**

votes

**1**answer

15 views

### Excel: Grading Formula to Omit Certain Cells

I have an excel sheet I've made for a class.
I have pre-filled in all of the assignments:
| A | B | C
|-------------------------------------------
1|Assignments |Points ...

**-1**

votes

**0**answers

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

**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

**0**answers

15 views

### Delete columns based on selection from a list box in Excel

I want to use Excel to delete columns from a worksheet based on the column header values that are seeded into a list box.

**0**

votes

**0**answers

35 views

### Conditional Formatting Wont Work

I created 4 conditional formatting rules and for some reason, only 3 of them work.
For all 4 of them, the rule type is set to "use a formula to determine which cells to format", as I want the whole ...

**-1**

votes

**0**answers

23 views

### How to display only data in a recap that meets certain criteria in Excel

I have a spreadsheet that contains individual tabs that are checklists for property inspections. Each item in the checklist gets a score of 1 – 4 and has comments. I want to create a “Remediation Plan”...

**0**

votes

**0**answers

23 views

### How can I get the exact position of bold words in a cell?

I have two cells (let"s say A1 and B1) with same content, but not same formatting (borders, size, background, etc.)
I need to have the same bold words in the two cells.
But I don't want to change any ...

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

**0**

votes

**1**answer

15 views

### Excel euro negative numbers

I have the custom cell with the below formatting
_-[$€-x-euro2] * #,##0.00_-;-[$€-x-euro2] * #,##0.00_-;_-[$€-x-euro2] * "-"??_-;_-@_-
How to show negative number inside brackets ?

**0**

votes

**1**answer

36 views

### How to generate a splatter chart in Excel?

I am trying to get a chart for the following.
I have different groups -- Fiance, HR , IT, Maintenance -- and for each one, I have on the X axis a pick list of choices to show interest (very low, ...

**0**

votes

**2**answers

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

**1**

vote

**0**answers

27 views

### Cloud or In-house [closed]

I am assigned a task to find a way to reduce the computing cost. We are using AWS at the moment.
The work we do involves a lot of calculation in excel spreadsheets using VBA modules. The result will ...

**1**

vote

**1**answer

40 views

### Tortoise svn diff for excel files

I was pleasantly surprised to find that Tortoise svn diff lets me find the diff between two excel files. The cell which is different is highlighted in red. It works for small excel files.
But I have ...

**1**

vote

**1**answer

46 views

### Combining Data From Rows into Columns, Excel 2016

So, In column A, I have a lot of repeating typeId's, with different data in columns C/D. I would like to take any row that has a duplicate typeID, take the data in column C/D and move it to the next ...

**1**

vote

**1**answer

24 views

### Copy multiple cells from workbook a to workbook b keeping keeping the exact reference to the cell

I am building a catalog I have all data and costing listed in workbook1. Now I need to reference workbook2 the customer catalog, back to workbook1 so all data only needs to be updated in one place. ...

**0**

votes

**1**answer

60 views

### Excel vlookup not working

I am using a Mac.
I have 3 categories of ZIP Codes, Zone 1, Zone 2 and Zone 3. I have a list of ZIP Codes and I need to see easily if a zip code is zone 1, 2 or 3.
Column E holds my ZIP Code. ...

**1**

vote

**1**answer

17 views

### Trouble using getpivotdata with different dimensions, Vertical and Horizontal

I am trying to use getpivotdata, but not sure how to get the formula working properly. I need to have the critera of business date, Name, and then base it on my headers and return the numbered area in ...

**0**

votes

**0**answers

28 views

### Find duplicates within group in excel

Say I have a spreadsheet with the following:
RoadIDs | Order
0 0
0 0
0 0
0 0
0 0
0 0
0 1
0 2
1 1
I'd want to ...

**0**

votes

**1**answer

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

**-2**

votes

**0**answers

32 views

### How to display a value in cents as dollars (without fraction) by using only cell formatting, not formulas

The question is same as this one, but 950 cents should be displayed as 9, while keeping original 950 as cell value.
Let's say I have an integer value of 950 (representing 950 cents) in cell A1 in ...

**-2**

votes

**0**answers

25 views

### Name cells based on adjacent cells [closed]

I need help with the following:
If the cell above is named the same, the cell to the right will be named "Level 1" if not "Level 2". Now if it is "Level 2" all of the cells below with the same name ...

**2**

votes

**0**answers

20 views

### Excel for Mac conditional formatting not working (at all)

My Conditional Formatting button stopped working (MacBook Air, MacOS Mojave 10.14.2, Excel 2016). This is true for existing files with the formatting done previously, and new files. None of them are ...

**-1**

votes

**1**answer

15 views

### Excel: New Powerquery from Web (csv) doesnt work

I want to build a worksheet where the user can input a Stock symbol and the balance sheet is automatically downloaded from morningstar to a table, and then some custom formulas are run on the data.
...

**1**

vote

**0**answers

20 views

### MS Excel Filter Chart Data Labels not updating with filter

I have a large table of data containing my x-axis data, a column of dates, a column of numbers, and a column of data labels. I have setup a pivot chart where the date is the filter and the data all ...

**0**

votes

**1**answer

18 views

### Add a CountIF to a SumProduct Formula

In a previous question, Scott gave me this great formula to sum all the sales from salespeople who saw an increase in sales from 2017 to 2018:
=SUMPRODUCT(C2:C9-B2:B9, --(C2:C9>B2:B9), --(B2:B9>...

**0**

votes

**1**answer

52 views

### Excel formula matching sheet1 and sheet2 and getting result

Can someone please help on Excel formula:
I have a spredsheet With two sheets.
In sheet1 I have two column
In sheet2 I have tree column.
I want two column from sheet1 to match With two column in ...

**-1**

votes

**1**answer

22 views

### Merging data from multiple files

So in my case I have multiple Linux VM's and each one of them there is a file called
output.txt (or other extension like excel?). They look like:
Average download time:8647
Average whatever : 153
...

**0**

votes

**0**answers

12 views

### How can I reload an Excel spreadsheet using a different encoding?

Someone shared an Excel file with me (.xlsx, not .csv). Looking at the data in Excel it's obvious that the file is encoded using UTF-8, but Excel is interpreting the data as Windows 1252 encoded text. ...

**0**

votes

**0**answers

27 views

### Closing COMAddin login window when excel is opened from batch file

I am opening an Excel (.xlsm) workbook using a .bat file.
@echo off
pushd \\Network123\Folder123\
"Retrieve.xlsm"
Note: I need to open the file using command line as the macros I need to use are in ...

**1**

vote

**3**answers

56 views

### How to count cells if it contains a value in Excel

I have an Excel sheet like this:
ID | Relations
----+----------------
1 | ,
2 | ,
3 | ,1,
4 | ,1,2,
5 | ,2,
6 | ,3,
7 | ,1,2,4,
8 | ,1,2,4,5,6,
9 | ,2,4,5,1,
I want to count ...

**0**

votes

**0**answers

22 views

### Why doesn't this MacScript return a valuable on Excel

I have the following VBA Script
Dim fileName As String
fileName = MacScript("choose file name")
MsgBox fileName
✅ If I run the AppleScript in Script Editor, and select a pre-existing file, a path is ...

**-1**

votes

**1**answer

39 views

### How do I find all the “independent variables” in Excel's maps?

I make a lot of maps in Excel, which works great. However, often I use county-level data and it happens that some regions/counties show "no data". It is very hard manually to find out which counties (...

**1**

vote

**0**answers

19 views

### BeforeDoubleClick on Protected Cell

I wrote some code that manipulates the target cell when it is double-clicked by the user. The code works fine for most cells on the worksheet.
But the worksheet is protected (only unlocked cells ...

**3**

votes

**2**answers

152 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**

vote

**1**answer

14 views

### Cell joining, bracketing, and rounding in one excel formula

I am trying to combine three functions in one formula that will achieve the following:
Join columns C & D
Put parentheses () around column D value
Round column D to one decimal place
I can ...

**0**

votes

**1**answer

27 views

### How to Add a 2nd Criteria to an Index Match Formula?

I know this has been asked before, but I'm not able to make sense of other people's examples.
Here is a formula I have that works:
=INDEX('[AL DOE.xlsx]DOE'!$E$2:$E$5000,MATCH(LARGE('[AL DOE.xlsx]...

**0**

votes

**1**answer

37 views

### how to subtract previous cell containing number in excel

I have an Excel table like this and want to get RESULT(subtracting row numbers of cells which contain 1). I have thousands of rows so I need a formula.
ROW NMB Value RESULT
1 0
2 ...

**0**

votes

**0**answers

28 views

### Reconciling differences when data repeats in a sheet

In the example data, say we have Company 1 and Company 2. Under each company is the state in which employees work, followed by the name of the employee(s) which work(s) in that state. In the column ...

**1**

vote

**1**answer

26 views

### Excel removes blank lines when saving in csv format

I have an Excel file with blank lines at the start. When I save as a CSV file from within Excel, the blank lines are being removed from the saved CSV file, but the Excel view of the file, i.e. ...

**1**

vote

**5**answers

64 views

### Excel VLOOKUP by 2 columns

I have issue with VLOOKUP function.
Here is my sheets:
sheet1
id_1 id_2 count
28273 15 5
31866 19 4
2827 315 5
...
sheet2
id_1 id_2 count
2827 315 155
141 1064 555
...
Basically, I ...

**0**

votes

**0**answers

20 views

### Cross validation in Excel

I am trying to create a spreadsheet to record ICT issues in excel.
Column C has a list of categories e.g. Application / Hardware / Report / Infrastructure etc.
If Application is selected from list in ...

**0**

votes

**0**answers

17 views

### Excel Crashing Because of Deleted Macros

I hope I can get some help here.
I have an Excel book that I've used Get & Transform queries to manipulate my data. I wrote a macro to ensure all queries and pivots were updated in a specific ...

**0**

votes

**1**answer

29 views

### Trouble with INDIRECT formula [closed]

This is my formula:
=IF(ActualsThrough<F$5,SUMIF('209Budget'!$F:$F,'209ActBud'!$C7,'209Budget'!I:I),-IFERROR(OFFSET('Month TB'!$D$1,MATCH($C7&+"-"&+$C$2,'Month TB'!$B:$B,0)-1,MATCH(F$5,'...

**0**

votes

**1**answer

49 views

### Complicated 'IF' function in Excel

In Sheet 1, I have the following:
If the Due Date is after the Date Submitted, then I want the value in column D of this sheet to be the Detail Status, which is on Sheet 2,
UNLESS the Detail Status ...