User Profile

oteixeira62

Copper Contributor

Joined Jan 14, 2023

25 Posts1 LikeLikes received

View All Badges

User Widgets

Recent Discussions

Re: UNIQUE + FILTER functions returning more results than expected
SergeiBaklan I gave up from accessing Microsoft Store. I think it is an absurd situation. Used a free text editor (Notepad ++). It may be not so bright but it does the job quite well. For someone interested: https://tipsmake.com/how-to-create-an-excel-formula-in-notepad- Thank You. Octavio
Feb 14, 2023 Place Excel
2.6KViews
0likes
1Comment
Re: UNIQUE + FILTER functions returning more results than expected
SergeiBaklan I believe you. I just don't understand why there has to be an admin on my account. I don't belong to any organization and I bought the product for my own use... Thanks anyway for you patiece. I will try to find a solution because it seems a really nice app. Octavio
Feb 13, 2023 Place Excel
2.6KViews
0likes
3Comments
Re: UNIQUE + FILTER functions returning more results than expected
SergeiBaklan No chance, I have a fully version of Microsoft 365. Do not understand why I cannot have a simple (free) add-in...
Feb 13, 2023 Place Excel
2.6KViews
0likes
5Comments
Re: UNIQUE + FILTER functions returning more results than expected
SergeiBaklan Hello Sergei and thank You. This seems to be nice but I cannot install it...Do you have an idea on how to overcome this? It seems I cannot have add-ins from MIcrosoft (this one is free)....
Feb 13, 2023 Place Excel
2.6KViews
0likes
7Comments
Re: SUM using FILTER should return empty
Patrick2788 Ah! I should have known, it is not a SUM... Thanks a million, Octávio
Feb 09, 2023 Place Excel
1KViews
0likes
1Comment
Re: Excel IMAGE function returns #CONNECT
Hello and thank You. Yes, using youk link, IMAGE function works and OneDrive links are not useful. So this means that your image is located somewhere else... May You let me know where?...
Feb 09, 2023 Place Excel
3.1KViews
0likes
1Comment
SUM using FILTER should return empty
Hello to all, I am uploading a file in which I believe the formula I entered should return EMPTY instead of 1. Can I be doing something wrong? Many thanks for any help, Octavio
Solved
Feb 09, 2023 Place Excel
excel
1.1KViews
0likes
3Comments
Re: Set cell value to item value of data validation list
Thank You
Feb 07, 2023 Place Excel
5.8KViews
0likes
0Comments
Re: Set cell value to item value of data validation list
Thanks a lot, Hans, it works perfectly, as usually, Octavio
Feb 07, 2023 Place Excel
5.9KViews
0likes
0Comments
Re: Set cell value to item value of data validation list
mathetes Hello, So would you be willing to back up and describe in normal vocabulary (i.e., not in Excel language) Let's assume that users know that they have to open a container to choose an object from there. As there are several containers and they are all closed they won't know which one to open to perform their task. Opening the container and showing what's in it avoids questions and speeds up the process. You have to see this situation from the point of view of the user with little experience and knowledge of Excel. They know how to press buttons and other objects and expect everything to work perfectly without having to perform extra tasks. From my point of view, every time the type of validation changes in a cell, it should be updated and show the available values, but perhaps this is not technically possible. Thanks, Octavio
Feb 07, 2023 Place Excel
5.9KViews
0likes
2Comments
Re: Set cell value to item value of data validation list
Hans, cannot test now but I will ill let You know. Many thanks for time and patience. Octavio
Feb 06, 2023 Place Excel
5.9KViews
0likes
0Comments
Re: Set cell value to item value of data validation list
mathetes Do you know a solution for this not using vba? If you do please let me know which is it. If such solution existed do you think I will spend my time re-inventing the wheel...
Feb 06, 2023 Place Excel
6.1KViews
0likes
4Comments
Re: Set cell value to item value of data validation list
mathetes Hello Mathetes, Yes, this involves a macro. For a better understanding I am uploading a self.explanatory file. Hope someone can give a hand. Many thanks, Octavio
Feb 06, 2023 Place Excel
6.2KViews
0likes
9Comments
Set cell value to item value of data validation list
Hello to all, I have this piece of code: Public Sub mudaval() If Range("K2").Value = "Por mercado" Then Range("E4").Select With Range("E4") With Selection .Validation.Delete .Validation.Add Type:=xlValidateList, Formula1:="=CTRYS_MOV_ANO" End With .ClearContents End With End If End Sub How can I add the lines to set cell E4 value to the first(or other) value of the "CTRYS_MOV_ANO list? Many thanks, Octavio
Solved
Feb 06, 2023 Place Excel
Macros and VBA
6.9KViews
0likes
11Comments
Excel IMAGE function returns #CONNECT
Hello to all, I have this image on OneDrive and shared it with no restrictions: https://1drv.ms/u/s!AqaFWn73EcQBgaUCVXsp2ChBPw3IkA?e=FDn2eA When using it in this formula I get #CONNECT! in return. =IMAGE("https://1drv.ms/u/s!AqaFWn73EcQBgaUCVXsp2ChBPw3IkA?e=FDn2eA") I believe it has to do with some validation but googled around and found no answers. Is this normal behaviour or is it possible to get the image on the spreadsheet like it happens for the examples given on the IMAGE function help? Many thanks for any kind help, Octavio
Feb 06, 2023 Place Excel
excel
3.3KViews
0likes
3Comments
Re: Update (refresh) cell after programatically change the data validation
Hello Hans, I posted before reading your last advice. It is quite a good solution. Many thanks for your help. Octavio
Feb 05, 2023 Place Excel
3.7KViews
0likes
0Comments
Re: Update (refresh) cell after programatically change the data validation
Hello Hans, No, they do not see the new list. The cell still shows the value of previous/validation (or selection). Only by clicking the cell the new values get available. Octavio
Feb 05, 2023 Place Excel
4KViews
0likes
2Comments
Update (refresh) cell after programatically change the data validation
Hello to all, I have the following lines of code that work fine in setting up a new validation type for cell E4. Range("E4").Select With Selection.Validation .Delete .Add Type:=xlValidateList, Formula1:="=CTRYS_MOV_ANO" End With The code changes the validation but is not visible to user. Is there a way to force the cell to show the new data validation? Many thanks for any kind help. Octavio
Solved
Feb 05, 2023 Place Excel
Macros and VBA
4.3KViews
0likes
4Comments
Re: UNIQUE + FILTER functions returning more results than expected
SergeiBaklan Thank You Sergei Sumproduct allways has a bracket problem. For me, at least...
Jan 31, 2023 Place Excel
2.7KViews
1like
9Comments
UNIQUE + FILTER functions returning more results than expected
Hello to all, I am attaching a file which I think is self-explanatory. I am filtering a table data by using two cell parameters but I am getting more results than expected. Can someone please give me a hand on this? Many thanks, Octavio
Solved
Jan 31, 2023 Place Excel
excel
3KViews
0likes
11Comments

Recent Blog Articles

No content to show