The array tag has no usage guidance.

**2**

votes

**2**answers

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

**0**

votes

**0**answers

43 views

### Condensing a Formula checking numerous Countifs across rows and columns

I am trying to find a way to turn the below equation into something less cumbersome. Basically I have an array of Countifs which are checking table data to see if the selected person is taking 10 mg ...

**-2**

votes

**0**answers

24 views

### Marking column B with AAA until 70% of value of array in column A is achieved

Can you please help me out with below problem?
I need to mark all cells in column B, until 70% of highest % in column A is achieved?
Column A is array with % in total sum 100%. I need to take ...

**0**

votes

**2**answers

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

**0**

votes

**0**answers

10 views

### Selecting only flagged observations from one worksheet for calculation on another worksheet

I've inherited my first Excel model and need to get it to calculate faster. As it stands now, there's a dataset on one of the worksheets that is 50,000 x 20, to which an additional 30 or so columns ...

**1**

vote

**1**answer

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

**0**

votes

**1**answer

70 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

14 views

### Trying to show in one cell the date at which a cash flow will become negative

I made a cash flow projections sheet with columns going from D to FE and Rows going from 1 to 65.
On the top of each column I have a row with dates from D8 to FE8.
On the bottom I have a row with ...

**1**

vote

**1**answer

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

**0**

votes

**1**answer

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

**-1**

votes

**1**answer

45 views

### Filter an Array into another page of an excel spreadheet

I have an excel table that includes one column that lists Y, N, N/A, or Blank. I need my filter to pull the rows that include the N, or Blank and paste them into another page of the spreadsheet.
I ...

**1**

vote

**1**answer

32 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

28 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

**0**

votes

**1**answer

44 views

### VBA macro crashes when using variable Ranges instead of fixed ones

I've tried to include comments with the code to make it readable, especially as I'm sure there are better ways of doing this!
I have a table with purchases and sales for a specific product. E.g.
ID ...

**1**

vote

**1**answer

19 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
}

**0**

votes

**1**answer

31 views

### How do I zero out an SAS hard drive which is part of a Dot Hill array?

I am helping a friend who has a Dot Hill Array (server?) and a full set of SAS drives that go with it.
The end goal is to zero out the drives so they can be re-used or sold. What I don't know... is ...

**6**

votes

**1**answer

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

**0**

votes

**1**answer

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

**1**

vote

**2**answers

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

**0**

votes

**4**answers

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

**1**

vote

**1**answer

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

**-1**

votes

**1**answer

53 views

### Array formulas and Logic, checking against multiple criteria

I'm currently just troubleshooting a report spreadsheet I've written. The logic I had written isn't working, so I thought I'd see if I could ask for some help here.
Essentially, I have a list of ...

**3**

votes

**2**answers

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

**1**

vote

**0**answers

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

**0**

votes

**0**answers

49 views

### SUMPRODUCT & ROUND

Is there a way to get the product of the array with conditions to round to the 2nd decimal place before summing?
Current formula w/o rounding:
...

**1**

vote

**0**answers

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

**0**

votes

**1**answer

825 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

**1**answer

192 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

**1**answer

330 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

**2**answers

73 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

**0**answers

39 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

**1**answer

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

**2**

votes

**0**answers

74 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

**1**answer

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

**1**answer

58 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

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

**0**

votes

**1**answer

137 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

**1**answer

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

**-1**

votes

**2**answers

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

**0**

votes

**1**answer

223 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

**1**answer

111 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

**1**answer

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

**-2**

votes

**1**answer

183 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

**2**answers

93 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

**0**answers

143 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

**1**answer

156 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

**2**answers

374 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

**1**answer

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

**1**

vote

**2**answers

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

**2**answers

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