Get instant live Excel expert help to learn how to use Small function in Excel

hello am trying to create a small school project, but am facing a problem, on my report page i have grades ranging from F9, P8... D1 and i have a comment table with 3 columns having comments for each, eg if a kid gets F9 i want my system to randomly pick from the comments.. like a kid gets 4 - F9s a kid can get Very Poor, the next F9. More Effort And the 3rd F9 Work More harder but my system only gives one comment ( Very Poor through out) so please help me on that

I have a 9x9 matrix of cells (C2:K10). Some have numbers in the cells others do not and are empty. I want create a macro that will allow me to set the text format and size of text (or numbers) in those cells, and to pre-set the format of the empty cells to another style and size. I can then clearly identify where the original numbers were, and where the numbers that were subsequently added are placed. I have created to two text formats I want to use and have called them simply “Large” and “Small” in the Styles list. I have been trying to use macros to do this but have found that I need to create an “IF” function which I cannot do by recording key strokes. One needs to edit the macro code which is in VBA and have not yet fathomed out how to use it. I would send you a file of my failed attempts but as the file contains macros your site rejects it. Please can you help

Ex_20 I have been provided with this code by another Support Person but when I try to run it as a macro in an Excel App using VBA code, it fails to recognise the active sheet range. When I start the macro another window opens entitled “GO TO” which seems to suggest to me that it does not recognise the 9x9 array of cells that the macro is supposed to be working on. I will copy to the screen the complete module when I submit this query. Below is a copy of my original problem. I have a 9x9 matrix of cells (C4:K12). Some have numbers in the cells others do not and are empty. I want create a macro that will allow me to set the text format and size of text (or numbers) in those cells, and to pre-set the format of the empty cells to another style and size. I can then clearly identify where the original numbers were, and where the numbers that were subsequently added are placed. I have created to two text formats I want to use and have called them simply Large and Small in the Styles list. I have been trying to use macros to do this but have found that I need to create an “IF” function which I cannot do by recording key strokes. One needs to edit the macro code which is in VBA and have not yet fathomed out how to use it. I would send you a file of my failed attempts but as the file contains macros your site rejects it. Please can you help

Hello--I created an excel form (not a UserForm), but have various macros including one that "submits" the excel document which generates an outlook email to the IT department of my company (VBA code below with the email address removed). I'd like to ensure that a small number of the cells are mandatory and have to be filled in before that submit button works. If those fields are not filled out, I'd like a message to pop up informing the user to fill in required fields. Thank you! Private Sub CommandButton2_Click() Dim OutLookApp As Object Dim OutLookMailItem As Object Dim myAttachments As Object Set OutLookApp = CreateObject("OutLook.application") Set OutLookMailItem = OutLookApp.CreateItem(0) Set myAttachments = OutLookMailItem.Attachments With OutLookMailItem .To = "MYEMAILADDRESS" .Subject = "FAD Bio Update Form" .Body = "Please update the attached FAD provider information." myAttachments.Add ActiveWorkbook.FullName '.send .Display End With Set OutLookMailItem = Nothing Set OutLookApp = Nothing End Sub

I need help understanding the following formula so i can use it. =IFERROR(INDEX(Sheet1!$A$2:$A$18,SMALL(IF(ISNUMBER(SEARCH($A$1,Sheet1!$A$2:$A$18)),ROW(Sheet1!$A$2:$A$18)-ROW(Sheet1!$A$2)+1),COLUMNS($N1:N1))),"")

I am trying to create pivot table excel 2010 for a small data set but when I select the pivot table function and get the create pivot table box, click ok, nothing happens

I have solved a problem here with someone but when i am implementing the formula on my excel 2016 professional i am getting error, There is a problem with the formula not trying to type the formula the formula i have written is same as provided by your support tech, and it is working fine on the above link i provided for google sheet.. so i am wondering why it is showing error on my excel installed on my laptop. The error is on this formula =INDEX(Sheet6!$D3:$D, SMALL(IF($B$3=Sheet6!E:E, ROW(Sheet6!E:E)-ROW($A$3)+1), ROW(1:1))) and i found the error is on array provided INDEX(Sheet6!$D3:$D as it is focusing on $D...so any solution pleaase

i have this formula in my invoicing sheet to check if my other sheet has value x then get the row =INDEX('Health Services'!$D$5:$D, SMALL(IF($A$1='Health Services'!C:C, ROW('Health Services'!C:C)-ROW($B$5)+1),ROW(1:1))) But i need to check one more thing that if such x value rows column k is empty so i am putting and condition but it is showing me an error ..please check that on sheet and discuss IF(AND($A$1='Health Services'!C:C, $A$2 ='Health Services'!K:K)

I have 4 columns: Last name, first name, department, shift List of 93 names with 9 different departments and two shifts (day, night) I want to list the names of each team on a separate sheet. =(INDEX($A$2:$D$93,SMALL(IF(($C$2:$C$93="SALES")*($D$2:$D$93="DAY"),ROW($A$2:$A$93)-MIN(ROW($A$2:$A$93)+1)),2))) I get #REF! error.

I need to create a small box in a cell that can be clicked on and an x or check mark can be put in automatically? To show that the project was completed. Also, once the box is checked it in a separate cell will add today's date. First request most important.