formula

Why doesn't Excel create a new formula that allows some simple programming language logics like LOOPS, FORLOOPS. i.e =LOOP()

I want to achieve the following results, How can I do this without VBA, only formulas? Output: Actor Movie Result Actor Desired Result Movies Actor 1, Actor 2, Actor 3 Oppenheimer Actor 1 Oppenheimer, Barbie Actor 1 Barbie Actor 2 Oppenheimer, Spiderman Actor 2...

Hi all! I have a report that is generated weekly for example 2401, 2402, 2403 etc. Is there a way that i can access data of these workbook from a master sheet. I have a formula that basically concatenates to the sheet name eg P:\weekly exports\2404.xlsm Is there a formula or vba that lets me...

Hi, I'm creating a cashflow spreadsheet to track the outgoings from various sources and have used an index match formula to track from different projects into one summary sheet. The formula works fine for the BACS column, but for my CC and ACC columns it returns a #N/A. Can anyone help with...

I have a sheet with 6 check boxes, i have the below formula that will complete a Vlookup when the check box is ticked, what i now need to know how to do is adapt the formula to complete Vlookups when several check boxes are ticked, and then put the result of the vlookups into one cell. This...

I have a sheet with 6 check boxes, i have the below formula that will complete a Vlookup when the check box is ticked, what i now need to know how to do is adapt the formula to complete Vlookups when several check boxes are ticked, and then put the result of the vlookups into one cell. This...

Hi, I have several check boxes within a sheet that when ticked will perform a Vlookup and return the value required, this is the formula that i have that currently works as intended =IF(C4=TRUE,(VLOOKUP(A4,Sheet2!B2:E30,4,FALSE)) What i also want to explore is the addition of the ISBLANK...

Hello, so i need help with a quick formula with hopefully a easy solution I have below and im trying to find out days between action 1 and action 2 i need it to do it ased off of loan number and compare action 1 to action 2 in column H i took out all personal info note loan numbers are not...

BCDEFGHIJKLMNOPQR2TRACKING SHEET3# of Trades3Winners3.00004Batting Avg100.00%Losers0.00005Sharpe Ratio#DIV/0!Breakeven0.00006Avg ROI84.95%Avg Risk1.17077Commission#REF!Avg Winner45.41338Overall P/L$136.24Avg Loser#DIV/0!910DateSymbolPositionSharesFillExitExit HalfExit QtrEntryStopRisk...

Greetings Excel Community, I am attempting to insert or duplicate a string value within a naming convention without having to do input manually. Is there a formula or a macro code that might be able to complete this possibly? Via the example below, I am attempting to duplicate the ID value...

we want to do following first we want to use unique value from sheet1!B1:B to Sheet2!B1 after that sum if condition match in Sheet2!C2 after that sum if condition if match in Sheet2!D2 query sheet...

we have the following data and we have copy the sheet1!B2:C2 and pasted on Sheet2!B2 and transposed it, again we have copied the data from Sheet1!B3:D3 and again pasted on Sheet2!B3 we will copy the data and check last filled row in sheet2 and paste transposed data in sheet1 data may be long...

Hi, we have the data in sheet1 and sheet2 and using index and match formula, its working fine but we don't want to drag and drop formula from C2:C4 and again we have used formula in D2:D4, there is any formula from which we can get desired result so that don't do drop down SHEET1 125024568765...

I am developing a power apps site, for this I am creating a booking site I created a list in share where I located the available slots for the day I type the formula for filtering the slots only to show the slots available for the selected date and also to be greater than the current time but...

Hi, we want to transpose some data from multiple column, is there any option to do it Query Table CodeAmountQty123456789101234567891012345678910807808824793812109113165266101112118081131SD-DE-16853808125901132428661651 Result Table...

Hi, we have the following sheet where we want to split in row wise instead of column wise, can we do this from macro or any formula, its a large database query sheet...

I'm missing something in my =countifs and =sumifs...I've gone in circles to the point where I'm going crosseyed. Basically... If Zak Astorg on Sheet 1 has 3+2+7 points, then Zak Astorg on Sheet 2 has 12 total points. What formula would you use to tabulate total points for each person across...

I am trying to do an array multiplication, multiply each of the months with the corresponding numbers from the 'Array' below, for example for "Person 1" do 0.1*150, then 0.2*250 and so on. As you can see it is returning #VALUE. Even if I try multiplying as an array, or multiply the numbers one...

I have 2 formulas that do what i need them to do separately =IF(COUNTIF(C3:C20, "Critical") = COUNTA(C3:C20), 0, IF(OR(COUNTIF(C3:C20, "N/A") > 0, COUNTIF(C3:C20, "") > 0), 0.79, 0.79 - (COUNTIF(C3:C20, "Critical") - 1) * 0.0465)) =IF(COUNTIF(C3:C20, "Critical") = COUNTA(C3:C20), 0...

Hi all, I'm trying to create a way to sequence rows automatically but cant seem to find the smart/short way for it. So far i am able to build the way to sequence the Primary rows, and the secondary in a different column. My problem comes later when trying to concatenate them or put them...