array data

I need to create a verification list for each employee that contains their assigned roles and the documents asociated with that role. Source Data Table 1: Wherein the supervisor assigns various roles to staff. I have used data validation to restrict the value of each column to either blank or...

<tbody> Invoice Invoice Amount Credit Reason Credit Amount Reference inv1 A $ -15 inv2 E $ -100 inv6 inv3 E $ -25 inv7 inv4 E $ -50 inv8 inv5 C $ -30 inv6 $100 inv7 $25 inv8 $75 inv9 A $ 5 Inv10 B $ -67 Inv11 E $ -45 Inv12 E $ 80 </tbody> Trying...

Hello All, I have an array formula that is only working when the linked spreadsheet is open. I am referencing a table, is that the problem? The formula when both sheets are open: {=IF(ROWS(B$6:B6)>$G$2,"",INDEX('[Serial Number Tracking.xlsm]Serial Credit Sheet'!A$2:A$76049,SMALL(IF('Serial...

Hello All, This might be very easy for some of you. I have a data sheet like below: ID P1 P2 ... Pn 1 A 2 A B 3 B A .... C . . So in each row there are different number of columns with values. Id like to arrange it into; ID P Rank 1 A First 2 A First 2 B Last 3 B First 3...

Hi, I have an Excel table with different dates, times, etc. This table can be divided into 3 ranges or arrays, based on column 'C'. 'A' --- 'B' --- 'C' date - time - 1 date - time - 1 date - time - 2 date - time - 3 date - time - 3 date - time - 3 etc. I'd like to know how in <acronym...

Hi, I have been looking and can't seem to get this to work. First, I have two input files that I store into two arrays (Example Below). I need to link a specific event in Array 1 with that in Array 2 and calculate the difference in time. To make it more challenging there may be an event in...

I need to use the ttest function. The format of the ttest command is: ttest (array1, array2, tails, type). However, my data are not in adjacent cells, which is the way I'm used to using array data (e.g. A2:A10 would be array 1). Is there a way to select several non-adjacent cells as an...