The tag has no wiki summary.

learn more… | top users | synonyms

1
vote
0answers
14 views

Where does the calculation take place? [on hold]

In Google spreadsheets, I have quite a big amount of relatively complex array formulas in many cells. That takes ages to complete calculating. Does the speed of calculation depend on my PC ...
0
votes
1answer
31 views

How to lookup a value and return multiple unique values (remove duplicates) to a single cell - comma separated

I am trying to take a value (unique id) from column AC, do a lookup in column (B) and return (meaning concatenate) the multiple unique values from an adjacent column (C) to a single cell in column AD. ...
0
votes
0answers
18 views

Sum rows of a array function that outputs a matrix [Google Spreadsheet] [migrated]

I got a arrayfunction that is returning a matrix. I want to edit this to only return a vector, where this vector contains the sum of each row. I tried applying sum(), but that summed every element of ...
1
vote
0answers
12 views

Google Spreadsheet limit ArrayFormula

I'm using ArrayFormula to calculate multiple ranges and its slow because its trying to calculate everything in that range even though it has nothing in it. Is there a way i can limit the ArrayFormula ...
0
votes
1answer
34 views

Resolved: Enumerating every other array element in loop

I have a dynamic array with key-pair values and I’d like to enumerate every other value. In this case, just the names in the array. Since I’m not using bash v4, I have been able to use seq to step ...
0
votes
0answers
13 views

PHP: Print array to template without template engine [migrated]

I have a simple associative array in PHP containing data I like to print out in a format specified by a HTML template. The template would look something like this: <html><head>Some ...
0
votes
1answer
28 views

Excel horizontal only sum of an array (matrix)

I have a formula which generates a 2D array result. For example: {=ROW(4:6)^TRANSPOSE(ROW(1:3))} (the curly brackets are added by excel when you hit CTRL+SHIFT+ENTER ) I need to sum only the ...
0
votes
2answers
23 views

Excel formula to generate a custom array result

I have a formula in excel which contains an array; {1,2,3} its use can be seen at I would like to generate it dynamically eg arrayfun(4) would generate {1,2,3,4}. I can generate a very long array with ...
0
votes
0answers
13 views

edit nested plist array. os 10.10

here is my scenario I can read from a plist the array but I ned to remove a line form the array. MacBook-Air:~ user$ /usr/libexec/PlistBuddy -c "print menuExtras" ...
0
votes
1answer
26 views

BASH associative array rearrange keys

I am running into a weird issue with associative arrays in bash. I have the following files in a directory: ls -lart drwxr-xr-x. 3 root root 4096 Feb 9 11:14 .. -rw-r--r-- 1 root root 3275 Feb 9 ...
1
vote
0answers
22 views

How to switch off “you can use new shorter array creation syntax” hint in NetBeans IDE 8.0.2?

I use NetBeans IDE 8.0.2 on Linux Mint. I searched through the options few times, but I can never find the option to switch this hint off in there. I know well about the new syntax in PHP, but I ...
1
vote
1answer
141 views

Excel 2010 - Need to sum dynamic range based on trailing 3 months

I am trying to sum a dynamic range for a list of entries 3 months before and 3 months after a specific month. I think I need to use an array to get this, but I'm not able to find what I need to do. ...
1
vote
1answer
30 views

how to get the array size in ms excel?

I would like to write a formula which returns the size of an array. something like size(A1:A50) Maybe, it seems to be strange; but it helps me when I insert some new rows in the first 50 lines and ...
0
votes
1answer
17 views

Trucrypt volume on Raid5

I have a NAS with the system disk on SSD and 8 HDD's in a RAID5 configuration (using an IBM5015 card). The RAID5 volume is encrypted using truecrypt. What happens if the computer dies ? My raid card ...
0
votes
0answers
40 views

Matlab extract numbers from cell with mixed contents

I have a cell array with different datatypes, from an excel sheet that I need to read in, but which is beyond my control. [~, ~, raw] = xlsread(xlsFile) raw is now a r-by-c cell vector, for ...
0
votes
1answer
28 views

Excel cell value (text) based on 2nd cell value (number) appearing in a named range

I have a spreadsheet where I want a contact name to appear in a cell (F166) if the department number (P166) appears in a named range ("PS Depts" on Sheet2). Here is my existing formula, but it only ...
0
votes
0answers
80 views

