excel - Finding if a value is located in a range of cells in a corresponding column, to a row with the same value as a given cell in a given row -

-

given column contains directory paths, , column b contains actions on these paths; i'd resultant cell contain specific string if specific string located in column b (per column a).

granted can sort column, believe can use offset, know how locate ending index of cells can search range returned offset.

for example:

path                operation /share/admins       accessed /share/admins       removed /share/admins       added /share/admins       changed /share/network      accessed /shared/projects    accessed

in case, want search path unique value (in case /share/admins, /share/network, , /shared/projects), , given range in path, i'd search corresponding operation, , if operation matches removed, added, changed exists, i'd cell value write; , if values aren't found, "read".

in case, expect column (with header result) read:

path                operation       result /share/admins       accessed        write /share/admins       removed         write /share/admins       added           write /share/admins       changed         write /share/network      accessed        read /shared/projects    accessed        read

pardon seo: using compare varonis datadvantage reports 01.a.01 (user access logs) 04.j.01 (effective user permissions report). unfortunately, datadvantage doesn't feel need write reports correlate user activity records , file system permissions records.

you can use sumproduct. see screenshot.

=if(sumproduct((a:a=a1)*((b:b="removed")+(b:b="added")+(b:b="changed"))),"write","read")

enter image description here

or in shorter form:

=if(sumproduct((a:a=a1)*(b:b={"removed","added","changed"})),"write","read")

Comments

Post a Comment

Popular posts from this blog

Android : Making Listview full screen -

-
<linearlayout xmlns:android="http://schemas.android.com/apk/res/android" xmlns:tools="http://schemas.android.com/tools" android:layout_width="match_parent" android:layout_height="match_parent" android:orientation="vertical" tools:context=".mainactivity"> <edittext android:layout_margintop="5dp" android:layout_width="match_parent" android:layout_height="50dp" android:background="@drawable/location_edittext" android:id="@+id/locationeditext" android:textsize="15sp" android:textcolor="#999" android:paddingleft="15dp" /> <com.example.ravi_gupta.slider.viewpagercustomduration android:layout_width="wrap_content" android:layout_height="0dp" android:id="@+id/viewpager" android:scrollbarstyle="outsideoverlay" android:layout_weight="0.5...
Read more

javascript - Parse JSON from the body of the POST -

-
i'm using cameratag.com record video on website. service can send json response server can save data database. don't know how proceed here: the documentation states please note json repsonse passed in body of post , not form parameters. here example of how parse response in ruby: data = json.parse(request.raw_post) video_uuid = data["uuid"] but don't know how data on javascript. i'm not experienced in js please bare me :) post sample: { "uuid": "00012710-4b65-0131-ffe6-22000a499ea4", "camera_uuid": "98373a20-79ee-0130-3e42-1231390fcc11", "created_at": "2013-12-20t05:25:02.000z", "percent_complete": 100, "short_code": "kktb4q", "metadata": { }, "state": "published", "recorded_from": "http://singwho.com", "publish_type": null, "formats": [ { "name...
Read more

Automatically Create Database in Entity Framework 6 with Automatic Migrations Disabled -

-
i able automatically create new database, if not exist, using code-first ef6 automatic migrations disabled. if recall correctly, before automatic migrations existed in entity framework, worked fine. however, in ef6, receive following exception: an exception of type 'system.data.entity.migrations.infrastructure.automaticmigrationsdisabledexception' occurred in entityframework.dll not handled in user code additional information: unable update database match current model because there pending changes , automatic migration disabled. either write pending model changes code-based migration or enable automatic migration. set dbmigrationsconfiguration.automaticmigrationsenabled true enable automatic migration. to verify exception not caused external factor in production project, created new test project. however, same exception. for database context, have: public class mycontext : dbcontext { public dbset<entity> entities { get; set; } ...
Read more