functions

Hi I understand Worksheet.copy and what is used for. But to my surprise, I see Worksheets the collection has a functions called copy ,move and delete as well. What are these for? Thank you.

Good Morning Task: Color set of cells, and then sum cells in active column, based on background of cell, then output to specific location. I found a set of functions that allow me to Count and Sum Cells, based on Color. I have set up the functions and confirmed they work separately...

I'm sure this has come up before (multiple times), and I did search via google (as recommended) but all I could find was functions that would determine Max/Min from a Range of Cells, and that's not what I need. If someone could even point me to a pertinent thread, that'd be great (but please...

Hi, Trying to retrieve the number of months between the two dates below. Dates are generated through functions beneath. 2019-01-01 A1=DATEVALUE(YEAR(TODAY())&"-01") 2019-04-01 B1=EDATE(DATEVALUE(MID($C$12;18;4)&"-"&MID($C$12;23;2));1) =DATEDIF(A1;B1;"M") does not work, returns "1900-01-03"...

Hi I just want to clear the confusion I have about vba functions vs WorksheetFunction. Please correct me if I am wrong: All VBA functions are listed here: https://www.techonthenet.com/excel/formulas/index_vba.php All excel functions (without vba, like open sheet and type = then function name)...

I have Dim MyDict As Dictionary at the top of a module so that it can be used by multiple functions. How do I enable the values in MyDict to remain in memory when I use MyDict.Add appAccess.currentproject.Name, appAccess so that I can use the values in MyDict in separate functions within...

Hello Trying to create an achievement outcome workbook for students in a debating competition. I believe I need nested formula which produces Average, Good or Fantastic outcome based on multiple conditions. Condition #1 - a validation List of student class Levels - F1,F2,T1,T2,E1,E2,E3,M...

Hi Inspired by this post https://www.mrexcel.com/forum/excel-questions/1090951-vba-excel-final-piece-puzzle-hopefully-removing-formulas-not-converting-table.html I tried my own code to get rid of all functions in the the whole sheet and replace them with the value but it did not work. Any help...

Hi, I am trying to create an IF Function that looks at 8 columns of data and if there is a "Y" on any row the functions returns a date. EXAMPLE: DATA. <colgroup><col width="64" style="width: 48pt;" span="10"> <tbody> Date Days Since Date Extra New Old Super New Not New...

Hello all, Can someone correct the below formula please? Message I get is The formula you typed contains and error. =IF(AND($P$6="F1",=IF(T15>$AH$13,$AJ$12,IF(AND($P$6="F1",IF(T15>$AF$13,$AH$12,IF(AND($P$6="F1",IF(T15=$AL$12,"",$AF$12))) Maybe I need different functions?

Hello - Thanks for your time. I have a question on what formulas/ideas I could use to achieve the following. I'm working on a Forecast model that has multiple tabs. These tabs represent the different functions in my company (IT, Risk, Marketing, etc). On each of these tabs I have identical...

I need to process a column of random numbers, and do certain things with them, depending on their size. It is for some writing I am doing. Here is an example : 0.592437095 0.986644999 0.698993662 0.299869473 0.175831087 0.081866617 0.840500143 0.31014318 0.989504965 0.169993951 I want to...

This is the formula that i have right now. =If(COUNTIF(M2:W2<6),"Rejected","Accepted") I can't seem to get it can anyone help me. What i am looking for is a formula that counts a range of cells that have numbers ranging from 1-10. Is there a way to have if m2:w2 is less than six to say it is...

Hi, I'm trying to use iferror, arrayformula and vlookup functions together.. This is the formula I've used =iferror(arrayformula(VLOOKUP(D2:D,'Full Org'!J2:K1000,2,0)),"Chennai") If the vlookup didnt fetch any value, it should display Chennai. Here, the problem is I need to add one more check...

I have searched this forum for a while and cannot find how to make the following array formula work over multiple sheets. I do not know if it is even possible. =MAX(IF(--($A3='FY18+ Reqs'!$B$2:$B$851000)*--("shipped"='FY18+ Reqs'!$F$2:$F$851000)*--(""<>'FY18+ Reqs'!$I$2:$I$851000),--('FY18+...

Hi Why datedif() is hidden function? are they other functions hidden? Thank you very much.

Hello, I've got a question regarding extracting multiple values. I'm well aware of vlookup and other frequently used functions but I need your advice for this one. Let's say there are teachers and we want to match their subjects they teach at school using pre-existing subject key codes...

Hello, I've got a question regarding extracting multiple values. I'm well aware of vlookup and other frequently used functions but I need your advice for this one. Let's say there are teachers and we want to match their subjects they teach at school using pre-existing subject key codes...

This is not a typical question thread, although I hope it may be of interest to those who play around with Excel for fun. It's somewhat in line with the "Tough Problem" series that ran a few years ago in this forum. People with spare time and interest might read on. With the advent of the new...

Hi All... I need the correlation table to be completely fill out so that I can ADD the full columns to do a few functions. Is there a way to copy and transpose the numbers over? Thxs