Given this rule to follow: And I have some value to check from this: Where cell AA727 is a result of some calculations which I already formatted into a number
I have the above cells and i want to substract each individual row . i.e. 137.61-137.61, 132.88-270.49 and print each one of the results on the respective row
I want to count the results of a FILTER in excel. Usually I do something like IF( IFERROR( SUM( FILTER( range, condition)
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