All Questions
Tagged with microsoft-excel worksheet-function
7,317
questions
0
votes
0
answers
44
views
How do I use XLOOKUP
I am trying to use XLOOKUP but not sure what I need to put in the last two prompts (have read that they are not a necessity so what shall I populate with a 0?)
0
votes
1
answer
69
views
Combining two formulas together into one formula
I was wondering if anyone knew how to join these two formulas together so they will work and accomplish all that is needed in one cell? Both formulas work separately but I need them to work together ...
1
vote
1
answer
51
views
Calculating total pay when hourly rates are different after 40 hours worked
I am trying to calculate the total pay based on hours worked. The rates are €12 for the first 40 hours, €15 for each overtime hour.
I have made the following sheet:
The hours worked are formatted as ...
0
votes
1
answer
41
views
Excel lookup/match bug - can find given but not calculated value, even if they're the same
I'm experiencing a very odd behaviour with Excel lookups and match: if I try a lookup or match for 7.03, it will find a cell, but if I lookup 7.02+0.01, it fails. For example:
A
B
1
7.01
a
2
7.02
b
...
0
votes
1
answer
76
views
Excel XIRR: first value is small or zero returns odd value
I'm trying to calculate the XIRR of a large (>200) number of investments, each of which has a set of values associated with dates. For some of the investments, the first date in the table is the ...
0
votes
1
answer
82
views
What would be the the mathematical equivalent of this excel formula? =PPMT() and =IPMT()
To calculate the EMI we have a formula called PMT() and we know the internal formula as well as mentioned in What would be the the mathematical equivalent of this excel formula? =PMT() but I also need ...
0
votes
0
answers
36
views
In Excel, what function can I use to find certain instances in a column of data?
Is there a function I can use that will search the contents of a column and either let me jump to each cell that contains a value more than a certain constant or give me a list of all cell addresses ...
0
votes
1
answer
30
views
Complicated filter excel formula
I am trying to create a filter that can filter one column for one word and a different column with a different word so that it will only pull up Column A word that also matches with Column B's word. I&...
0
votes
0
answers
66
views
Need Help Migrating A Drop Down List From One Workbook To Another
I need some help migrating a drop down list and the data selected from that list to another workbook.
I have a list of people that need to be contacted each week, with an updated file that is sent to ...
-2
votes
2
answers
103
views
Excel function for filtering a list of substrings to include & exclude
Excel function where if any row values in column A include a keyword from the list in column D but does not include a keyword from the list in column E, write True, otherwise, write nothing/keep it ...
0
votes
0
answers
90
views
Excel Index(Small(IF Issue
I'm looking to improve a formulas. The formula is:
=IFERROR(INDEX(IndexColumn,SMALL(IF(MilestoneColumn=TODAY(),ROW(MilestoneColumn)-ROW(MilestoneColumnFirstCellLocked)+1),ROWS(...
0
votes
0
answers
94
views
Excel XLOOKUP with Wildcards - Functionality Change
I'm playing with XLOOKUP with wildcards (Match_Mode 2). I believe it used to be if you want it to return results where a item in that excel it was = =XLOOKUP(""&"Text"&&...
0
votes
3
answers
151
views
Double XLOOKUP in Excel
I have an Excel-workbook containing two sheets:
One sheet contains the names of students with their evaluation
And a second sheet containing the "mappings" between the criteria and the ...
0
votes
1
answer
65
views
Fill in missing data from date series in Excel
I have a set of data that looks like this when imported:
I would like two transformations:
Missing dates filled in to ensure all dates between the start and end dates are accounted for. Note the ...
0
votes
1
answer
42
views
Excel: Worksheet.Calculate causes UDF to run infinitely
I have written a udf returns an array that is inserted at the cell location.
the udf can be long running as it reaches out to a rest service to fetch data from a database. so i added a button on my ...