im getting the following error message when i run this code that lets me make folders if they don't exist to save files in them: "run time error 75 path/file ac
I've written the outside of a function as an Excel Lambda function. LAMBDA(Years, TextFmt, EndOfMonth, ByRows, LET( MonthNbrs, IF(ByRows, SEQUENCE(1
I'm trying to build a Schedule Generator using recursive LABMDA based on RANDBETWEEN function. Basically, what it needs to do: Generate a random date using RAND
I am stuck with an issue/ on how to approach this problem. In the attached image (sorry I am not allowed to add the image now and hence the link) you can see in
I was able to merge(inner join) a transaction table with an owner info table using account number as my key to get the following results: I need the transactio
As you can see on the screenshot, I have amounts in the left column and datas in the right. I need a formula or any other way to automatically extract the value
Please help me convert simple formula for auto increment with condition - =Arrayformula(if(D2:D="",,countifs(D2:D, D2:D, row(D2:D), "<="&row(D2:D)))) I'v
I don't know a lot in Excel but I want to add Multiple prefixes in Excel and let them loop until the number of cells ends. I used this Formula, but it picks the
how can I add rows in excel according to the cell value (as per example below). https://i.stack.imgur.com/q8MQG.png i want to add column D if column A contain '
Microsoft has announced many new array functions (https://techcommunity.microsoft.com/t5/excel-blog/announcing-new-text-and-array-functions/ba-p/3186066), inclu
I have a sheet where column B contains a list of Folders in R:\Jobs. The folder name is also the 'Job Name'. I use VBA to create a formula in Column F that look
Wordy title but I was interviewed on this question, couldn't derive the answer and really would love to better understand array usage in excel. Question: You ha
I have two columns in excel, one with a date and one with a rating 'low, medium, high'. I'm trying to write a formula to put in a third column that checks: If A
Suppose we have 2 cells, one contains zero and the other is empty, see the range A2:A3 in the figure: If they pass a FILTER we get two zeros as a result, see t
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