Delete RAID Array via PERC BIOS?

I have a an older PowerEdge 800 with a PERC 4/DC controller and RAID 1 array. Its running Windows Server 2008, and it serves as my file server (among a few other roles). I've swapped out all the ...
-1
votes
2answers
49 views

What is the equivalent of pathmunge() in csh?

In bash, a common function implemented in e.g. /etc/bashrc is pathmunge(), which appends or prepends a path to PATH if it isn't already listed among the elements in PATH. Example: $ echo $PATH ...
1
vote
5answers
9k views

Excel VBA - adding an element to the end of an array

Simpel Question I like to add a value to the end of an array and increase it automatically? I was not able to find such a simple example Public Function toArray(range As range) Dim arr() As Variant ...
0
votes
0answers
104 views

How to setup an array to capture output from ffmpeg volumedetect command

If you query a media file using a command such as ffmpeg -i amediafile.mp4 -af "volumedetect" -f null /dev/null you get output including.... [Parsed_volumedetect_0 @ 0x181d0a0] n_samples: ...
0
votes
1answer
113 views

AutoIt script hangs for no apparent reason

I am stuck with this script. For ages it didn't work. And then suddenly it did...and now...on a reinstall...it doesn't work again. It stops on the first winwaitactive line. The folder is most ...
0
votes
1answer
61 views

Powershell Get File Shares Into Array

I am trying to get a list of folders shared on a file server, and put them into an array. This is the code I have at the moment: $FileServer = "ServerName" [array]$FileServerShares = gwmi ...
0
votes
1answer
101 views

Replacing subString in an array with bash

What I got: array[0]="Programm is Running" array[1]="programm is down" What I want: array[0]="Programm is \e[0;32mRunning\e[0m" array[1]="programm is \e[0;31mDown\e[0m" This will make things a ...
-3
votes
1answer
143 views

What type of hard drives can be used in storage server [closed]

First of all i am not asking for any shopping Recommendation but i want to know about this product on ebay ...
-2
votes
2answers
66 views

identify the rows with the lowest values in an array based on identical values in a column of that array

I have an array of product data which includes code, description and cost. code is unique, cost is numeric and description is non-unique. Please see example. How can I select the cheapest of each ...
0
votes
0answers
96 views

Bash, transforming a string list of words in a array

Sorry if I post a question on a topic discussed dozens of times. I'm trying to work on an element of an associative array and assign it to an array. I know that in bash associative arrays are ...
1
vote
1answer
100 views

can't seem to populate bash array with new elements using '+=' operator

