The array tag has no usage guidance.

**10**

votes

**5**answers

52k 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 ...

**6**

votes

**4**answers

7k views

### how do I merge an array of images into a single giant image?

I have 220 png images of equal height and width with the following naming convention:
A1.png, A2.png, ... V9.png, V10.png
I need to merge them into one giant image, with A1 being the top left corner,...

**6**

votes

**4**answers

319 views

### Excel INDEX MATCH Checking Multiple Columns

The problem I'm essentially trying to solve is a VLOOKUP that is checking Columns A:E for a value, and returning the value held in Column F should it be found in any of these.
With VLOOKUP not being ...

**6**

votes

**1**answer

235 views

### Use functions like Countif, Countblank etc. to refer to discontiguous ranges.

Is there a way to use array formulas or some other feature to essentially have an excel function that means.
=Countblank({A1,A4:A6,A112:127,B29:B38}) etc.
Essentially, I want to refer to multiple ...

**4**

votes

**3**answers

727 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
http:/www.mysite.com/url3....

**3**

votes

**2**answers

3k 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 ...

**3**

votes

**0**answers

114 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 don'...

**3**

votes

**2**answers

790 views

### Excel, how to use text functions on lookup array without putting in another column?

If I'm using a vlookup, or a match function but I need to do some mumbo jumbo on my lookup material, is there a way of doing this in the lookup array without simply adding another column?
Let's say I ...

**2**

votes

**2**answers

3k 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 ...

**2**

votes

**1**answer

88 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.

**2**

votes

**1**answer

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 | ...

**2**

votes

**2**answers

115 views

### How to flag rows with the pattern non-blank, blank, non-blank using Excel

I would like your help with something I have been trying to figure out for the past two days.
I have data with 1000's of rows and several columns. I want to insert a column with a (array) formula ...

**2**

votes

**2**answers

91 views

### How to highlight boundaries of an array in Excel?

I'd like to know if there's a way to make excel show me where are the boundaries of an array, like the highlight I made in the picture below.
Some explanation: I have a worksheet that is full of ...

**2**

votes

**1**answer

3k 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.
...

**2**

votes

**2**answers

21k 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 ...

**2**

votes

**1**answer

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 ...

**2**

votes

**1**answer

75 views

### Trying to create a formula to calculate a rate value per row in Excel

I think this is to do with a formula over an array but I can’t get it to work.
I’m looking for the easiest method to do the following.
Say I have this setup, columns are 'jobs' and rows are '...

**2**

votes

**2**answers

395 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

**2**answers

6k 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

**2**answers

40 views

### Split a column interspersed with zeros into separate columns in Excel, while breaking at zeros

