I have a grid which lists the Period (Start - End), and a list of Downtimes. The downtimes are then sorted (to ensure chronological order based on the start tim
Currently using the following forumlas to count the number of records in all of column Z that does not have #N/A but it does not work. All the rows in Column Z
I am after a way to pull a consistent group of rows with an equal spacing between each. Example: My data range is in A3:A250. I'd like to pull A3:A10,A15:A22,A2
Sorting I need help in the below formula that I am using to number the above table in the "Sorted Numbering" column. The formula that I am using basis which th
I have a spreadsheet of identification numbers, and various results for each. I used a couple formula to see if the subject passed or failed any of a set of cri
Using Office 365 Excel On a regular basis I download a csv file from a remote application, the file contains a column of unique numbers. There could be 50 rows
I have a table in a tab with columns: street_id, street_name, street_corner_1 and street_corner_2 (a street corner is the name of the street that intersects it
I just received an excel and see there are some formulas including some "_xlfn" and "_xlpm". What do they mean?
Is it possible to store some numbers in one cell (as an array)? Please see below: cell A1: 4,4,3,4,1,3,3,4 cell A2: 5 (5th element of array)
Trying to dynamically get cell value from worksheet in same workbook, depending on worksheet name in column E =IF(E108<>"",INDIRECT(CELL("contents", E108)
I am using this formula to pull the client's highest score: =MAX(IF(FILTER(Appointments!G:G, Appointments!C:C=C2)>0,FILTER(Appointments!G:G, Appointments!C:C
I would like to convert the number of digits in excel into respective words as shown in the picture above. How can I achieve this functionali
I am trying to use a vlookup / index to pull some numbers. Sample data attached: A: merged cells (the number is stored in the top of cell of the merge) B: Only
If I have table 1 with OrderIDs and CallIDs and table 2 with CallIDs (that are referenced in table 1) and callDates, how can I find the number of orders within
In Excel, I have index levels (1, 1.1, 1.2, 1.2.1, 2, etc.) and corresponding folder name. I want a function to be take each level and concatenate corresponding
I have a list of products that are sold in different regions. To find top opportunity though, I need to look at the National level. I am trying to rank product
I have a code which is doing following: Prompt to choose external workbook Copying all the data from that wb Pasting exactly 1:1 in main wb Close and Save fr
I need to write some VBA code which could give me the result in the "Sorted Numbering" column in the below picture: The logic for the sorting is that filter th
I want to count all the instances that "a" occurs in column a AND "b" occurs in both column b and c. This would be in a match up style. Essentially I am trying
How to extract / filter an inventory list (in range B3:C7) based on a lookup list with partial strings (in range F2:F3)? I know that if the filtering strings w