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
I have a spreadsheet which has a lot of duplicates I need to cleanse but need to ensure the right data in another column is kept. Data and desired outcome Esse
My workbook has two sheets, we will call them Summery and Events. In my Summery sheet, it looks like this Name Last Event Name 1 Event 3 Name 2 Event 15 In m
I have an array of non-ordered integers, and I am trying to return a TRUE or FALSE based on if x consecutive numbers can be found within the array Example array
I have the following range of values: National museum of Natural History Archaeological Museum, Art Museum, Agricultural Museum, Marine Museum National museum o
I'm designing a datasheet that updates itself automatically. All of the macro code is working properly, but I have trouble locating the place where the data sho