formula

  1. R

    Formula calculating time between 2 date/times

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

    Gallery not filtering properly

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

    formula to generate multilevel list numbering

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

    Smooth monthly trend to achieve assumed average YoY growth

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

    Formula for calculating between 2 dates

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

    Multiple conditions

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

    Sort Unique value

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

    =LOOP?

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

    LOOKUP for each comma delimited item

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

    Access data from a closed workbook

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

    Index/Match Formula Returning N/A

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

    FORMULA EXPANSION

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

    Check box and Vlookups

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

    Check box and Vlookup

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

    days inbetween or column matching

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

    Finance P/L and Day P/L Formula

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

    Insert string before delimiter

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

    sumif with text and number and special symbol

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

    row to column - vba or code or formula

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

    filter data or any other option - don't want to copy formula in all cells

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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top