Search results

It works very fine Thank You very much for your help

Hi I'm using Excel 2019. Please see the Table below. I need to calculate a sequence number based on a date range, returning a structure like "yy0000". I did use the COUNTIFS function, but it seems that it doesn't work with decimal part number. It only consider the integer part, so when exists...

Hi I´m using forecast sheet sometimes to some ponctual tasks. Now I have a table that is updated everyweek, but I can´t update forecast because range values (col B) are dynamic. TIMELINE VALUES FORECAST LOWER CONF BOUND UPPER CONF BOUND 17/03/2023 619 24/03/2023 774...

Thank you very much. It works perfectly :)

Hi I have a table similar to this: 91071 1 12345,12357,12386 91071 2 12361,12362 94075 1 23145,23156,23188 94080 1 32512 94080 2 36981,45678,445521 94080 3 47188,25896,98765 And I want to transform it in this: 91071 1 12345 91071 1 12357 91071 1 12386 91071 2 12361...

Hi I've tried ... .Worksheets(i).Cells.Copy With .Worksheets(i).Activate .DisplayZeros=False End With Still gives error, I'm doing this wrong I guess

Hello Looking for a code to (a fast) create new workbook with selected sheets from an existing workbook, I found this: Public Sub Save_Last_3_Sheets() Dim newWb As Workbook Dim newXlsxFullName As String Dim p As Long, i As Long Dim sheetName As String Dim currentWb As...

It seems that apparently webbrowser setup with maps is not available. I'm googling for an answer or a piece of code and nothing solves my issue. Some of search results are old and for Office 2007, 2010 and 2013. I work with office 2019 and 365. Maybe a compatibility problem?

Hi Any ideas? Is this funcionality not available anymore?

Hi I have a userform in which I want to setup a webbrowser pointing to google maps and Lat/long reference. This userform manages data from about 4000 clients/locations, so when it's open we can navigate through clients data e show treir location in a map. I'm using the code: Private Sub...

Thank You very much. Great (and simple) solution!!!! So blind looking for VBA or formulae options, I never considered PQ. I think we can setup autorefresh in query properties...

Hi As shown in the attached file, I need to convert TABLE1, which is a dynamic table (that is filled automatically from various source data tables), in TABLE2, sorted by Site and ignoring zero values or blank cells. I would like to get some help, formula or VBA, since I'm stucked...

Found the solution :) =COUNTIFS([COD],[@COD],[DATE],">"&[@DATE])+COUNTIFS(C$3:C3,[@COD],B$3:B3,[@DATE]) ?

Hi I wonder how this formula works: =COUNTIFS(C$3:C$137,C3,B$3:B$137,">"&B3)+COUNTIFS(C$3:C3,C3,B$3:B3,B3) in a table: =COUNTIFS([COD],[@COD],[DATE],">"&[@DATE])+COUNTIFS([COD],[@COD],[DATE],[@DATE]) ? How to block C$3 or B$3?

Hi Thank you for your response. But I still have an issue: =COUNTIFS(C$3:C$137,C3,B$3:B$137,">"&B3)+COUNTIFS(C$3:C3,C3,B$3:B3,B3) How do I represent the red ranges above in a table (as shown in the attached), since the formula appears like this...

Hi I'm stucked with this issue: I have a table data and I need to rank data based on date criteria for each code (see attached file please). Using =COUNTIFS([COD];[@COD];[DATE];">"&[@DATE])+1 returns rank 1,1,1,4,4,6,... and what I want is 1,2,3,4,5,6,... what's the change in formula to avoid...

@Excel Wizard Your soluction runs perfect :). Thank you very much. I did some atempts with frequency function but not with MATCH together. @p45cal Thank you for your approaches. However i think you've done solution 1 with O365 functions (_xlfn.UNIQUE _xlfn._xlws.FILTER) I'm still working with...

Hi Thank you for the quick response. Your formula returns '#NAME?'. I think you used a O365 function (_xlfn.UNIQUE). Unfortunally, my version is EXCEL2019, as I have mentioned in first post

Hi Hope you're all going well :) I'm trying to get distinct values using TextJoin function, no sucess. Please see file example attached: My formula in K8...

Thank you very much for your help. It's a very good approach, but I had something different in mind (may be my explanation was wrong). Instead labels, I would like to apply format conditional to the marks. Is that possible?

Thank You very much for this new approach. I will adopt it :) In fact, it works better and more stable than formulae.

Hi I'm running Excel 2019 I wonder if is it possible to apply conditional format to milestones in a timeline chart. I attached a sample created over a template I took from chandoo.org and it is similar to my own file Thank you in advance for your time

Sorry for the late answer A simple detail that makes all the difference, in front of my eyes :( Thank you very much for the correction. It works fine.

It´s the method I know to extract distinct values from a source. Is there another way to do that? How do I exclude the cell above?

Hello Do you mean the array formulas, right? any alternatives?