Copy cells based on values ​​in another cell

In Google Sheets, I try to copy the B2: B4 cells according to the values ​​of the other C2: C4 cells.
For example – example.xlsx created in Excel.

But stuck and can not find a solution on how to do it in Google Sheets.

enter the description of the image here

I will be very grateful for the help!

google sheets – How to return values ​​in a formula, from the rows of the last 4 non-consecutive registered dates

Using a ARRAY_CONSTRAIN formula we want capture the last 9 records (rows) over a period of non-consecutive dates.

= ARRAY_CONSTRAIN (sort (vlookup (request ({row (EBPP! D: D), for example), sort (EBPP !!: A: E)}, Q15,0),
{row (EBPP! D: D), sort (EBPP! A: E)}, {2,3,4,5,6}, 0), 4,0), R8,5)

Points to consider:

  • Cell Q15 holds the query
  • Cell R8 will hold the part we need for the dates.

Please have a look at the picture.

the last 9 records

Why does the 4-bit binary code only have 10 possible values ​​instead of $ 2 ^ 4 $?











There are 10, why not $ 2 ^ 4 $?

php – htaccess rewrite URL 2 get values

Enable mod_rewrite and .htaccess via httpd.conf then put this code in your .htaccess

# Active mod_rewrite
RewriteEngine On
RewriteBase /

RewriteRule ^ list of products-nokia- ([0-9]+) /? $ /search-result.php?p_id=$1 [L,QSA,NC]
RewriteRule ^ category / list of products-nokia- ([0-9]+) /? $ /show-subcategories.php?cat_id=$1 [L,QSA,NC]
RewriteRule ^ category / subcategory / list of products-nokia- ([0-9]+) /? $ /show-childcategories.php?sub_cat_id=$1 [L,QSA,NC]

RewriteRule ^ list of products-nokia- ([0-9]+) /? $ /search-result.php?p_id=$1 [L,QSA,NC]

RewriteRule ^ category / list of products-nokia- ([0-9]+) /? $ /show-subcategories.php?cat_id=$1 [L,QSA,NC]

RewriteRule ^ category / subcategory / list of products-nokia- ([0-9]+) /? $ /show-childcategories.php?sub_cat_id=$1 [L,QSA,NC]

python – selects the maximum and minimum values ​​in a list with sublists

Hello, I have the following arrangement and I want to select the maximum and minimum value of this arrangement. How can I do it?