Like the title says. Trying to populate an array from zenity checklist output. Here is the function I want to run, but fails: function fSongType() { mType=$(zenity --list --title "Random song ...
0
votes
2answers
273 views

In associative arrays, assigning index and value at the same time

In a bash script I found the following but though it works I cannot understand its logic REMOTESNAPS+=(["$FS"]=" $SNAP") The statement above adds an element to the associative array REMOTESNAP by ...
-1
votes
1answer
94 views

Parsing arrays in PHP [closed]

I am developing a PHP application and I have the following array: print_r($array) Array ( [0] => stdClass Object ( [can_see_custom_stories] => 1 [name] => caitlinhamm ...
0
votes
2answers
6k views

List values based on criteria

I have a table on a worksheet called "DealSetup" that looks like this simplified version: A B 1 John Doe 1 2 Jane Doe 1 3 Mark Doe 2 4 Doug Doe 1 5 Mary Doe 2 I ...
0
votes
2answers
63 views

Force a one-dimensional array into a constant in Excel

I have a condition in an Excel IF-statement as follows: INDIRECT(ADDRESS(ROW(ME3),MATCH("PremiumWaiver",$1:$1,0)))=1 where INDIRECT(ADDRESS(ROW(ME3),MATCH("PremiumWaiver",$1:$1,0))) eveluates to ...
2
votes
1answer
84 views

What type of port is this?

What type of port is this? It is on the back of an older (circa 2006) EMC Array.
1
vote
1answer
123 views

How woulld I add $OPTARGs from one arg to an array

So I'm trying to add values from an optarg to an array. I've got: arrays=() while getopts a: args; do case $args in a) arrays+=$OPTARG;; esac done echo $arrays[@] When I run the script, ...
1
vote
1answer
2k views

Is there a way to use a name range as an array criteria for a sum(countif()) formula in Excel 2010

Picture column A full of comments like feedback from a survey question. Now picture column B with a formula which counts occurrances of particular key words within each comment. I am currently using ...
1
vote
0answers
549 views

md0 RAID1 can't read superblock

i have a problem with my md0 array, which is an raid1 (2 mirrored USB-Sticks) Mount gives "Can't read superblock" cat /proc/mdstat: Personalities : unused devices: <none> fdisk -l ...
4
votes
3answers
409 views

Spawning multiple parallel wgets and storing results in a bash array to be pretty printed when all wgets are done

I have a long list of urls on my own website listed in a carriage return seperated text file. So for instance: http:/www.mysite.com/url1.html http:/www.mysite.com/url2.html ...
0
votes
1answer
2k views

In Excel I need to find data matches between two arrays - one horizontal and one vertical

In Excel 2010 (or 2007 - I have both, although my OS is only Win7 32 bit as a limitation for some legacy applications we run), I need to find how I can find and return the matching value from two data ...
0
votes
1answer
87 views

Which cable do I need?

I just bought an HP MSA30 hard drive array. I believe it's the dual bus model because the interface card looks like this.... Can anyone tell me what type of cable I need to connect this to my ...
0
votes
1answer
505 views

cell array of strings to matlab structure

I need to create a matlab structure as such ds=struct('name',{{'my_name_is'},{'matlab_thining_hair'}}) which stores as a 1x2 structure array with a field name. A call to ds.name generates the output: ...
-1
votes
2answers
179 views

I will need a formula showing counts, totals and sub-totals for data set from different sheet

I am using MS2003 EXCEL. I have a cell in Sheet 1 with a color value and totals, with sub-totals. On sheet 2, I have a data set with 3 columns (colors, dress, type). On Sheet 1, I will need a ...
2
votes
2answers
251 views

Swapping RAID sets in and out of the same controller

This is a really simple question, and the answer is probably encoded in various wikipedia articles, however my question is reasonably specific, and I need a bulletproof answer! I'm not sure if my ...
1
vote
1answer
2k views

Expand Synology SHR volume with varying disk sizes

I'm looking for a clarification on SHR and how it handles expanding a volume when the volume contains varying disk sizes. I've read the Synology Documentation and it still isn't clear, because their ...
1
vote
2answers
2k views

Extract values from a range that are missing from another

I've got two columns in Excel, "ROSTER" and "PRESENT", shown below: Is there a formula to achieve the "NOT HERE" column? I tried using VLOOKUP() and http://superuser.com/a/289653/135912 to no avail ...
1
vote
1answer
309 views

Restoring Raid 5 Meta data / Table

2 part question at end of this text My problem: My CMOS was cleared, BIOS was set to IDE instead of RAID. My understanding (from other sites) is that motherboard Intel ICH10R data is stored in BIOS ...
2
votes
1answer
3k views

How to return first non-blank cell and if it's already a value before it, return the third non-blank and so on?

How to make a function which would return the first non-blank cell value but if it's defined in the left cells next to it, it would jump 2 cells and look for the next value. Table: 1 | 2 | 3 | 4 | ...
3
votes
2answers
2k views

Word macro: how to replace strings in a text, based on a 2 column-table?

So I have a series of strings that I'd like to search and replace in Word documents. My strings would be displayed as a two-column table. I'd probably create the table with Word, then would convert ...
1
vote
1answer
591 views

Debian 6 with Smart Array 5i

I have a HP (Compaq) DL 380 G3 which I want to install Debian 6 on. It has been running Debian 5 for a long time without any problems, but now when I want to reinstall the machine to Debian 6 it can't ...
0
votes
2answers
201 views

Array support for the original bash in MacOS 10.4.0?

I'm writing a bash script using simple array operations like: testarray=("First Name" "Second Name" "Third Name") ; for i in "${testarray[@]}" ; do echo "$i" ; done What bash version number came ...
11
votes
5answers
36k views

Test if element is in array in bash

Is there a nice way of checking if an array has an element in bash (better than looping through)? Alternatively, is there another way to check if a number or string equals any of a set of predefined ...
0
votes
1answer
578 views

Detecting Array

I restarted my machine today and now it wont boot. it runs through the main bios, then it gives me a second message saying Media rom bios detecting array... and halts. any advice would be much ...