Search results

Is there any criteria using which you are marking those cells as Green? If there is a specific criteria then, you can use that criteria along with Countifs function to get the value in C7, E7, G7 and I7

Agree with Deepak. There is no formula driven way of counting the cells based on the interior color. You might be using some criteria, using which you are highlighting those cells in Red color, use the same criteria in COUNTIF or COUNTIFS functions to count the cells

I have done this using a user defined function in excel Dim cell As Range Dim colorcount As Integer Function retColorcodeCount(rng As Range, colorcell As Range) colorcount = 0 For Each cell In rng.Cells If cell.Interior.Color = colorcell.Interior.Color Then...

Hey Adam, Not sure why and how.. when I opened your worksheet on my computer and run the formula it evaluated fine. Please check if the Formulas => Calc mode is set to auto on you Excel application.. I'm here by sharing the file, where the formula got evaluated correct. Thanks, Ram

Here is the updated file..

Hi Emeng, The only issue, I have noticed in the above code is, you are trying to assign a value to a variable using set keyword, which is not required..hence you are receiving this error.. Try replace the following piece of code: Set myVLookupResult =...

Is there a typo again in your code pasted previously.. The code given by you is: Worksheet("Sheet1").Range("A53").Formula ="=MATCH(A52,AM6:AM50,0)" The correct code is: Worksheets("Sheet1").Range("A53").Formula ="=MATCH(A52,AM6:AM50,0)" please check the above and let us know..

You can use Application.OnTime() method of VBA..but in order to have this method executed, you need to have that workbook where this code is written is in opened or using the Task Scheduler of windows open the file at specific interval and call the method to execute your code under the...

One way you can achieve this is by typing in the character small l i.e. the alphabet L in lower case and change the font name to Wingdings You can change the font color and create a hyperlink etc on this text.. Hope that helps!!

Hi, The reason why you are getting this error is because your listbox is populated with the data using the Rowsource property.. To update the information on the listbox, you need to update the data available on the source worksheet .. Also when you have duplicate name values in the source...

Here is the numerical summary of your data:

Hi, This seems to be that you are trying to perform multiple linear regression on your data ... Here are the answers: 1. I have computed the MEAN, MEDIAN, MAXIMUM and MINIMUM. Kindly confirm if I got the formulas right? Ans: Yes. These are calculated correctly. I have cross checked the same...

See the attached file.. hope that helps!! Please refer to sheet 2 for the calculations...

I have take the help of : For skipping the error: On Error Resume Next See the attached hope it helps..

see if this helps..

Only other suggestion i can give here is, copy the formula using formula bar and edit the destination cell and paste it.. If the above still does not answer your query, you can help me with the screenshot or sample file where this issue can be noticed..

Hello Neeraj, Refer to the following URL to get an understanding on Cell referencing in formula's that helps in addressing this issue: https://www.gcflearnfree.org/excel2016/relative-and-absolute-cell-references/1/ Thanks, Ramesh

Hi Neeraj, On the find and replace dialog box, try changing the LookIn option to Values..default value is set to Formulas..hence it is not finding the same.. Click on Options >> button to expand this dialog box Hope this helps

Hello Thomas, Not sure how can we get those A's and P's using a pivot table.. I have updated your file with a Summary worksheet where I have populated the values using Index & Match formulas.. On the source data..I have added 2 columns one contains the year and 2nd contains the concatenation...

True Brian..as the cell address has been placed in the double quotes, it would not follow the automatic cell reference update practices (absolute / relative / mixed) when you copy/paste the formula..tht's the only trouble you have to experience :)

you can use the following formula in cell B5 =INDIRECT(A5&"!G21") The same is applicable for the next one too

see if this helps..

Here is how this template has been designed.. I have created drop down lists on Companies list worksheet (I have highlighted these in yellow color) using dynamic named ranges created in Lookup worksheet One you select the sector, the corresponding Region names populated, Once the region is...

see if the attached file helps..

Here you go.. Sub Consoldiate() 'Please add a reference for "Microsoft Scripting Runtime" 'By clicking on Tools => References, scroll down to select the above library 'Variable decleration Dim fd As Folder Dim fsoobj As Scripting.FileSystemObject Dim file As file...