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. Also add the the specific version tag (e.g. [microsoft-excel-2019] or [microsoft-excel-365]) as features and functions may vary between them.
26,104
questions
0
votes
0
answers
43
views
Excel Sortby formula on alpha numerics e.g. A1 to A100 to return 4 rows of associated data
I have used this formula to sort the column A1 to A100 so that A
=SORTBY(A1:A206,COLUMN(INDIRECT(A1:A206)),1,ROW(INDIRECT(A1:A206)),1)
thanks to one of your posts: Advanced sorting of alphanumeric ...
0
votes
0
answers
20
views
Excel PowerQuery locking source file for Git
I am using PowerQuery in Excel to load a CSV config file.
= Csv.Document(File.Contents("myFile.csv"),[Delimiter=",", Columns=4, Encoding=1252, QuoteStyle=QuoteStyle.None])
This ...
0
votes
1
answer
62
views
Parse year only in excel spreadsheet [closed]
I wish to parse the “year” column which has various date formats as shown below and just leave the year only in the column,
13 march 1939,
October 1920,
December 10 1915
0
votes
1
answer
32
views
How do I sum a series or rows by a formula that considers two columns in excel
Im after a formula that can calulate the sum of an operation between two columns without creating another column.
e.g. Given the below table
Column Value
Column Percent 1
Column Percent 2
100
50%
80%...
0
votes
0
answers
54
views
Add total of Numbers from Multiple Sheets
I have 2 workbooks. One that one employee will use and one that another will use. On Workbook "A" they are scanning and logging when cars are brought into our garage. THey log the Car Number,...
0
votes
0
answers
28
views
ByVal target range returned is in unexpected format
The target.address variable that is passed, is $127:$127. In terms of range, what does it mean?
Private Sub Worksheet_Change(ByVal target As Excel.Range)
If r Is Nothing Then Set r = New Revenues
...
0
votes
1
answer
61
views
Vlookup inconsistence or confusion(?) using true range lookup
I want to make a commission that is within a certain percentage range. However, the results given are not matched, instead the grade is. Does it have anything to do with the percent value?
The ...
0
votes
0
answers
70
views
Multiple Slicers with Multiple Selection in each with AND condition in Power Bi
I am working on a model that filters items based on the criteria given in the slicers. In this I want to filter the item through three slicers
Hierarchy Slicer
Attribute Slicer
Attribute Value Slicer
...
0
votes
0
answers
53
views
How to debug corrupt Excel File?
I have an excel file and whenever i open it with the official microsoft excel i get an error/warning message like this:
We found a problem with some content in ’File.xlsx’. Do you want us to try to ...
0
votes
0
answers
51
views
Variable dice simulation total
I've created dice in Excel, but now I'm trying to calculate the value of the dice based on x amount of dice. ie if I want 3d6, it only pulls values of 3 dice instead of all 15. Would I use COUNTIF or ...
0
votes
1
answer
34
views
Excel Match Values Between Two Named Tables
I am struggling to find matches between two named tables in excel. Any help would be much appreciated please.
The scenario is:
I have two named tables in two different sheets of the same workbook. ...
1
vote
1
answer
24
views
SEARCH formula in Excel returns #VALUE! error
I have picked this apart but continue to get a VALUE error in Excel. Can anyone tell me what I am doing wrong? My sheet has a cell named "MaterialType" which is populated from a dropdown ...
0
votes
1
answer
38
views
How do I pull data into a new list separated by commas
What is a formula to pull the States of overlap in a list separated by commas like in this example?
iXcg.png
0
votes
0
answers
36
views
Excel cell center/middle alignment not truly center or middle
I have cells in Excel that, when I select center alignment, they are still slightly offset to the left of center. When I select middle vertical alignment, they are slightly offset to the bottom of ...
0
votes
0
answers
23
views
Can an Excel VB textbox be unlocked so the user can drag it around freely in a protected worksheet?
I'm writing a scheduling app in Excel for a testing center and the idea I had was to create textbox objects (VB objects, not Excel objects) of different heights that represent tests of different time ...