I am looking to split a column array interspersed with zeros into separate columns in Excel while breaking at the zeros in the column and ignoring the zeros.
For example, if I have an array {1,2,3,0,...

**1**

vote

**2**answers

39 views

### Retrieve the array indexes from a range

I am facing an issue where I need to input column indexes from 1 to 1220 in the VLOOKUP function
{=SUM(VLOOKUP(A2,sheet1!$A$3:$AC$11, {1,2, 3, 4, 5, 6, ..., 1219, 1220}, TRUE))}
The only solution I ...

**1**

vote

**2**answers

23 views

### Find correspondent row in array

I've a product's list containing each product's weight. I've another table with ranges of weights, and each range has a different storage cost.
I'd like to have a formula that identifies in which ...

**1**

vote

**1**answer

184 views

### Make an array formula in excel calculate only on active rows

When excel calculates formulas over a column (e.g. a lookup), it's smart enough to only calculate until the last active row, rather than also running on all the blank rows.
With array formulas, it ...

**1**

vote

**1**answer

34 views

### Display Associative array in awk

How can I display Associative array, when I don't know index?
My script:
{
tab[$1]=tab[$1]+1
}
END{
print tab[*]#display array -> it doesn't work
}

**1**

vote

**2**answers

285 views

### Excel 2010 Array Formula (CSE) Dynamic cell range/reference; index? offset?

This might be an easy question to some but I am completely lost so I would really appreciate any help out there!
A
1 10
2 20
3 30
4 40
5 50
6 60
7 70
...

**1**

vote

**1**answer

103 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 ...

**1**

vote

**1**answer

185 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

**1**answer

857 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**

vote

**1**answer

399 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 ...

**1**

vote

**1**answer

155 views

### How to count number of cells over multiple worksheets whose values are in between a given range?

I have an Excel workbook with numerous worksheets containing data like:
'DATA_1' 'DATA_2' 'DATA_3'
A B A ...

**1**

vote

**1**answer

118 views

### INDEX( SMALL( IF(… resulting in #NUM today, yesterday was correct

{=INDEX(Sheet1!$A:$M,SMALL(IF(Sheet1!$O:$O=TRUE,ROW(Sheet1!$O:$O)),ROW(1:1)),1)}
Yesterday it was full of useful values today there are #NUM errors in every cell. Not sure what went awry? Any ...

**1**

vote

**0**answers

29 views

### Return 'dir' command results into array/list [duplicate]

I want to know how to return the output of the dir command into an array.
I'm using the command like this: dir /s /b *.txt how would I put each result (file name) into an array/list.
Thanks

**1**

vote

**0**answers

145 views

### Properly extracting from an array

I have a CSV with one column, numbers formatted as 111-0000, that I'm reading in to process one at a time. I'm trying to import the column of information from the CSV, but I'm having trouble figuring ...

**1**

vote

**0**answers

46 views

### Where does the calculation take place? [closed]

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 resources,...

**1**

vote

**1**answer

203 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 ...

**1**

vote

**0**answers

811 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
...

**1**

vote

**1**answer

611 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

**2**answers

210 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 ...

**0**

votes

**2**answers

455 views

### Excel array functions — how to count non-blank cells over multiple worksheets?

I have an Excel workbook with numerous worksheets, some of them containing a numeric value in cell A1:
'DATA_1' 'DATA_2' 'DATA_3'
A A A
1 1....

**0**

votes

**1**answer

870 views

### Add hashes with duplicate keys to array

I have a bunch of hashes in powershell with identical keys. Though creating an array of hashes with different keys is straightforward and thoroughly discussed on the internet, I'm unable to find any ...

**0**

votes

**1**answer

429 views

### 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

**2**answers

153 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

**1**answer

30 views

### Excel Formula that autofill an array with a list, based on an array

I'm trying to do a formula that within a range makes a list based on info on a specific array.
What I need is an array that aufills this list based on the following conditions:
1)It has to be the ...

**0**

votes

**1**answer

15 views

### Using an array as search criterea for find command

I'm wondering if it's possible to declare an array of file types to then be searched with via the find command?
So
fileTypes=(*.omf *.jpeg *.xml *.otf)
find . -name ${fileTypes}
Instead of:
find ...

**0**

votes

**1**answer

49 views

### MIN IF Array Function with Multiple 'is like' criteria

I think I have a good one.
I need a MIN-IF (and MAX-IF) on multiple criteria where near matches are required. I know how execute a MIN IF on multiple criteria using the product of many IF statements ...

**0**

votes

**1**answer

78 views

### Need unique count of text from multiple columns by category

My data looks something like (assume begins in A1):
Category,Label1,Label2
Dogs,blank,doe
Dogs,zoo,blank
Cats,zoo,yup
Cats,doe,hgg
Cats,blank,doe
What the result should look like:
Dogs,...

**0**

votes

**1**answer

38 views

### Excel 2010 Array (CSE) Formula: How to remove a part of contiguous (adjacent) range

I would really appreciate help on the following question:
Is there a way to write a formula that removes a segment from a contiguous range?
For example, say there is a formula =COUNTIF((A1:A100),">1"...

**0**

votes

**4**answers

827 views

### Excel: Sum values on a column based on criteria* on other columns *(complex criteria)

See below for rewrite.
Please refer to the data below for the question. The very top A B C are columns and the far left numbers 1 through 15 are rows. The rest are cells.
A B ...

**0**

votes

**1**answer

562 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

**1**answer

20 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 ...