formula

I am having a bit of issue calculating time between 2 dates. hoping to do this in formula as the sheet is pretty long here is an example

I am creating a week view calendar with a vertical gallery, This gallery is linked to a SharePoint list where I have the date slots until july 20, 2024. I applied a filter to the gallery to show only the 7 days according to the month showing. The issue is that when I change to the next...

Hi all, I have a dataset that consists of multiple unique "Activities", that are grouped within a multilevel list like this: Focus area (Column A) Action (Column B) Deliverable (Column C) Activity (Column D) 1 1.1 1.1.1 1.1.1.1 1 1.2...

I am trying to create a formula that will populate 2024 values and show a smooth trend that ends up with the 2024 average being 3% higher than the 2023 average. When I average all of the months for 2024, it needs to come out to $71.71.The 3% assumption would be an input cell. Is there a way to...

Good morning ! I am in need of assistance with coming up with a formula that’ll provide me with an 2 month and 5 month evaluation dates for work without counting a summer period. (05/31/24-08/11/24) So let’s say a Hire Date is 01/01/24 2 month would be 03/01/24 5 month would be 05/01/24 But if...

I am trying to build a spreadsheet that has multiple condition. When I plug in my conditions into conditional formatting, it won't work. 1st condition: I want 3 rows to be filled in blue, with border and vertical lines highlighted, one line no fill/border, then the next 3 rows to be no fill...

we have the following data which we want to sort with serial 1. Samsung1. Samsung2. Sony2. Sony2. Sony4. Dell4. Dell4. Dell10. TVVS10. TVVS20. JBBL20. JBBL20. JBBL20. JBBL result sheet 1. Samsung2. Sony4. Dell10. TVVS20. JBBL help with formula please

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...