formula

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. brendalpzm

    Filter formula is not working

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

    Transpose from multiple column

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

    Split in row and auto insert row as per requirement

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

    What am I missing in my formula?

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

    How to multiply two arrays together

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

    Formula

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

    Sequence based on cell value

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

    Choose function under the filter function isn't working properly

    I am using excel365 online and but have excel2016 downloaded onto my computer. I am getting error messages but not sure why. The formula that I have is as follows: =FILTER(CHOOSE((1,2,3),'Employee_Name'!A:A,'Employee_Name'!J:J,'Employee_Name'!B:B),'Employee_Name'!G:G="Bob","") I have changed...
  15. Knockoutpie

    Excel Formula to check if two strings exist in the same row on a sheet without specifying the column

    Hello everyone, i'm trying to find out if there is a way to determine if two strings are in the same row somewhere on a sheet. Right now i'm half way there, my not so elegant solution is just to count if a string exists in a sheet. =COUNTIF('Sheet2'!3:100,Sheet1!B5) This formula checks Sheet...
  16. F

    Horizontal Sum (sum+match)

    I want to make this formula: =sum('MTD Data'!S11:U11) dynamic. =MATCH(A11,'MTD Data'!$B1:$B,0) returns the number 11, so instead of S11:U11 I want to take something like sum('MTD Data'!S(MATCH):U(MATCH)) that automatically returns S11:U11 What way is there do it?
  17. alketrazz

    SUMIFS, with specific value or ALL entries

    Hi I have this formula =SUM(SUMIFS(Data!$F:$F,Data!$P:$P,VolumePlan!$G45,Data!$O:$O,IF(nStockType="ALL",{"GBC","GBN","STK","VOR"},nStockType),Data!$N:$N,IF(nUnit="ALL",{2,4},nUnit))) This should sum the values in column F Column P where the value = to column G45 Column O where the value is...
  18. T

    Conditional Formatting for Date Comparisons

    I have a table where each row is a specific Individual ID Number, and each column corresponds to different dates a test was taken for that ID Number. The ID Numbers are in Column B, and the test dates go from Column H to Column AL. Column H is the baseline test, then every test after that is...
  19. E

    Formula to pull through data - changing sheet name

    Hi All, I'm looking for a formula to pull data a one cell in another sheet into a table on our summary sheet. The sheet name is contained in row A, the sheet name will increase by 1 for each row in the table. E.g. A3 = CR1, A4 = CR2. Is there a formula which I can use in my table which will...
  20. dannyok90

    Lookup based on column

    Hi all, i have a quick one, looking at the attached screenshot in h16 i have MAX looking at e10-f10 returning the highest number. i want to get the percentage from that column for the line i'm on if that makes sense :) Happy friday everyone! Dan

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