Hello Riste Chaushev, It is not a Change but a Calculate that must be used. Test with this : Private Sub Worksheet_Calculate() Dim target As ...
Hi Bandi Maha. Here is an example based on what I understand. I work with 4 named ranges, two cascading validation lists and an INDEX formula to...
Hi, Shardul Nikam, As you can see, the problem only occurs for the first 12 days of the month. This is normal because this is when there could be a do...
Hi DIPAK UNDHAD, I think we need more information to respond effectively to this demand. OK, there is a comparison to be made but then what should ...
Hi Nehal Halai, This is a very good question but the solution may be different depending on your data, the structure of your file. Could you attach a...
Hi Katherine, Another way : =IF(RIGHT(A5,LEN(A5)-1)+0<=16,6,7) If you want to retrieve all the characters of a cell except the first one, yo...
Hi James Austine, There are several ways to do this. Do you already have a file so that we know how your data is arranged?
With a small adaptation of the Purfleet code 😉 ... LastRow = Range("B1").End(xlDown).Row Sheets("MAIN SEARCH").Range("B2:B" & LastRow).C...
Hi Nitin Shukla, Here is a solution BR, Lionel
Hi Reehan Saeed, I also think that the Pivot Table is the best solution. Using formulas of this type is - sooner or later - going to have problems; re...
Hello Aye, I' m joining you the file with a formula. Warning, it' s a matrix formula to be validated with CTRL SHIFT ENTER.
Hi Bob, I opened your file in which there was already a macro. So I did the same thing (Mod_Sorting). I put the file with the macro. What does the ...
And with Power Query (For the first two months).
Hi Aye, Here is a possibility with formula. BR, Lionel