functions

Hi guys, I'm a manager at a company where we're not using utilising data enough to demonstrate the impact of the work we're doing. I'd like to do some excel training to develop skills that will help. I'm a fairly basic user that knows some formulas mainly around home finances. Autosum and...

Hi, I created two functions for cumulative total and percentage: CumulativeTotalDelivered:=CALCULATE([TotalItemsDelivered],FILTER(ALL(dCalenderDel),dCalenderDel[Date]<=MAX(dCalenderDel[Date])),VALUES(dCalenderDel[Date]))...

If I have in one drop down list(data validations) one thing how to connect with 2 or 3 more list. I know with Indirect functions but with that does not work(only works with one no more) Ty

Hi all!, Quick question: So im trying to create a financial model that uses the rand() and randbetween() functions to put in randomised growth rates for certain parameters for a company. Ive successfully set up the functions and output but i want to quick record the output each time I press F9...

As I understand it, the combin & permut functions only calculate the results without replacement. There are no corresponding functions for with replacement. Is that correct? The formula for permutations with replacement is just n^k, but the one for combinations is ugly: (n+k-1)!/k!(n-1)!. Do I...

Hi, I have a number of functions to calculate financial periods, rates, target dates etc. which I have in a single .bas file. These functions are used by a dozen macros and various users. My issue is that if I need to change a function, I have to replace the module in each of the macros and...

Greetings Alas I dont know my PMT's from my FV's in Excel. I seek an Excel Funtion Name and would be most oblidged if someone could identify it. The formula notation; to determine a Settlement figure, is I know the 2 Functions above are the same with differing inputs but what is the Name of...

hi, does anybody knows what is difference between TRUNC and ROUNDDOWN functions in excel? except optional or required for second argument

Hi, I created an Excel file with functions/formulas which I keep as a template which is cleared from raw data input. I want to implement the functions in other Excel files and make them work automatically right away. When inserting data input directly in the Excel template, all functions are...

Hi I can find some excel functions in WorksheetFunction object. Where can I find the other one? Thank you.

<tbody> Reference Result of Formula Dog 1 Dog 1 Cat 2 Cat 2 Cat 2 Horse 1 Sheep 2 Sheep 2 </tbody> Hi, I’m hoping someone can help me with writing a VBA code to create a function that converts a formula I use to an easier function, using existing Excel...

Hi, I need to sum up the repeated rows to a new table, like in the pic. never tried this before tried all kind of formulas but didnt succeed :-( should i even use functions? maybe PIVOT? VBA?? would much appreciate your help.

Hi I thought class WorksheetFunction has all excel functions inside but I just checked and noticed that Concatenate() function is not there. Where to find it? Is there any object in vba which All excel functions? Thank you for all your help.

Office 365/Excel 2016 I've started to see odd behavior in functions I add to Power Query. They work OK but are not showing up in ActiveWorkbook.Connections enumerations. Here is a simple function. (PO_Code as text) => let values = { {"BLKT", "Blanket"}, {"L", "Lease"}, {"PF"...

Hi all, Dying here (First thread yay), I am dealing with a lot of functions which uses different sheets for the same purpose so I had to define some sheet with a variable (not sure if I said it correctly I'm bad with the terms). tldr: Need to vlookup data from a defined sheet (and not by using...

There are 30 functions and each one is tied to revenue. So I know how much revenue is tied to each function. <tbody> Functions Revenue 1A $24.00 2A $54.00 3A $36.00 5A $23.00 8A $25.00 9A $42.00 11A $35.00 13A $75.00 1B $79.00 2B $6.00 3B $80.00 5B $7.00 6B $46.00...

There are 30 functions and each one is tied to revenue. So I know how much revenue is tied to each function. <tbody> Functions Revenue 1A $24.00 2A $54.00 3A $36.00 5A $23.00 8A $25.00 9A $42.00 11A $35.00 13A $75.00 1B $79.00 2B $6.00 3B $80.00 5B $7.00 6B $46.00...

I just started creating some functions, not sure why I ignored this functionality but they are really handy. I had a very simple one I figured I would just port over to the personal workbook and be able to use, but it seems functions are not as functional as macros, in that I can't access the...

I have some custom functions that I would like to be used in every excel file I open (if it isn't already in there). I know I can use my Personal Workbook to do this, but I frequently send/share spreadsheets with other people I work with and it is not feasible to copy the functions to...

Hello all, I created a simple macro with many columns, and it's used by different people with different number of rows. When there's only one data row filled, the macro cannot run, I get the debug error message. I assume it is because the macro pulls down all functions to every row as long as...