I have a list of unsigned 32-bit unsigned integers that actually are supposed to represent 32-bit signed integers. For example 62714 = binary 1111010011111010 =
I wish to find a way to find the three largest AuM values for each category and the Owner: I found the n-th largest AuM per category using the Large-formula co
I am looking for a formula to Count Specific date in Text String. My answers work with words, but if I use wildcards it doesn't work. W33 is the sample text bel
I have two sheets; Sheet1 & Sheet2 and want to link the format from A1 Sheet1 to A1 Sheet2, i.e. Sheet2 A1 should match the formatting of Sheet1 A1 I don't
ID Value Valid MAX Group3 2 NO 8 Group3 8 YES 8 Group1 4 YES 4 Group4 2 NO 1 Group4 3 NO 1 Group4 1 YES 1 Group1 2 YES 4 Group1
Let's say I wanted to find the average number of calls per day. Normally, I can use the formula =COUNT(A2:A15)/SUM(1/(COUNTIF(A2:A15,A2:A15))) for the table bel
I have two tables on two sheets - let's say tblFruits1 and tblFruits2. Both have a column "Name". Apple - for example - exists on both lists. The lists might ha
I am trying to figure out a formula that will count each row in a range, that contains any cell that is not empty. For example Item 1|Item 2|Item 3 Cat 1
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)