ytra01 =[array([1.18182126307657e-125, -0.0119506376551417, -0.0238653670087153,
-0.0357093641553568, -0.0474489881673787, -0.0590517810947708,
-0.0704864679651997, -0.0817229567840087, -0.0927323385342183,
-0.103486887176526, -0.113960059649305, -0.124126495868608,
-0.133962018728162, -0.143443634099373, -0.152549530831321,
-0.161259080750767, -0.169552838662145, -0.177412542347568,
-0.184821112566827, -0.191762653057386, -0.198222450534390,
-0.204186974690659, -0.209643878196690, -0.214581996700658,
-0.218991348828412, -0.222863136183482, -0.226189743347072,
-0.228964737878063, -0.231182870313016, -0.232840074166164,
-0.233933465929421, -0.234461345072376, -0.234423194042295,
-0.233819678264123, -0.232652646140478, -0.230925129051658,
-0.228641341355637, -0.225806680388066, -0.222427726462272,
-0.218512242869262, -0.214069175877715, -0.209108654733991,
-0.203641991662125, -0.197681681863830, -0.191241403518495,
-0.184336017783187, -0.176981568792647, -0.169195283659298,
-0.160995572473234, -0.152402028302231, -0.143435427191739,
-0.134117728164886, -0.124472073222477, -0.114522787342993,
-0.104295378482593, -0.0938165375751110, -0.0831141385320608,
-0.0722172382426312, -0.0611560765736884, -0.0499620763697752,
-0.0386678434531117, -0.0273071666235948, -0.0159150176587985,
-0.00452755131397313, 0.00681789467795345, 0.0180827996063767,
0.0292274597830153, 0.0402109885419106, 0.0509913162394275,
0.0615251902542539, 0.0717681749874005, 0.0816746518622012,
0.0911978193243132, 0.100289692841717, 0.108901104904715,
0.116981705025934, 0.124479959740323, 0.131343152605155,
0.137517384200026, 0.142947572126853, 0.147577451009879,
0.151349572495669, 0.154205305253110, 0.156084834973414,
0.156927164370114, 0.156670113179067, 0.155250318158455,
0.152603233088780, 0.148663128772868, 0.143363093035869,
0.136635030725257, 0.128409663710825, 0.118616530884694,
0.107183988161304, 0.0940392084774217, 0.0791081817921341,
0.0623157150868521, 0.0435854323653106, 0.0228397746535661,
-3.25260651745651e-16], dtype = object),
board ([1.18182126307657e-125, -0.0249772674435424, -0.0519907845042112,
-0.0809050263018950, -0.111586833911836, -0.143905414364630,
-0.177732340646228, -0.212941551697932, -0.249409352416401,
-0.287014413653646, -0.325637772217032, -0.365162830869278,
-0.405475358328457, -0.446463489267996, -0.488017724316676,
-0.530030930058630, -0.572398339033347, -0.615017549735669,
-0.657788526615792, -0.700613600079266, -0.743397466486994,
-0.786047188155233, -0.828472193355595, -0.870584276315045,
-0.912297597215901, -0.953528682195836, -0.994196423347878,
-1.03422207872041, -1.07352927231715, -1.11204399409721,
-1.14969459997501, -1.18641181182037, -1.22212871745841,
-1.25678077066966, -1.29030579118996, -1.32264396471053,
-1.35373784287793, -1.38353234329408, -1.41197474951625,
-1.43901471105707, -1.46460424338452, -1.48869772792194,
-1.51125191204800, -1.53222590909676, -1.55158119835760,
-1.56928162507529, -1.58529340044991, -1.59958510163693,
-1.61212767174716, -1.62289441984676, -1.63186102095725,
-1.63900551605550, -1.64430831207375, -1.64775218189956,
-1.64932226437588, -1.64900606430099, -1.64679345242853,
-1.64267666546750, -1.63665030608224, -1.62871134289246,
-1.61885911047322, -1.60709530935493, -1.59342400602335,
-1.57785163291959, -1.56038698844014, -1.54104123693682,
-1.51982790871680, -1.49676290004262, -1.47186447313217,
-1.44515325615869, -1.41665224325077, -1.38638679449237,
-1.35438463592278, -1.32067585953667, -1.28529292328403,
-1.24827065107025, -1.20964623275603, -1.16945922415744,
-1.12775154704592, -1.08456748914824, -1.03995370414653,
-0.993959211678288, -0.946635397336348, -0.898036012668906,
-0.848217175179511, -0.797237368327065, -0.745157441525825,
-0.692040610145400, -0.637952455510755, -0.582960924902207,
-0.527136331555429, -0.470551354661445, -0.413281039366636,
-0.355402796772732, -0.296996403936824, -0.238144003871350,
-0.178930105544105, -0.119441583878238, -0.0597676797522508,
-6.50521303491303e-16], type = object)]I should throw the values ​​0,1569 (maximum) and -1,649 minimum, but the correct values ​​are not indicated

float (max (ytra01, key = lambda x: x[2])[0])
float (min (ytra01, key = lambda x: x[2])[0])
I appreciate your help

2013 – Loading files in the SharePoint library and reference to an Excel file to populate the column values

I am brand new in SharePoint. I've been tasked with developing a SharePoint site that will make it easier to find documents and organize them better than they currently are on our network drives. I'm now trying to set up a library of specifications.

there is:

  • Characteristics
  • Standard Specifications Exceptions
  • Exceptions of non-standard specification

Non-standard specification exceptions are also divided into 4 regions where the same exemption file name may have different content.

Initially, I had the intention of downloading everything in a library and using different views to display the information. But after reading another question, it seems like a better library is for each other.

In the end, I'll probably have about 3,000 +/- documents to download. They will be a mix of PDF, XML, DOC and DWG. Each file will have a unique name. Some of the file formats will be:

DK 001A820.XML
DK 100F08M.xml
OPSS 0202.pdf
OPSS 0304.pdf
SSP 101F23.xml
SSP 102S05.xml
MTOD 0101.0700.dwg
MTOD 0202.0400.dwg
OPSD 0100.0100.dwg
OPSD 0100.0110.dwg
SSD 0002.0001.dwg
SSD 0005.0002.dwg

Currently, each of the types defined by the first 3-4 characters is in its own directory. In addition, each directory has an Excel file that contains an index. All of which are similar, but the column names, number, and position may vary slightly from one index to another.

An example of an index would look like this:

enter the description of the image here

On the basis of this table, I know that SSD 0002.0001.dwg is titled:

Structural structure of layering of standard drawings

