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
My dataset looks like this: I am looking for a formula to add to the column "Status" to do the following: If Name = "A" and Project = "TT" and Number > 5, w