flow

  1. N

    Excel for solving coupled PDE

    Hi, I am trying to solve Coupled PDE describing flow of two fluids in centrifugal field. PDEs are solved using Newton iteration method using fully implicit scheme for pressure and saturations. In short, I established a matrix of partial derivatives (Jacobian), which are used to find incremets...
  2. A

    Power Automate Flow Keeps failing

    i have a power automate flow that basically a form submission happens, it send an email with an approve or reject then it should send an email to the submitter whether they have been approved or rejected BUT when i click approve on the email i get submission has been reassigned
  3. A

    How to run a Power Automate add-in from VBA?

    Hi Guys, I have a USERFORM managed database, and I want to add a new feature to create MS Planner tasks from the Excel. I couldn't do that, but now I can do it from Power Automate --> Flow. The only thing I would need to automate to run the Flow from the VBA. Do you have any idea, how to do it...
  4. J

    Two lines of text using alt+enter for the line break: whether text wrap is checked, am I forced to merge cells?

    Hello, thank you so much for the help that's so kindly given here always! :) I want/need to do something so simple, it's got to be possible. Whether I have text wrap selected in Format Cells or not, it seems impossible to allow two lines of text I've created (using an alt+Return) to flow...
  5. B

    Is there a "Mr MS Flow" out there?

    Hello World, My work is upgrading Office 365 and I've seen a demonstration of MS Flow which looks like the personal automation revolution that Excel VBA was 20+ years ago. I've learnt so much from this forum but now I am wondering if there is a forum for Flow. I wait with baited breath, Thanks,
  6. I

    Lots of sheets

    Hi folks! I just created an account, because i need some help. I have lots of excel sheets. All are linked together. It is just a mess. So i am trying to visualize the flow of data through all sheets. I already made a table with all sheets and all dependencies. It looks like as follow...
  7. L

    Automating advancing from one worksheet to another

    2 workbooks. One called "Cash Flow"; the other called "Budget" In the workbook Cash Flow, there are different months on each worksheet (January, Feb etc). Within Budget, there are columns titled Jan, Feb, etc. I want to pull a specific cell or range of cells within January (Cash Flow) and...
  8. M

    vlookup using Sum and "<>"

    I have a spreadsheet that I want to pull data from 5 different columns using SUM(VLOOKUP as an array. Problem some of the cells may be blank which leads to an #N/A error. I attempted this: {=IFNA(SUM(VLOOKUP(AB8,'Cash Flow Detail '!B12:AN94,"<>",{24,26,31,33,39})),0)} however that returns a...
  9. W

    Extracting split values from table based on dynamic input

    Hello, I am performing a hydraulic study on a water treatment plant and I have run into something I don't know how to do. This plant has four clarifiers (two different sizes) fed by a splitter box that does not distribute the flow evenly. I need to take the calculated flow and put that into a...
  10. D

    External table is not in expected format

    Hi Everyone, I am using power query to access a file from share point. I used Microsoft flow to connect an email folder to outlook (get attachment). This folder will receive an attachment everyday. So far only two days this flow has worked. Here is the error that I am getting. "External table...
  11. E

    Looking for a Similar Forum for MS Flow

    Good Day!! I am a long time user of the Mr. Excel Forums. THEY ARE GREAT!!! I am looking for recommendations for a similar forum for Microsoft Flow. Thank you in advance!
  12. C

    IF statement for flow chart

    I have a 4 step flow chart to follow to put the correct item in the cell dependent on what' in previous cells. Is it possible for me to use a, long, IF statement? The flow chart will never change so I'd only need to do it once! The flow chart is Is it A or B If A, is it 1 or 2. If B, is it 3...
  13. M

    SUMIF INDEX MATCH ERROR #Value

    Hi I am having trouble with the below formula. The formula returns #value . I'm hoping someone can spot something that I can't see. =SUMIFS(((INDEX('Cash Flow items'!$C$4:$J$5,MATCH('Outflow Summary'!$B4,'Cash Flow items'!$B$4:$B$5,0),MATCH('Outflow Summary'!$C4,'Cash Flow...
  14. T

    Hold on the flow of execution

    Hi All, I am trying to automate mail sending process. Now, the code which I have is working fine. But I want to add more functionality to it. After ML.Display in the below code snippet, I want to hold on the flow of execution. ML.Display will display the mail which is ready. After that I want...
  15. K

    VBA code

    Hi all, i'd like to ask for any help for my request. Sheet1, my data in/out flow frequency for every week(updated once a week) Sheet2, my request. i need to process sequence & accurate: -by date, by time flow, by EP01IN/EP01OUT, EP02IN/EP02OUT.....(even more).... -Sheet2 is no necessary to...
  16. B

    A flow problem

    Hi, This is a flow, (transportation, graph, etc.) problem below. Variables and their values are given in Columns A and B. Situations based on Variable 1 and Variable 2 are given at the D,E and F columns. The total flow must not be longer than 10. If so, it means overload and skip that step...
  17. P

    NPV with a positive initial cashflow

    Hi Mr Excel - new user. In this project a property is being vested in a company (title transfer with out cost) thus no initial capital out lay. Positive cash flow revenue commences immediately. In the third year of ownership there is an obligation to leverage the assets value i.e. take out a...
  18. J

    Sorting 1 column in a table

    Is there a way to sort 1 column in excel alapheticly and then numerically? This is for a flow in a warehouse. My flow goes 2a1.1, 2a1.2, 2a2.3, 2a3.4, 2a4.3, 2a5.3, 2a6.1, 2a7.3, 2a8.1, 2a9.3 2a10.1 and so on. The problem being when I sort alapheticly I doesn't sort it I the correct order. The...
  19. N

    Cash flow by date and type

    Hi, I had an old template with a formula that doesn't seem to exist in Excel 2016. =CashFlowForecast($B$3,J$6,$F12,$H12,$G12,$E12,'Cash Curves'!$A$2:$E$403,$D12)-SUM($H12:I12) This formula allowed me to cash flow my budget by date and then by type (front-loaded, back-end loaded, linear and...
  20. P

    Flow down information based on project number

    Hi all! I have an Excel sheet where I want to flow down information based on a cell value. My Excel spreadsheet contains a list of project numbers in two levels (always the base level which contains project information, and level 1 which doesn't contain that information). The list I have is a...

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