And that his status is:


Although I can drag 100 files at a time and manually go into the library and fill in the column information for each file, it is time consuming.

Is there a way to download the files and get the correct column information from the index file?

As a follow-up question, is there a better way to proceed? Previously, I had just created a hyperlink formula in each index linked to the file on the network drive.

No idea what to label this as being either a help with that would be appreciated.

8 – How to push the values ​​of attached views in Javascript?

I have a table view with both exposed filters and filters, and another view associated with it uses views_aggregator_plus to display a summary of the months and numbers of different values.

I want the attachment to be viewed in order to attach the ChartJs script to the page view and make sure that another loop function loops through the lines of the HTML table attachments to extract the data while separating each column in its own table.

It works well, I'm not sure. I do not feel good.
Would not it be better for me to pass the values ​​of the view directly to the script than to do it by the browser?

I'm not sure how to do it, but I've found the necessary values ​​in hook_view_post_render under $ view-> plugin_ style-> render_fields ..

How to proceed from there? Or maybe there is a totally different and better way to achieve the same goal?

thank you,

javascript – Count duration values

What you mean by "functional" is not really clear.

The use of reduce is clever and well done, but it sounds like a cult program of cargo. The realization that many loop actions can be represented in terms of reduce (fold, aggregate, etc.) is important to functional programming, but it should not be more your first choice than a while loop.

The fact that it is commented is not necessarily a problem. he suggests that you could fail at a general goal:

Write what you mean.

One of the things that make functional programming is that it helps us do it.
Javascript has limited tools for directly declaring lists. What you mean to do is to declare a dictionary of all duration Values ​​up to the number of the source array filtered by the respective duration. Or better yet, you can use a grouping function.

You can bring a library for the task, which can be a good idea, or you can compromise a little bit.

getCounts function (elements, key) {
Let c = {};
to (leave the elements element) {
c[key(item)] = items.filter (function (i) {
return key (i) === key (article);
returns c;
count = getCounts (duration, function (i) {return i['duration']; }) & # 39;

You will notice that it is quite inefficient. We could reduce waste, but it would be less concise.

plot – how to "cache" the values ​​of the functions to be passed to ListPlot?

I have a function that is very expensive to run. I would like to draw the function for a certain range, but it is time to let Plot simply calculate the function for many values ​​as he sees fit.

Instead, I call the function for a range of values, and then call ListPlot with the {x, y} pairs produced. However, I would like to refine the plot by calling the function multiple times for areas of interest and then updating the ListPlot. I do not know what is the best way to do it, or even how to do it.

My first thought was to create a SparseArray, then I could enter more values ​​as they were calculated. But SpareArray requires an entire index and my x values ​​are real. I can not use the memo either, because I need a quick and easy way to spit out all the {x, y} values ​​I've calculated so far, and I do not think it's There is an easy way to get this from a list of manuals. F[x]= y assignments.

Google sheet, COUNT UNIQUE values ​​per group ONLY IF NOT already counted in the previous group

I hope to clearly explain what I'm trying to do.

I have data in column B, grouped as shown in column A.

I would like to count the unique values ​​for each group in column A, ignoring the unique values ​​already counted in the previous groups.

For example, I would like:

  • to count unique values ​​in "proyecto2 & # 39; not to mention the unique values ​​already present in & # 39; proyecto1 & # 39 ;.
  • to count the unique values ​​in 'proyecto3 & # 39; not to mention the unique values ​​already present in & # 39; proyecto1 & # 39; and & # 39; proyecto2 & # 39 ;.
  • to count unique values ​​in 'proyecto4 & # 39; not to mention the unique values ​​already present in & # 39; proyecto1 & # 39 ;, & # 39; proyecto2 & # 39; and & # 39; proyecto3 & # 39 ;.
  • etc …

You will find below a Google file containing the solution that I found, even if I'm not very happy, to easily show what I mean.

Basically, in column A: B, we have the input data. You can add data in columns A and B to see how it works (my method, for the moment, only works if you add one of these groups in column A: 'proyecto1 & # 39; ,, "Proyecto2", "proyecto3", "proyecto4", "proyecto5" and "proyecto6").

In column D: E, we have the output data, essentially the unique values ​​counted by group.

In column G: W, the formula for processing the data.

It is clear that my method works up to "proyecto6" because in the "treatment columns", I only take into account the formula until "proyecto6".

Everything works but my question is: can you suggest a more dynamic way of achieving what I am trying to do? Or the only way is to write code?

Thank you so much,