Filter by merged cells in Google Sheets?

You can try the following

            ArrayFormula(vlookup(ROW(1:21),{IF(LEN(A1:A21)>0,ROW(1:21),""),A1:A21},2)) >= DATE(2020, 10, 30))

enter image description here

What we do is create a virtual column for column A.

(Try the partial formula by itself and see how it behaves.)

How can i store camlquery results to filter and delete that i don’t need?

I just want to change the result of camlquery. But i dont know how to store them and filter it. The query is now turning many values that i dont need. I want to drop them and show them in a view. So, how can i manipulate this camlquery results?

Equipment question – what in a lens name denotes when the filter mount moves during focusing?

“Internal focusing” is the term for that and it is rather common. Certainly a lot more so than “internal zooming” which makes a lens bulkier for transport and thus is comparatively rare for large zoom ranges. Off the cuff I remember the Panasonic DMC-FZ50 as a superzoom camera with both internal focusing and zooming.

To have either action “internal”, the position of the front lens group cannot significantly involved in the zooming or focusing action. Since macro lenses are focusing at very short distances (while having a much larger focusing range than a “normal” lens with additional closeup lens at the front would have), sacrificing space in front of a principal focusing group by adding a non-focusing group may be particularly unwanted, so they are a slightly more likely candidate for non-internal focusing.

sidebar – Expandable active filter list – user flow

Currently, I try to implement active filters list to a fixed side filter bar. When the user will scroll through data always will be able to preview the active filter list without having to scroll to the top of the landing page. The issue appears when the user chooses many filters and the list starts to be really long. To simplify the preview of the side filter bar we decided to limit the amount of data to 4 rows – this way user learns that such a section exists and it’s able to expand the list to preview all active filters. My concern is – what if the user will expand the active filters view and decides to close it afterward. What’s the best user flow? Close it at all or return to the initial state when the user is able to preview a few rows of active filters? My thinking is that if the user closes the active filters then he’s not interested in seeing them anymore and the opened section will cause a scrollable side filter bar which can decrease its usability…Does anyone have some suggestions regarding good user flow? Additionally, it would mean that this element might have 3 different states. I’m just concerned if that’s an appropriate approach? enter image description hereenter image description here enter image description here

list – I want to filter the the returned results of camlquery one more time and show it in listview?

So i have a value that called unitnames .
And i cannot search this value with <Eq> keyword, because one data column have semicolons.
But i cannot search it with <Contains> because it returns many results that i dont need.
So, i cannot find the appropriate query to to that.

I thought creating a query with <Contains> and eliminating what I searched for from the returned results. How can I do that ? If I can do this with the proper camlquery, that will be useful too.

     private string myCAML(){       

    string strunitnames="Unit1"


    tempqueryBuilder.Append("<FieldRef Name="Unitnames" />");

    tempqueryBuilder.Append("<Value Type="Text">" + strunitnames+ "</Value>");



    tempqueryBuilder.Remove(0, tempqueryBuilder.Length);

    return tempqueryBuilder.ToString();


string camlQuery = myCAML(); // creates camlquery with function

                    using (SPSite site = new SPSite(SPContext.Current.Web.Url))


                        using (SPWeb web = site.OpenWeb())


                            SPList list = web.Lists.GetList(new Guid("1B0B62A2-5FA8-85CB-847B-EE5E54451D12"), false);


                            web.AllowUnsafeUpdates = true;

                            SPListItemCollection coll = list.Items;

                            listViewWP.Visible = true;

                            listViewWP.ListName = list.ID.ToString("B").ToUpper();

                            listViewWP.ListId = list.ID;

                            listViewWP.BorderStyle = System.Web.UI.WebControls.BorderStyle.None;


                            SPView view = list.Views("myView");

                            view.Query = camlQuery;



                            listViewWP.ViewGuid = view.ID.ToString("B").ToUpper();

                            web.AllowUnsafeUpdates = false;



7 – Filter Content and Files using the same Taxonomy term filter in Search API

I have several File (File Entity) and Content (nodes) types both referencing the same Topic taxonomy using the same field (one field, reused). The contents of these files/content are indexed in the same index using Search API (multi-type index). I also have a view that lists down the contents of that index, showing a mixed list of files and content.

Now what I’d like to do is filter the results by the Topic taxonomy using only one dropdown filter, e.g. If I want to find files and content related to “Science”, I would just select “Science” from the Topic filter, and the view will show all the files and content related to “Science”.

The problem is that when I add a filter to the view, Drupal presents two filter options for Topic, one for the Topic field on the File entity and another for the Topic field on the Content entity – not just one filter. I’ve already tried Combined Filters, but that doesn’t give me a dropdown of Topics. Also hit a dead end on Search API aggregated fields.

How does one filter a view of both files and content by just one taxonomy filter?

gui design – Which button is better when you want to load results from a filter?

Let’ take them one by one and analyze the rationale behind each button label. Keep in mind that they need to be short, clear and inform the user exactly what is going to happen:

Search – most common search button label and a safe option to use in this situation.

Update – Less common and not advisable in my experience. Update button is mostly used when changing a setting or when editing a shopping cart.

Go – Go where? Nope.

Reload – Confusing.. Reloading the page? Reloading the search filters?

Apply – This is the one I would go with. You are basically applying the filters to the results list. I would even go with Apply filters.

Load Results – From my experience, I haven’t seen this label in a while. It sounds antiquated and not UX friendly.

magento2 – Filter products based on location

I have a Magento2 Store where I have multiple location. for (eg. Jaipur, Delhi, Mumbai etc).

I want to show products based on location. (Product A is available for one location only, Product B available for all locations).

If user select location Jaipur then only display products available for that location.

Locations may increase in future.

So keeping scalability and future customization how can I achieve it?


spam filter – Mimecast Email Security – Data Flow/Retention

Stack Exchange Network

Stack Exchange network consists of 176 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

input formats – Cannot enable PHP Filter module in a fresh Drupal 7 installation

In order to test my ISP (, I created a simple website running Drupal version 7.74 (the latest from the 7 branch) on a subdomain. It is a standard installation, with no additional modules nor themes.

Then I tried to enable the PHP filter module. When clicking Save configuration, the admin/modules page reloads without giving any message and without enabling the module, which remains off. I can turn other modules on and off as expected, but not the PHP filter. Other features are apparently OK.

What could be the problem?

The website is this. I can provide the Admin password if someone wants to check it.

PS. I did this test after having problems with PHP code on my sites, as described here. A2’s support team was unable to help.